If I send a 5x10 table to Excel, it fills a 5x10 array.
If I later send a 5x5 table to the same location using gdxxrw I see a 5x5 array.
If I send with Connect, I see a 5x10 array, with the first 5 columns containing the new data, and cols 6-10 containing the old.
Is there anyway to get Connect to delete the old data in columns to the right of where it is writing?
Thanks
Rob
Rob,
The ExcelWriter has a clearSheet option. If set to True, the whole sheet will be cleared before new data is written. Right now, there is no way to tell Connect to only clear specific parts of an existing sheet, but we plan to add this feature in a future release. If the sheet contains more data that should not be cleared, one would need to write all other symbols again as well. Alternatively, some custom PythonCode might help to work around this.
Best,
Clemens