Re: Export to Excel

2013-09-03 Thread William Page
ce, 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 > New versions of Excel will error when they see fake XLS files like this. > > Tom >

Re: Export to Excel

2013-09-03 Thread Tom Chiverton
On 29/08/2013 18:27, OmPrakash Muppirala wrote: >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 New versions

Re: Export to Excel

2013-08-29 Thread Flexicious.com
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. Anoth

RE: Export to Excel

2013-08-29 Thread Kessler CTR Mark J
, August 29, 2013 1:49 PM To: dev@flex.apache.org Subject: Re: Export to Excel 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

Re: Export to Excel

2013-08-29 Thread Alexandre Barreiros
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

Re: Export to Excel

2013-08-29 Thread Scott Talsma
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.

Re: Export to Excel

2013-08-29 Thread OmPrakash Muppirala
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

Re: Export to Excel

2013-08-29 Thread Simonas Pauliukevičius
Why not generate spreadsheets on the server side? Popular server side languages have a bunch of nice libs that can help you with export. I myself used ClosedXML with ASP.NET enabled server. On Thu, Aug 29, 2013 at 7:33 PM, Oleg Konovalov wrote: > Hi, > > I am trying to export data from few Data

Export to Excel

2013-08-29 Thread Oleg Konovalov
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