A Flash Developer Resource Site

Results 1 to 13 of 13

Thread: Excel file saved as CSV

  1. #1
    Member
    Join Date
    Sep 2014
    Posts
    75

    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.

  2. #2
    Senior Member
    Join Date
    Feb 2005
    Posts
    1,834
    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.
    .

  3. #3
    Member
    Join Date
    Sep 2014
    Posts
    75
    Thank you swak!

    However, the webpage did not open.

    "This page can’t be displayed"

  4. #4
    Client Software Programmer AS3.0's Avatar
    Join Date
    Apr 2011
    Posts
    1,404
    Hey if you post the csv ill give it a try with split functions :P

  5. #5
    . fruitbeard's Avatar
    Join Date
    Oct 2011
    Posts
    1,780
    Hi

    The page opened up just fine

  6. #6
    Client Software Programmer AS3.0's Avatar
    Join Date
    Apr 2011
    Posts
    1,404
    if it looks like byte code when you open it in notepad++ the only available libraries to parse that would be in as3

  7. #7
    . fruitbeard's Avatar
    Join Date
    Oct 2011
    Posts
    1,780
    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

  8. #8
    Client Software Programmer AS3.0's Avatar
    Join Date
    Apr 2011
    Posts
    1,404
    Yeah im sure you can expand it like that I think csv is pretty new as well...

  9. #9
    . fruitbeard's Avatar
    Join Date
    Oct 2011
    Posts
    1,780
    Hi


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

  10. #10
    Client Software Programmer AS3.0's Avatar
    Join Date
    Apr 2011
    Posts
    1,404
    fruitbread or froobbeard I think it is new it must have come out like a year ago

  11. #11
    . fruitbeard's Avatar
    Join Date
    Oct 2011
    Posts
    1,780
    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
    Last edited by fruitbeard; 12-25-2017 at 12:49 AM.

  12. #12
    Client Software Programmer AS3.0's Avatar
    Join Date
    Apr 2011
    Posts
    1,404
    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

  13. #13
    . fruitbeard's Avatar
    Join Date
    Oct 2011
    Posts
    1,780
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center