Excel Automation - not saving all rows from existing spreadsheet?
Excel Automation - not saving all rows from existing spreadsheet?
(OP)
I have a process that creates a table with 48,000 records, I copy that to an xls workbook less a few columns.
If I do no more than that, there are 48,000 rows in the resultant worksheet
If I then open the xls using automation in VFP, change the column headers to match the soft ones in my app
and save the xls again there are only 16,384 in the spreadsheet.
If I open the initial export manually, not doing the automation bit, and paste the header line in and then save it
I get 48,000 rows.
What am I missing?
CODE
COPY TO (M.FILENAME) XL5 FIELDS EXCEPT DRGNO, FLAG, LINENO
If I do no more than that, there are 48,000 rows in the resultant worksheet
If I then open the xls using automation in VFP, change the column headers to match the soft ones in my app
and save the xls again there are only 16,384 in the spreadsheet.
If I open the initial export manually, not doing the automation bit, and paste the header line in and then save it
I get 48,000 rows.
What am I missing?
Regards
Griff
Keep ing
There are 10 kinds of people in the world, those who understand binary and those who don't.
I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
There is no place like G28 X0 Y0 Z0
I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
There is no place like G28 X0 Y0 Z0
RE: Excel Automation - not saving all rows from existing spreadsheet?
I was using this to save the modified file
CODE
I changed it to this
CODE
-4143 is the xlVBA const for xlNormal
Regards
ing
Griff
Keep
I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
There is no place like G28 X0 Y0 Z0
RE: Excel Automation - not saving all rows from existing spreadsheet?
Greg
RE: Excel Automation - not saving all rows from existing spreadsheet?
Excel 5 & Excel 95.
Hmmmmm?
Skip,
Just traded in my OLD subtlety...
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
RE: Excel Automation - not saving all rows from existing spreadsheet?
Regards
ing
Griff
Keep
I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
There is no place like G28 X0 Y0 Z0
RE: Excel Automation - not saving all rows from existing spreadsheet?
So VFP is capable to put more rows into an Excel 5.0 file than some versions of excel actually can process. The help has no specific note on Excel2000, but as you see there are problems. I would guess if an Excel process reads in an Excel 5 file, it also by standard outputs one, with less rows than VFP can support, and there ou have a feasible explanation.
Saving as a sepcific newer Excel version obviously helps.
Chriss