read excel sheet data as input

glBeatriz's icon

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

Rob Ramirez's icon

i believe xls is a binary file.
export it as a csv file.

Chris Muir's icon

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

glBeatriz's icon

Thanks to both!
I

glBeatriz's icon

Filemaker can export files in .csv format, so it works nicely.
Thanks a lot!

Beatriz