You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Anil Patel <ap...@adititechlabs.com> on 2007/06/07 18:30:11 UTC
Report output in MS Excel format
Hi,
I have a requirement to be able to export data in MS Excel file format.
Has anybody done such thing? I'll appreciate some help or Ideas on How we
can export a Report in Ofbiz in Excel File Format.
Regards
Anil Patel
Re: Report output in MS Excel format
Posted by David E Jones <jo...@hotwaxmedia.com>.
Another really simple option is to export in a comma or tab-delimited format, and these can be opened easily in Excel and turned into a worksheet/book.
-David
Jacopo Cappellato wrote:
> Anil,
>
> you can simply create a screen with a form definition that renders your
> data (list) and then render the screen using the ScreenXmlViewHandler.
> For an example, see the "Export" link in the Facility->Inventory screen:
>
> https://localhost:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
>
>
> The data will be exported in an xml format that is readable by MS Excel.
> Let me know if you need more information.
>
> Jacopo
>
> Anil Patel wrote:
>> Hi,
>> I have a requirement to be able to export data in MS Excel file format.
>>
>> Has anybody done such thing? I'll appreciate some help or Ideas on How we
>> can export a Report in Ofbiz in Excel File Format.
>>
>> Regards
>> Anil Patel
>>
>
Re: Report output in MS Excel format
Posted by Anil Patel <ap...@adititechlabs.com>.
Jacopo,
Thanks for the Idea, I think it should work for the users.
Regards
Anil Patel
On 6/7/07, Jacopo Cappellato <ti...@sastau.it> wrote:
>
> Anil,
>
> you can simply create a screen with a form definition that renders your
> data (list) and then render the screen using the ScreenXmlViewHandler.
> For an example, see the "Export" link in the Facility->Inventory screen:
>
>
> https://localhost:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
>
> The data will be exported in an xml format that is readable by MS Excel.
> Let me know if you need more information.
>
> Jacopo
>
> Anil Patel wrote:
> > Hi,
> > I have a requirement to be able to export data in MS Excel file format.
> >
> > Has anybody done such thing? I'll appreciate some help or Ideas on How
> we
> > can export a Report in Ofbiz in Excel File Format.
> >
> > Regards
> > Anil Patel
> >
>
>
Re: Report output in MS Excel format
Posted by Jacques Le Roux <ja...@les7arts.com>.
The advantage of Jacopo's solution is that you can keep the HTML formatings inside the XML file : Excel will render most of them them (bold, underline, font, color, etc.)
My 2 cents
Jacques
----- Message d'origine -----
De : Tim Ruppert
À : user@ofbiz.apache.org
Envoyé : jeudi 7 juin 2007 19:08
Objet : Re: Report output in MS Excel format
Another way to look at it (which may not be the best way I admit, but I've done this in the past) - is to export a csv or tab-delimited file and set the mime type on the stream to the excel type format.
Cheers,
Tim
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com
o:801.649.6594
f:801.649.6595
On Jun 7, 2007, at 10:46 AM, Jacopo Cappellato wrote:
Anil,
you can simply create a screen with a form definition that renders your data (list) and then render the screen using the ScreenXmlViewHandler.
For an example, see the "Export" link in the Facility->Inventory screen:
https://localhost:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
The data will be exported in an xml format that is readable by MS Excel.
Let me know if you need more information.
Jacopo
Anil Patel wrote:
Hi,
I have a requirement to be able to export data in MS Excel file format.
Has anybody done such thing? I'll appreciate some help or Ideas on How we
can export a Report in Ofbiz in Excel File Format.
Regards
Anil Patel
Re: Report output in MS Excel format
Posted by Tim Ruppert <ti...@hotwaxmedia.com>.
Another way to look at it (which may not be the best way I admit, but
I've done this in the past) - is to export a csv or tab-delimited
file and set the mime type on the stream to the excel type format.
Cheers,
Tim
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com
o:801.649.6594
f:801.649.6595
On Jun 7, 2007, at 10:46 AM, Jacopo Cappellato wrote:
> Anil,
>
> you can simply create a screen with a form definition that renders
> your data (list) and then render the screen using the
> ScreenXmlViewHandler.
> For an example, see the "Export" link in the Facility->Inventory
> screen:
>
> https://localhost:8443/facility/control/
> ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
>
> The data will be exported in an xml format that is readable by MS
> Excel.
> Let me know if you need more information.
>
> Jacopo
>
> Anil Patel wrote:
>> Hi,
>> I have a requirement to be able to export data in MS Excel file
>> format.
>> Has anybody done such thing? I'll appreciate some help or Ideas on
>> How we
>> can export a Report in Ofbiz in Excel File Format.
>> Regards
>> Anil Patel
>
Re: Report output in MS Excel format
Posted by Jacopo Cappellato <ti...@sastau.it>.
Anil,
you can simply create a screen with a form definition that renders your
data (list) and then render the screen using the ScreenXmlViewHandler.
For an example, see the "Export" link in the Facility->Inventory screen:
https://localhost:8443/facility/control/ViewFacilityInventoryByProduct?facilityId=WebStoreWarehouse
The data will be exported in an xml format that is readable by MS Excel.
Let me know if you need more information.
Jacopo
Anil Patel wrote:
> Hi,
> I have a requirement to be able to export data in MS Excel file format.
>
> Has anybody done such thing? I'll appreciate some help or Ideas on How we
> can export a Report in Ofbiz in Excel File Format.
>
> Regards
> Anil Patel
>
Re: Report output in MS Excel format
Posted by Shi Jinghai <sh...@langhua.cn>.
> I have a requirement to be able to export data in MS Excel file format.
>
> Has anybody done such thing? I'll appreciate some help or Ideas on How we
> can export a Report in Ofbiz in Excel File Format.
POI is a choice, but I like jexcel very much.
Regards,
Shi Jinghai/Beijing Langhua Ltd.