We've done a lot of work on this front. For the longest time we generated just CSV/HTML/XML and Text, but recently added native excel. As3xls has a number of limitations (no backgrounds, limited formatting, no multiple sheets) but the biggest advantage is that it generates native excel files. Another option that has worked out quite well is generating OOXML files. These are generic XML files, but have OOXML markup. Here is an example of what this can look like: http://blog.flexicious.com/post/Flexicious-30-Release-Grid-Edition.aspx - Item 3 has a screenshot. Granted it is not pretty, but you can pretty much generate anything you want.
On Thu, Aug 29, 2013 at 1:57 PM, Alexandre Barreiros < alexandre.barrei...@arealmedia.com> wrote: > Hi All, > > The best solution that i have till now is to export as an CSV file. > > > Alexandre > > Em 29-08-2013 18:48, Scott Talsma escreveu: > >> Oleg, >> >> I have had great luck simply scraping the entire grid into an HTML table, >> and placing it into the clipboard. Then popup an an alert instructing the >> user to paste into Excel. Obviously, if you are exporting 2 grids, then >> you rely on the user to move the cursor correctly to the new position. >> >> Maybe write two tables to a html file and then use native extensions to >> launch excel and open it? (This assumes AIR.) >> >> >> On Thu, Aug 29, 2013 at 12:33 PM, Oleg Konovalov <oleg...@gmail.com> >> wrote: >> >> Hi, >>> >>> I am trying to export data from few DataGrids to Excel, using AS3XLS >>> library, but it seems it doesn't create a second sheet. >>> Does anyone knows how to do it? Or is there a better AS library >>> for that? >>> >>> Optionally I might want to skip a few rows and put second DG data there. >>> But how to add blank rows in AS3XLS? >>> >>> I know about POI, but need something quick. And I guess, for Flex Web app >>> that might be a security violation, correct? I mean, writing to file >>> system. >>> >>> Please advise. >>> >>> TIA, >>> Oleg >>> >>> >
