Re: Reading from Excel Files

[jbv]

Ray , If you're on Mac, I've you tried some applescript to convert all your excel files to tab/return test files ? JB Greetings, I'm using "open file myPath for binary read" to read an Excel file and I'm getting lots of garbage characters since I believe it's Microsoft's proprietary binary format.  If I save the Excel file as a Text (Tab Delimited) file I can read from it fine.  The problem is I have about 500 of these file.  To manually convert all of them would be extremely time consuming. Any suggestions on reading an Excel file and filtering out all the garbage characters?

_______________________________________________
metacard mailing list
metacard@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/metacard