Actionscript :: Open And Read An Excel File From A Flex Application
Apr 9, 2012
What is the best way to open and parse and excell file from a Flex Application built using Adobe Flash Builder 4.5. I have done tons of research, most lead me to external libraries, I could deal with that if that is the best approach, but prefer a built in method.
I'm exploring the feasibility of reading data from a local Excel file in a Flash application.
XLSX READER [URL], it's possible to read Excel 2007 files.
It works beautifully.
However, that function doesn't read Excel 97-2003 files.
I found this:
[URL]
Which should read Excel files in Flex, but I'm working on a Flash application, and it looks like as3xls relies on a number of Flex only functions and types (ArrayCollection, NumberFormatter, etc.)
Since I'm not familiar with Flex, I'm having a difficult time making the adjustments myself.
Has anyone built a Flash app that reads Excel 97-2003 files, and is willing to share tips or code?
i'm trying to perform simple automated test on my Adobe Air Application. I decide to store some test data in external MS Excel file to decrease hardcode quantity. But I discovered, that this is not a trivial task, when you're working with Adobe Air.
Actually, i need to correct initialize an excelApp object, the rest part of logger is already implemented. I tried the following approach, but I can't find a package with ActiveXObject class defined.
excelApp = new ActiveXObject("Excel.Application");
I have a Flex application with a couple of DataGrids with data. I'd like to save the data to a file so that the user can keep working with them in Excel, OpenOffice or Numbers.
I'm currently writing a csv file straight off, which opens well in OpenOffice or Numbers, but not in Excel. The problem is with the Swedish characters, which turn up as other characters when opening in Excel. Converting (in Notepad++) the csv-file to ANSI encoding makes the show up correctly in Excel.
Is there any way to write ANSI-encoded files straight from Flex?
Any other options for writing a file that can be opened in Excel and OpenOffice?
I have to load and read the content of a Excel sheet into a datagrid. I am using AIR to load the FileStream, but when I display that stream, it gives me some junk character.
I want to open a particular worksheet on a Excel file through URL. Googling suggested to use this format for the pathWhere Exce File name:Doc33_HighwaySafety.xlsWorksheet inside it : FreewayCrashRatesBut this doesn't seem to work.
I am trying to develop an application which can be used locally by my team mates. its a sort of issue tracking application with report generation. am planning to do it on flex. in my company environment, i do have a lots of restrictions like, can't install AIR, no database, etc.
so am planning to develop on flex app, and put it in a shared drive. now the main problem is how can i store data. i have an idea like using excel files as database. I want opinion about this option, as well as, if anyone has tried reading and writing excel files from Flex application I want the suggestions also.
I have a small doubt in flash cs3/cs4. can some one tell me, is ther any way to read EXCEL values from flash cs3/flash cs4. I want to read values from excel and to display from flash side.
How do I export data in my datagrid to an Excel file in Flex?Can anyone provide some examples for that? I am browsing but couldn't find out a single example of that kind.Browsed a lot and found out how to convert datagrid data to csv format. Now How to convert that to excel? Is there a way to do that without using any server script ? Can't it be done in Flex alone?
I need to be able to read an XML file from my flash application. I found this tutorial: republicofcode.com/tutorials/flash/xml/ But it doesn't seem to work even on their own examples. I can trace whole XML file, but when it comes to childNodes whatever I try to trace I always get "undefined". My XML is like a quiz DB with 25 <question>'s and 4 <answer>'s in each. So I need to operate with XML data as with an array.
I'm looking to develop an application that allows you to set up an online spreadsheet or to be able to draw a custom table format. Can someone point me in the right direction. I've been googling for a week now and can't find any direction.
I'm trying to openWithDefaultApplication a downloaded file (stored into app documents directory) on iPad. I installed PDFReaderLite, still openWithDefaultApplication don't rexognizes extension pdf. What can I do to make PDFReaderLite be a default app for opening pdf?
In my Flash application users must be able to download or open PPT files nested in application's subfolder.When I run .*swf file, it works fine (Save file dialog appears), but if I run .exe file, nothing happens.[code]I suspect that "navigateToURL" function doesn't work in this case.
A friend of mine has a Flash Action script running on a LAMP server that currently reads an xml config file. He's asked me if it's possible to remove the xml file, and replace it somehow with a system (lets call it an 'auto xml generator') that intercepts the request to read that file and generates an output, so it appears to all intents and purposes as if the file still exists and contains the contents that has actually been returned from our auto xml generator'
I am developing flex air application.I have to implement hot-key functionality in air application.
For example whenever user press any two keys like ctr and S keys the open flex air application.and whenever user press any two keys like ctr and q keys then close flex air application.
The things is, I've build an application in flex which suppose to be for web but when I'm running it through the Flash builder, it opens up flash player app instead of opening in a web browser. I've tried to do "run as webapplication" but failed.
I'm new to flex. Now I'm writing an flex application. I plan to split my application into some MXML files(Application as the root tag). How can I switch from one mxml to another?BTW, what is the best practice for design large flex application? Just one MXML Application and many MXML component or many MXML Application?