Merging multiple Excel files

[ken gray]

is there a way to get the raw cell data from a spreadsheet with something like a "getfile" command.

maybe pipe-delimit the values or something like that?

what i need to do in the end is open 200+ files and strip out the headers and footers to get just the data and put it in one file.

thanks.