<< RIA - Kolkata

Blog

Our Blog

Blog Home | About | Entries By Date | Search

as3xls - Opensource library to read/write Excel files using Adobe Flex


Entry posted 04/21/11 by basakarunava last edited 04/21/11 , tagged: Rich Internet Apps, Development
10,376 views, 0 comments.

Title
as3xls - Opensource library to read/write Excel files using Adobe Flex

Entry

In multiple Flex based RIA, it is necessary to import/export data in Excel format. Normally, this involves the use of a server side script. However, it is not not always possible and/or feasible to go for a client/server architecture to implement the same.

In such case, "as3xls" can be used as a client side library to import/export data in the form of Excel files. There is no further requirement of...

[more]

More

...any server side script.

"as3xls" is an excellent opensource package to read and write Excel files in Flex and can be used in scenarios where server-side script cannot be used.  It support the use of text, number formula and dates (in read mode) and tex, number and date (in write mode) from Excel version 2.x - 2003.

The package is hosted at google code and can be downloaded via the following link:

http://as3xls.googlecode.com/files/as3xls-1.0.swc

The home page link is :
http://code.google.com/p/as3xls/

The author can be contacted at : Sigfrid3141@gmail.com

There is also a tutorial showing the usage details:
http://code.google.com/p/as3xls/wiki/Tutorial

The related documentation can be accessed from :
http://as3xls.googlecode.com/files/docs-1.0.zip

However, be warned, in case you are going to use OpenOffice to view the Excel content. In this case, the data will come as junk characters.

From Flash player version 10 onwards, you can locally save a copy in Excel format using "as3xls". However, in case you intend to use it with lower version of Flash player, then a server side script is required for file saving purpose.

There is a good cookbook entry to demonstrate the usage of the library at:
http://cookbooks.adobe.com/post_Import_Export_data_in_out_of_a_Datagrid_in_Flex-17223.html

Happy coding using "as3xls".

Keywords
as3xls, flex opensource, excel flex, actionscript library, swc file, adobe export, import, ria -kolkata, arunava basak