| || |
writing to a table using RowCount+3
I have an excel file, i opened in in READWRITE mode, then i got its row count:
then i try to write to it:
i am getting the message parameter out of range, but when i write to it using RowCount+1 it works, have any one encounter similar issue, the problem here its not writing when i use RowCount+3 or 2, it accept only RowCount+1
Re: writing to a table using RowCount+3
Well, sure. A data table (= an excel spreadsheet) is not implemented as a sparse matrix. You can't just miss rows out altogether.
Why not just write the intervening rows with null values?