Re: Read/Write Excel files
Re: Read/Write Excel files
- Subject: Re: Read/Write Excel files
- From: Shane Stanley <email@hidden>
- Date: Wed, 08 Nov 2000 08:43:03 +1100
On 8/11/00 4:34 AM +1000, Paul Berkowitz, email@hidden, wrote:
>
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.
I think what you're dealing with there *is* a text file -- a comma-separated
file saved by Excel (check its file type). It's not really a native Excel
file.
>
>
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?
It's just an ordinary text file with creator "XCEL".
>
It would be much faster than adding the exact same item to the
>
last column of each row, row-by-row, in Excel.
Well, yes. But so would something like:
set Value of Range "R1C1:R20C1" to "42"
You just need to know the column, and get the number of rows.
--
Shane Stanley, email@hidden