Comments (2)
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.
from xlsx-workbook-class.
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.
from xlsx-workbook-class.
Related Issues (20)
- Assuming Header name is Header1 HOT 3
- WriteSheetXMLS - Sets All Columns to Hidden rather than just the single column. HOT 2
- Create and populate drop-down list inside a cell HOT 12
- Allow a sheet to be named "History" HOT 2
- how work cursor HOT 9
- A sample from GSheets HOT 4
- InsertRow method not saving the footer rows correctly. HOT 3
- WorkbookSaveAs - error when attempt to open the new workbook HOT 19
- How to set Sheet Protection HOT 1
- Timezone not taken into account when writing document properties HOT 1
- AddNamedRange for PRINT_TITLE not working HOT 3
- FitToPage not being set in Sheets.xml HOT 1
- When using SetRowHeightRange error when opening new XLSX file in Excel with Sheets.xml HOT 5
- Reading an Excel worksheet into a VFP cursor HOT 2
- Missing variables in VFPxWorkbookXLSX.h HOT 1
- BESTFIT error while loading file
- About General fields
- Need repair after saving same file with SaveWorkbook function HOT 6
- GetNodeAttributeBoolean caused a "column does not accept null values" error
- SaveGridToWorkbook support alignment
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from xlsx-workbook-class.