Using AS3XLS with the Flex Framework: Excel Import
videos

Using AS3XLS with the Flex Framework: Excel Import

on Aug 27th 2010 with 15 comments
Tutorial Details
  • Program: Flash Builder
  • Difficulty: Beginner
  • Estimated Completion Time: 30 mins
Download Source Files
Demo View It Online

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.

View Screencast

Don’t like ads? Download the screencast, or subscribe to Activetuts+ screencasts via iTunes!

Tags: Videos
 
Enjoyed this Post?

Subscribe to our RSS Feed, Follow us on Twitter or simply recommend us to friends and colleagues!

By

Rollover to read this author's bio or click through to see a full list of posts by this author.

Joseph Labrecque is primarily employed by the University of Denver as a senior interactive software engineer specializing in the Adobe Flash Platform, where he produces innovative academic toolsets for both traditional desktop environments and emerging mobile spaces. Alongside this principal role; he often serves as adjunct faculty, communicating upon a variety of Flash Platform solutions and general Web design and development subjects. In addition to his accomplishments in higher education, Joseph is the proprietor of Fractured Vision Media, LLC; a digital media production company, technical consultancy, and distribution vehicle for his creative works. He is founder and sole abiding member of the dark ambient recording project "An Early Morning Letter, Displaced" whose releases have received international award nominations and underground acclaim. Joseph has contributed to a number of respected community publications as an article writer and video tutorialist and is author of the forthcoming "Flash Development for Android Cookbook". He regularly speaks at user group meetings and industry conferences such as Adobe MAX, FITC, and D2WC. In 2010, he received an Adobe Impact Award in recognition of his outstanding contribution to the education community. He has served as an Adobe Education Leader since 2008 and is also a 2011 Adobe Community Professional.  

Plus Premium
 
 
Add Comment

Discussion 15 Comments

  1. James says:
    August 27, 2010 at 9:42 pm

    This is great.Looking forward to future tutorials on this.

    Reply
  2. Jacky Cahin says:
    August 28, 2010 at 6:39 am

    Nice post

    Reply
  3. Jacky Cahin says:
    August 28, 2010 at 9:09 am

    Nice Post………

    Reply
  4. thedevelopertuts says:
    August 28, 2010 at 1:25 pm

    Yeah, getting the power to process xls files is one of the most requested features in admins and statistic softwares, I just got tired at some point of this, using php before to parse an xls, but using flex is great!

    Reply
  5. Udit says:
    October 5, 2010 at 11:35 pm

    Hi

    I am getting an error “could not resolve to a component implementation”

    in the following line -

    creationComplete=”init()” width=”600″ height=”400″>
    .

    Please HELP.

    Reply
  6. edmmoir says:
    October 30, 2010 at 4:48 am

    works great, but wondering if there is anyway of skipping the browse button, and having the excel file import automatically on application load.
    thanks

    Reply
  7. rajesh says:
    December 20, 2010 at 3:49 pm

    Hi,
    your example is simple super. But we are facing small issue on this. we are working in Flex 3 version. we are facing compilation issues due to version problem. Instead we can use any other options. please help on this.

    Reply
  8. Amir says:
    December 25, 2010 at 1:49 am

    Hi

    The tutorial above is great and work fine.
    However I am unable to convert data that not wrriten in english

    I am receiving an XML file form a remote server.Not all data nested inside is in English.
    When I export it to an Excel file instead of the nested data I get several ???? (question mark) according to the length of the word.

    How do I solve this problem and displaying the correct data?

    Thanks
    Amir

    Reply
  9. Jennifer says:
    January 5, 2011 at 9:52 am

    A much needed utility. Do you plan to update for .xlsx file format for Excel 2010?

    Reply
  10. cglee says:
    February 27, 2011 at 10:14 pm

    Hi
    I’m facing small issue on this. why not excel import ‘MS2007′ version???
    please help on this.

    Reply
  11. designscripting says:
    March 15, 2011 at 4:21 am

    thanks for the video..

    http://www.designscripting.com/2011/03/flex-excel-export-add-dynamic-column-in-flexspreadsheet/

    Reply
  12. Justin says:
    October 10, 2011 at 5:08 pm

    As a newb, I cannot figure out how to import the as3XLS into the flex project so that you can use the classes. I can cut and past the com directory directly, but it doesn’t import correctly. How do you do this?

    Reply
  13. Matt says:
    November 19, 2011 at 3:44 am

    This was great! I learned a lot from this tutorial I hope you keep posting more.

    Reply
  14. Luis says:
    January 16, 2012 at 2:03 pm

    how the component works in flash player 11?
    I had some problems

    Reply

Add a Comment

To add a code snippet to your comment, please wrap your code like so: <pre name="code" class="html">YOUR CODE</pre>. You can replace the class name with "js," "css," "sql," or "php." If there are any "<" or ">" within your code, please search and replace them with: &lt; and &gt; respectively.