Flex :: Write Data To File To Open In Excel?
Oct 14, 2010
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?
View 1 Replies
Similar Posts:
Dec 30, 2010
Is it possible to use flash to read and write data on an excel/google documents file?
View 1 Replies
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.
View 3 Replies
Feb 6, 2004
I want to write datas to a database (txt or MS Excel) from a flash file that can be stored in my hard disk.
View 14 Replies
Mar 19, 2012
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");
View 1 Replies
Oct 7, 2009
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.
View 1 Replies
Dec 6, 2004
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.
View 1 Replies
Dec 6, 2004
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.
View 1 Replies
Apr 14, 2009
I want open the file excel .xls and put 2 values on the cell E15 and I8.
E15= 2
I8=250
How can do that ?
View 1 Replies
Mar 15, 2010
I want to create a file and write some data (userid) into the file at first run of my application, during the second run all the operation (will go to the next state) based on the file data, is it possible? How to create and write data into file?
View 2 Replies
Dec 13, 2011
I 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]...
View 2 Replies
Apr 4, 2011
I have a flex-application deployed on tomcat with blazeds. User constantly selects ranges excel-document. Now, a user enters a cell addresses in text fields (for example, C1: C20). But it is very inconvenient! How to display excel-data as a table in my application? I think, I can parse excel-document using Apach POI and transmit these data to the Flex-application. But there are other ways?
View 2 Replies
Nov 18, 2011
Our users want to copy and paste some rows from an Excel spreadsheet, or a chart generated in Excel, into a text box within a Flex application.It would be ok for it not to be fully functional, like an ActiveX object, embedded in the flex app. If it converted it to a static image, that would be fine. But I don't know of any Flex component that supports this.
View 1 Replies
May 9, 2009
The problems im encountering seem like they have a simple answer, but i cant find it. The program has people generate 6 numbers that i need to record in a file so i can analyze them later in a stats program. Here is the code for the write to file portion. Some of the code may be redundant, not needed, or just plain wrong, as I kept changing things based on the error messages i got.
String(ce_0);
String(ce_1);
String(ce_2);[code]......
problem 1 is that when i click the check syntax button it says no errors, but 2 pop up in the compiler error box. The first is a 1084 saying it is expecting a right parenthese before the colon,the second is a 1078 (label must be a simple identifier).To see if it would work I removed the identifiers and the colons, and I get problem number 2. 3 errors pop up now. First,it says the resolve is a call to a possibly undefined method through static type. Second, it says iso is undefined (im assuming this is becuase it doesnt have the String identifier).Third, it says in the writeMultiByte method there is a coersion of Number types with String types(im assuming this is also becuase it is missing the identifier)i was also wondering what capabilities AIR has to write to Excel.I can go all the stats on the numbers in Excel,and if i can put the data directly in it would cut out a step,I just havent been able to find anything saying what AIR can and cant do regarding excel.
View 3 Replies
Apr 19, 2010
I want to write the bulk of data into xml file ,the data coming from the backend(mysql) using cgi by httpservice, read the xml file and bind it into list. can anyone send the sample code for this?
View 1 Replies
Nov 2, 2009
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?
View 6 Replies
Sep 20, 2011
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 Replies
May 27, 2008
I have a big dout running in my mind that can we save a xml file from an swf., that is i have done so many projects from which you can read contents from xml but can we write in to xml that is all is my dout.
View 5 Replies
Sep 27, 2010
I have two variables that I would like to store in a remote data file which can be accessed by my Flash file. It is for a voting system, so the first variable would be a counter that is incremented each time a user votes, and the second would be the total rating. The average rating would then be calculated from these.
How would one store, retrieve, and then update these variables from the data file?
I can create the system within a single Flash file for a single session, but obviously I'd like multiple users opening the file simultaneously to be able to access the data and update it.
View 4 Replies
Mar 20, 2012
Is there a way of writing data into a text file without using AIR components in AS3 using flash. The save method of fileReference class opens up a file selection dialog box. Cant that method directly write data into some file withot opening he dialog?
View 1 Replies
Aug 6, 2007
How can i open a Microsoft Excel or Word using flash which is published as HTML, We have way to open these when Flash Stand alone EXE
View 1 Replies
Feb 27, 2009
how to get Excel data into flash?
View 1 Replies
Sep 26, 2009
Recently, I writed a programe about creating a text file and writing data into it in the server application folder. My code is as following:
[Code]...
Supplement: The text file named test.txt doesn't exist before create the fileObj, an instance of File Class.
View 1 Replies
May 19, 2011
Ok, basically my Flex app will open up a socket and listen on it. My java program will write some string to this port.
My AS3 code is
private function onRecvClick():void
{
var host:String = "localhost";
[Code]....
While trying to write to the socket, i am getting this java.net.ConnectException: Connection refused: connect. Funny thing is that the socket in Flex doesn't seem to dispatch any events, is it normal for that to happen?
View 1 Replies
Mar 17, 2010
store data to excel
View 7 Replies
Aug 11, 2010
I am creating an AIR application using Flex. In it I use a file in application directory to store some data in it.Its working very well to read and write data to this file with various OS except windows 7. In windows 7 it is not working. May be its a permission problem.
How can i write file in the application directory with Windows 7 ?
View 2 Replies
Jun 25, 2006
I have pretty good basic "action script" skills for developing flash files and movies, but I don't know how to do dynamic things with asp, aspx, etc. I have a local application that runs form my computer and is not connected to the internet. The application keeps track of button clicks on each buttton as separate variables. Here is my question ... each time the flash movie runs and buttons are clicked, I want to record the clicks on each button (which exist in the application at runtime) and save them to something like an excel spreadsheeet or access database. Any easy way to do this without getting into server-side stuff?
View 3 Replies
Sep 30, 2010
I want to create a form (flash or java/ajax) that allows selection data to be pulled from an xml file.
Example:
A ring builder application - the user selects the ring setting in one dropdown and then they select a diamond in another drop down. But the prices of the diamonds changes every day based upon the market, so we would need to easily update that data - hence an xml or excel file.
It would be even better if the data could be linked - such as selecting a princess cut diamond, then the settings that are only compatible with princess cut show up, and then after selecting a setting, only diamonds that are the right size for the setting show.
View 1 Replies
Jun 23, 2009
My friend and I were looking into trying to have flash (cs3 or 4 probably) communicate somehow with Excel*, I know this is a general question, but is that in any way possible?
View 3 Replies
Oct 20, 2009
Half way through;user saves the answers to a CSV file to a location.then continue the test and save the 2nd part to the same location (different file name). The next person completes the same test, and theoretically saves in the same location OVERWRITING the file. HOW IT SHOULD WORK when they overwrite the file, it SHOULD add it to the next ROW in the excel (csv)document, not overwriting the WHOLE file. In the end, you would (in theory) have a number of rows in one excel document, each row, a different user who completed the test The issue is: on the MAC computer, this works (im not sure if it's because the previous developer developed it on a MAC) however when I play it or move it to windows computer; It overwrites the whole CSV file, and doesn't add it in the rows.Here is the main code (half way through) for the first save:
Code:
stop();
qNum.text="Q 11-13";
[code].....
View 0 Replies