I have used AS3XLS and quickly ran into serious limitations. >From my experience, the best and easiest way to export to Excel is to write it out as html and save it as an .xls(x) file. Excel does a great job at reading these files and so far I have not run into any issues with this approach
To figure out the formatting, multiple sheets, etc. just create a sample and export it to HTML. Just open it it up and see how the html looks. Follow the same pattern when writing the html yourself. Of course, this approach is best for small data sizes and if you have data in the client. If you have large datasets, it would be better to do it on the server side and just download it. And no, there is no security violation as long as the user initiates the save to file action. Thanks, Om On Thu, Aug 29, 2013 at 9:33 AM, 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 >
