StrataFrame Forum

Export businessobject to Excel

http://forum.strataframe.net/Topic21313.aspx

By Lesscher - 12/22/2008

Hi All,



Our customer wants to export data in the listviews to Excel. However, not all data is visible in the listviews.

Our idea is to export the complete businessobject (linked to the listviews) to Excel.



Does anyone have done this before? What is best practice here?



Already thanks!



Regards,





Lesscher
By Trent L. Taylor - 12/23/2008

Well, there are a lot of options.  But you can take the internal data table of the business object and extract that data into a comma delimitted format.  So if this is going to be something that you do often, you may want to create a shared class that accepts a BO, and the enumerates the BO and takes the data table and creates a comma delimmitted file.  A comma delimmited file (CSV) can be brought directly into excel.