actionscript-3exceldata-bindingdatagridflex4

does as3xls library handles hyperlink in excel file..?


Is "as3xls library" capable of handling a hyper link in excel file, is there any other library which i can use for importing data from .xlsx file. as3xls is limited to .xls only.


Solution

  • .xlsx files are basically just XML files that are mapped to each other and zipped up into a zip archive. The way I have dealt with them is to use something like nochump's zip library to unpack them, and then traverse the contained XML yourself. Other than that, I don't know of any libraries set up to deal with xlsx files directly (you are correct that as3xls only deals with the older, more difficult binary xls format). You may find some resources such as the OOXML spec helpful as well.