ActionScript 3.0 :: Import Data From Excel Into Flash?
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?
i am trying to import to flash an xml file, generated from Excel. I got some tutorials from internet but the format of xml file from excel it's different and i can't manage to access data from it. if i type trace(xmldata); it shows me the full content of xml file. But how can i acces the correct data if in the xml file it is written:
I'm at a very basic level with Flex and with programming in general. I am working on a project where I have data in an Excel (.csv) format, it's a large Excel plot/matrix where each cell has a temperature number. I want to import this matrix into Flex somehow, or parse the data in Flex, so that this matrix turns into an interactive heat with colors corresponding to varying temperatures from blue (cold) to red (hot), and each spot on roll over shows the temperature number.
Should I use plot charts, or some other control? should I convert data into XML or import into a MySQL database, would that be easier for Flex? But then, again, the data is basically just a large matrix, there's no headers/ fields in a traditional database sense, just many cells each having a temperature number. how I can import the data into Flex and use it as data provider to plot the heat map?
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?
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:
In an application we have an excel file of large amount of data whose every row we want as an array of data for impoting into flash application.Here i give a small description what we want to do:
I have the Following requirement and I do not even know where to begin.I have created a map of a Country and on the map are several towns and cities, obviously easy enough so far.So, for example, say the XML data provides information of ten different pieces of information, one might be say Lightning Strikes.
I want to be able to create a dynamic map that adds a Red dot beside the City, that represents a record of the lightning strike. Or ,if required a larger dot might represent 10 lightning strikes if it is a very regular occurance.The main objective is to provide an up to date visual representation of which location is more active.I don't mind experimenting or following a link or guide to work it out,
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.
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?
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'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");
Is there anyway to export JSON data to CSV/Excel without any interaction with the server side? Using Javascript only? or Flash? I'm currently using ZeroClipboard to copy the value into the clipboard but I'd like to open directly the generated value into Excel from the browser (FF, Chrome, IE, etc...).
I`m using flash cs3 for my works , but i have one problem!when i use File=> Import=> Import to Library... or Import to Stage...the flash environment becomes terminated.I changed my flash version to CS4 and I have this problem again.
We have a system that allows a user to upload any image, which we store on the server. Of course, it is simple to load an image (that you know the path to) using loadMovie, but I also want to load certain pieces of meta data about the image that is precalculated and stored on the server; we may one day want to retrieve things completely unrelated to the image as well, so consider the non-image data to be arbitrary.So, that said, is there a way to simply return the image as a variable (urlencoded and returned in a loadVars request, perhaps) and then load that data into a movie clip?
Bonus Lightning Round Question: Is there a way to check the output of a PHP script which processes uploads when the request is sent via FileReference.upload(url:String)? Should I load/escape the binary data and then send it using a loadVars() request if I want to see the output?
I am using Flash CS5 to generate an array of the notes in a midi file. Basically I store data such as time of the note, note duration, pitch, scale, volume, etc.I have 2 questions:How can I export all these data in order to use it in after effects (as a txt file? other formats?);How do I use the exported file in After Effects later on: How do I tell After Effects when to start playing a note in a specific time? how do I associate note height with a specific feature (lets say - square width) - and so on.I DO know some basic coding in after effect (how to associate elements inside After - such as volume and opacity) but I need to understand how to deal with an exported file (and in which format to generate it).
I am really new to php. I have an AS3 file which records user inputted data and stores them in variables. The only thing i know how to do is how to email those variables using .php. Well I want to be able to export the data to a csv file from the flash file and later want to import it back to the flash file.
The specific webpage is this [url]... the user select a week and the app reads the "Date" colum and uses the numbers in the same line in a calc... But when i Import this webpage it displays all the text in the webpage... how can i solve this? Can i specify wich data to use?
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.
My supervisor is interested in showing certain data within a dynamic map and this data must be fed from an Excel file. I was thinking I may have to use some service to convert the XLS to a CSV file, but if there's a direct way to do it with AS3 I can skip that step. The Excel file will be updated regularly. Eventually, she wants this movie to allow her to modify the Excel file as well.
Like if I were to take a non flattened, layered .psd and load it in using as3, would I be able to get information about each layer in the .psd, such as position, name of the layer, etc.?
I have started a installation locater, I have a map of UK which will have the hotspots(button) put on each county, once someone clicks on one of the counties it will bring up a list of 3 installers, once someone clicks on an installer it will bring up their contact details.
For a project requirement, I want to make available editing of an excel file through browser. The only possible ways that I could think of was by embedding the excel file either in Flash or Silverlight. I am building my project on asp.net mvc3 c#. I wanted to know that is there a way by which this could be achieved? I shall be happy to start an open source project is need be so that people who are interested can collaborate together.