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.
View 3 Repliesi'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");
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.
View 3 RepliesI'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?
Is it possible to use flash to read and write data on an excel/google documents file?
View 1 RepliesHow 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?
View 6 RepliesI want a user to press an excel button and get prompted to download an excel file. I normally do it like this:
var dest:String = excelEndpoint;
var request:URLRequest = new URLRequest();
request.url = dest;
fr.download( request,'Locates.xls' );
fr.addEventListener(HTTPStatusEvent.HTTP_STATUS, handleStatus);
fr.addEventListener(IOErrorEvent.IO_ERROR, handleErr);
[Code]...
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.
View 3 RepliesI wonder if it is possible to read Excel documents like a xml document with Flash.
View 3 RepliesDatagrid with 3 columns namely Name,Place and Country. In order to export these columns values to Excel sheet by Clicking a Button called 'Export to Excel'. When Click this button, the values in datagrid is exported in excel sheet.
View 2 Replieswith the platform j2ee,data of datagrid is from java dao(from the database),so which way is better,to export the data of datagrid to Excel with java dao or flex?
View 3 RepliesI have an AIR application with two DataGrids that I would like to export to Excel. I've found the as3xls library, but it can only handle one sheet (as per the comments). Ideally, I'd like to export both DataGrids into separate sheets in the same workbook.
The AIR application is running entirely on the user's desktop and doesn't have a connection to any server, so the solution would need to be Flex/AIR only.
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'
View 3 RepliesHow to generate mxml(flex code) from excel file.how to Create flex code from xls file.
View 1 RepliesI 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.
View 1 RepliesHow does one save the value of a variable to an Excel/<spreadsheet of any kind> file? Also, is it possible to do this without using CGI, Perl, js, etc non-Flash scripts?If you could assist me in how to save the value of a variable to *any* type of file that'd be good as well...I was utterly confused after reading the documentation.In case you're wondering why I'm asking this, I will be conducting a science experiment involving Flash. Subjects will be shown a series of slides, each slide containing one four leaf clover amidst a field of three leaf clovers. They will be timed to see how long to click on the four leaf clover. The purpose is to see if there exists any correlation between time taken to click and number of slides seen.
View 1 RepliesHow can I open an Excel file in a MAC?
Ive tried fscommand but didnt work. I have tried getURL to open the folder where the file is in, but didnt work.
How can I open an Excel file in a MAC?
Ive tried fscommand but didnt work. I have tried getURL to open the folder where the file is in, but didnt work.
How to Read whole datagrid using Actionscript, that Datagrid contains Combobox itemrenderer and Textbox itemrenderer in two coloumn, I want to read the value of both the itemrenderer as well.
View 1 RepliesI want open the file excel .xls and put 2 values on the cell E15 and I8.
E15= 2
I8=250
How can do that ?
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 need to read a excel file from the client side and show it to data grid. I tried searching but could not find something relevant.
View 1 RepliesWondering if anyone can tell me whether it is possible to take an excel spreadsheet with its equations and all and place it into a Flash file so that it can work within the flash presentation.
Or would the only way to do this be to code the whole thing into flash from the start?
I am looking to convert a 2007 MS Excel file into a XML output for my AS3 project. I have tried to save as XML data and it errors stating that XML mapping is required. I also have an option to save as 2003 XML worksheet, which works but it provides its own tags and I cant get the order right. I have also attempted to add VB code to the macro screen, but I am lost in the MS world. I just need a clean consistent XML output, no formulas just cell info.
View 2 RepliesI can not read my XML into a DataGrid. I have looked at the TimeSheet tutorial and have been able to get it to work, but can not make the adjustments to this file. I was wondering if there was a problem with XML itself?
View 1 RepliesI'm reading data from an SQL database and send it to my Flex app. My source code in Flex is the follow[code]...
View 1 RepliesI'm doing a quiz system now, which allow user to type into his name---start quiz---choose a correct answer from questions---account the result----export an excel/word/txt file of different users information and result on backstage.[URL]..now i just duno how to allow user type his information into it and how to export an excel or word file after quiz taking. does anyone did tat be4?
View 1 RepliesI have make a post request to some url. Normally when this url is called from some html form, it opens a dialogue box to download excel file. But when I call this url from flash component, nothing happens. I have to force this excel file to be downloaded.
View 1 RepliesI have a main swf file and config.xml located in the same directory. My .swf file uses config.xml to fetch config variable which it does with success.The problem appears when I put those files into Flex directory. I embed .swf file like this.
<mx:Image id="loading" source="@Embed('/blobs/visualLogo/mySwfFile.swf')"
visible="true" horizontalCenter="0"/>
I also place config.xml into /blobs/visualLogo/
This time I get an error in Flex:
TypeError: Error #1009: Cannot access a property or method of a null object reference.
at mySwfFile_fla::MainTimeline/frame1()
I mean, I use dynamically changing xml-data in my app that I could get straight from the server but it is gzipped. So I was wondering is there a way to unzip it and read it as a xml file with actionscript?
View 2 Replies