| || |
Writing to Excel Spreadsheet
is there a trick to making Excel recognize that a row has been inserted and therefore expand the named range - I can successfully insert a data row, but on subsequent insert try, i get the error that excel cannot expand the named range. As another note, the insert puts the row at the first row AFTER the last row in the named range????
Anybody know a solution?
Re: Writing to Excel Spreadsheet
We are treating XL as a database. But we couldn't use all type of queries to XL. To update or insert, you have to pass all column values. You have to pass same structured(columns) data .