feature request / SaveTablesToWorkBook

[ggreen86]

feature request / SaveTablesToWorkBook

[ggreen86]

Will look into adding this feature request. The SaveTablesToWorkBookEx() method is designed to write directly to a new spreadsheet file; so there is not an existing sheet to write to. Method SaveTablesToWorkBook() could be enhanced to selectively create a new sheet or write to an existing sheet. Both methods could have optional parameters for the starting column and row. However, the checking of existing data in the cells would add considerable overhead and then what to do if found? So I don't think this would be feasible.

[lscheffler]

Sorry for the delay. First full of work, then vacation. :D
What I like to have for SaveTablesToWorkBook:

• a way to address a sheet different then sheet number 1 - this is tvSheet Running number or sheet name. The calling code is responsible to create / name sheets if needed.
• only write the data to the cells, this is
  • create cells if not existing
  • fill existing cells with data, but do not touch existing formats

I understand this is slower then just putting the data into an empty sheet. But it's still faster the using EXCEL automation for it. If EXCEL is available at all, what is a problem with the cloud based stuff. So for the speed it is a minor issue.

Sure, it could be an additional method, what keeps SaveTablesToWorkBook as simple and fast.