I was recently invited to start producing content for ActiveTuts+ (a great bunch of people!) and my three-part series on using the AS3XLS libraries in Flex has now been published in its entirety. Best viewed in full screen, of course:
Using AS3XLS with the Flex Framework: Excel Import
This tutorial will cover implementation of the AS3XLS ActionScript 3.0 library for the Flex framework. We will demonstrate loading an Excel .xls file into Flash and parsing the data into a Flex datagrid.
Using AS3XLS with the Flex Framework: Data Display Options
This tutorial will cover implementation of the AS3XLS ActionScript 3.0 library for the Flex framework. This time, we’ll demonstrate editable properties of the Flex datagrid and the use of various charting components to display associated data imported from Excel .xls files.
Using AS3XLS with the Flex Framework: Data Export
This is the third in a series of tutorials covering implementation of the AS3XLS ActionScript 3.0 library for the Flex framework. We’ll demonstrate how to save an Excel .xls file from modified Flex datagrid controls and also how to write CSV files using the same data to the local filesystem.
This looks really great!
Can you tell me about the limitations or bugs with this framework?
Yes; when saving as .xls using the library, oftentimes it will have trouble opening up in various versions of Excel (2010 beta would not work for me but 2007 and 2010 final seem to be okay).
Also, it cannot consume .xls files that it has generated. Must be a stance against cannibalism.
does this work on flex builder 3 because there are errors when i try it!
Does this work with Flash CS6? I link the as3xls.swc but Flash never finds any classes upon compiling.
Thanks.