!/files/images/XE_2008_boxshot.thumbnail.png|height=135|alt=|align=left|width=150|src=/files/images/XE_2008_boxshot.thumbnail.png!Accessing data in Xcelsius is pretty easy. You can have static data loaded from Excel, or dynamic data loaded through Web Services, Excel XML Maps, QaaWS (Query as a Web Service), Crystal Reports, Web Intelligence Reports or queries using Live Office.There are however only a few ways to export data from Xcelsius. Either we could use Flash variables or use the XML Data Button to export data out of the compiled .swf file.Here I present a simple method to export data from an Xcelsius .swf to a csv/Excel file. This method utilizes the XML Data Button's capability to send and receive XML data.
1. Add an XML data button /Connection Refresh button and check the "Enable Send" box. Make sure that in the MIME Type dropdown, "application/x-www-form-urlencoded" is selected.
</p>
2. Type out the URL of the export2csv.aspx file in the XML Data URL and add the ranges of data that you need to export. The screenshot above shows 2 ranges being exported.
3. Check the "Enable Load" box and add a single cell range (Sheet1!$J$1 in the example) to receive the URL of the CSV file that will be returned by the export2csv.aspx file. Note that the XML variable name returned by the export2csv.aspx is exportdataurl, so you need to name the range the same. If you wish to change the name, you'll need to update the same in the export2csv.aspx file.
</p>
4. Add a URL link button and set its URL to the cell defined in the previous step (Sheet1!$J$1).
5. Export the .swf file and try out exporting the data by clicking on the Connection Refresh Button and then opening the file by clicking on the URL link Button.
Now you can easily export data from any .swf that you've created in Xcelsius.
How does this work?
1. The XML Data Button exports the ranges you've selected in an XML file to our export2csv.aspx file.
2. Our export2csv.aspx file parses and saves this XML in a .csv format on the web server.
3. The path of the .csv file is returned to the .SWF file through the "Enable Load" range.
4. The URL Link component retrieves the URL from this cell and opens the .CSV file when clicked.
Source code: See the attached PDF
Attachment | Size |
|---|
[Code_for_export2csv.aspx_.pdf | /files/Code_for_export2csv.aspx_.pdf] | 15.98 KB |
