read excel sheet data as input
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
i believe xls is a binary file.
export it as a csv file.
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
Thanks to both!
I
Filemaker can export files in .csv format, so it works nicely.
Thanks a lot!
Beatriz