Read/Write Excel files
Read/Write Excel files
- Subject: Read/Write Excel files
- From: Paul Berkowitz <email@hidden>
- Date: Tue, 07 Nov 2000 09:34:42 -0800
If you open for access and read an Excel file, the result is a
comma-delimited text file, where every paragraph after the first has a
numerical content or a \"quotation-enclosed-for-text\" content.
Is there a way of writing such a similarly-formatted text back to an empty
"XCEL"-created file, and have it fill the cells correctly? Perhaps 'as
something'? It would be much faster than adding the exact same item to the
last column of each row, row-by-row, in Excel. But when I try it "straight"
it just transcribes the commas, etc. literally. As an example, making no
changes at all, where ExcelFile is some Excel WorkSheet file on your disk:
set f to open for access ExcelFile
set r to read f
close access f
set g to open for access ExcelFile with write permission
set eof g to 0
write r to g
close access g
Is there a quick way to end up with what you started here?
--
Paul Berkowitz