How to export a datagrid to Excel file in Flex?

apache-flex actionscript-3 flex3 export-to-excel
Angeline picture Angeline · Nov 2, 2009 · Viewed 26.8k times · Source

How do I export data in my datagrid to an Excel file in Flex?

Can anyone provide some examples for that? I am browsing but couldn't find out a single example of that kind.

EDIT

Browsed a lot and found out how to convert datagrid data to csv format. Now How to convert that to excel? Is there a way to do that without using any server script ? Can't it be done in Flex alone?

Answer

Andy Li picture Andy Li · Nov 2, 2009

There is as3xls for you to write xls file. It only support a single sheet(but I think that's fine).

But I think using csv or html as stated by @susichan and @Rafal Ziolkowski will be more simple if you do not need to use excel functions (like cell formula).

Oh, and there is csvlib for writing csv. For html, do it like writing XML will be fine.

Related questions

How to convert bytearray to image or image to bytearray ?

How to assign bytearray value to panel background image. If anybody have idea or experiance plz help me to overcome the problem. BRIEF EXP: I have panel control and want to load image getting from webservice as a backgroundimage. So …

Read More
Fastest way to delete one entry from the middle of Array()

What is the fastest way to delete one specific entry from the middle of Array() Array is large one having Strings. I dont want just to set Array[5] = null, but instead array size should be reduced by one and array[5] …

Read More
As3 - How to clear an array efficiently?

I've been looking to clear an array in ActionScript 3. Some method suggest : array = []; (Memory leak?) Other would say : array.splice(0); If you have any other, please share. Which one is the more efficient? Thank you.

Read More