Excel file saved as CSV

Hello all,

Anyone, please, has good written tutorial on how to use AS2.0 to read variables (numbers) from Excel file saved as *.CSV.

Thank you!

P.S. I have no idea on how to deal with CSV files.

I haven't worked on this before but I'm guessing you could try treading the csv file like an xml file. AS2 - Load xml and csv then synchronize You could check out the script on that page.

Thank you swak!

However, the webpage did not open.

"This page can’t be displayed"

Hey if you post the csv ill give it a try with split functions :P

Hi

The page opened up just fine

if it looks like byte code when you open it in notepad++ the only available libraries to parse that would be in as3

Hi

I don't think you need to go that far alloy.

He wants as2 anyway. But you can read the csv file like an array after loading it and split it into an array with comma separated values.

As the file extension suggests. Csv

Yeah im sure you can expand it like that I think csv is pretty new as well...

Hi


Csv is not new alloy, it is simply an excel file.

fruitbread or froobbeard I think it is new it must have come out like a year ago

Hi

You need to do your revision Alloy.
It is not in the slightest bit new.

https://en.m.wikipedia.org/wiki/Comma-separated_values

https://www.computerhope.com/issues/ch001357.htm

If its going to be all comma why don't they just use a text file, im going to invent the .fok file and every word is separated by fok

Hi

Unfortunately Alloy the op poster is using an excel file saved as a Csv file which is what the title of the post even says

You obviously didn't know what a csv file was or perhaps didn't read the question.

Please do go ahead and use your .fok files although they probably won't help this thread.

Basically a csv file will contain data.
Usually stored in rows like arrays. Separated by commas.
These rows will probably be equal in length and therefore turn the rows into columns of sorts.

Like a spread sheet.

Saying that, the data could be very random too.

You can always grab an example Csv from the net and dabble in it yourself.

Then you might be able to help rather than posting overdue random things that we see a lot of lately from you

X