What parameters did you pass in?
The syntax is:
CopyToExcel("C:\Test.xlsx", "Sheet1", "MyTable")
This is the header of the Function in the GridExtrasProcs.prg that I
have and use:
FUNCTION CopyToExcel(tcXLSFile, tcSheet, tvWorkArea, tcExcelFieldList,
tcTableFieldList, tcTableForExpr)
***********************************
* PARAMETER Information
* tcXLSFile := a string specifying an excel file (*.xls, *.xlsx,
*.xlsm, *.xlsb) on disk
* tcSheet := a string specifying the name of the worksheet to
create within the excel workbook
* tvWorkarea [optional] := the Alias, Work Area, or File Name of
the table you want to be copied to the worksheet (default is currently
selected Alias)
* tcExcelFieldList [optional] := a comma delimited list of columns
you want to create in the worksheet (default is '*' - columns will match
table field list)
* tcTableFieldList [optional] := a comma delimited list of fields
you want this function to copy from tvWorkArea
* tcTableForExpr [optional] := a valid VFP Where/For clause to be
used when querying tvWorkArea for data to be copied to the worksheet
*
* RETURN Information
* returns numeric, the number of records inserted into the worksheet
*
* Provider Information
* the default provider being used in the SQLStringConnect function
can be downloaded and installed from:
*
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
Frank.
Frank Cazabon
On 06/11/2019 03:35 PM, Gene Wirchenko wrote:
At 06:08 2019-10-30, "Tracy Pearson" <[email protected]> wrote:
Gene,
I have not seen a difference in the output of the two commands.
You might want to consider looking at Craig Boyd's post about
exporting and
importing from Excel. It doesn't mention Memo fields that I could see.
https://www.sweetpotatosoftware.com/blog/index.php/2008/09/30/using-excel-20
07-file-formats-in-vfp-9-0/
Have you tried it? All I got for results with CopyToExcel() was
an empty spreadsheet. No column headers, no rows.
[snip]
Sincerely,
Gene Wirchenko
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
