read excel sheet data as input


    May 03 2008 | 7:23 pm
    Hi all
    Which max object can I use to read text from an excel data sheet?
    I am doing an installation which requires the audience to fill in answers to several questions. The answers are transformed into numbers and exported to an Excel file by Filemaker. What I need as an input in max is the row of numbers resulting in this Excel sheet.
    I see that objects like [text] [coll] [filein] or [jit.textfile] doesn't read this .xls format.
    Any help or suggestion is welcomed!
    Cheers Beatriz

    • May 03 2008 | 8:03 pm
      i believe xls is a binary file. export it as a csv file.
    • May 03 2008 | 8:44 pm
      On May 3, 2008, at 12:23 PM, Beatriz wrote: > Which max object can I use to read text from an excel data sheet?
      None that I know of.
      > I am doing an installation which requires the audience to fill in > answers to several questions. The answers are transformed into > numbers and exported to an Excel file by Filemaker. > What I need as an input in max is the row of numbers resulting in > this Excel sheet.
      Can you get Filemaker to output something like a .CSV text file?
      -C
      Chris Muir cbm@well.com http://www.xfade.com
    • May 04 2008 | 9:05 am
      Thanks to both! I
    • May 05 2008 | 2:31 pm
      Filemaker can export files in .csv format, so it works nicely. Thanks a lot!
      Beatriz