Report output in MS Excel format

[Anil Patel-2]

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

[Shi Jinghai]

> 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.

[Jacopo Cappellato]

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
>

[David E Jones]

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
>>
>

[Anil Patel-2]

Jacopo,
Thanks for the Idea, I think it should work for the users.

Regards
Anil Patel


On 6/7/07, Jacopo Cappellato <[hidden email]> 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
> >
>
>

[Tim Ruppert]

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

[Jacques Le Roux]

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
  À : [hidden email]
  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