On 2014-01-14 14:50, Vincent Teachout wrote:
[email protected] wrote:
VFP9SP2, Excel 2007
I've got cursor data I need to export to Excel, but I need to name the
Sheet accordingly, too. And sometimes, I'm going to want to take a
few cursors and put into the same spreadsheet (but of course on
different WorkSheet names).
I'm thinking it's a job for automation but I thought I'd check with
the Pros here first before going down that road. I had thought there
was a SHEET command in one of the Fox functions but I don't see it in
COPY TO nor EXPORT, and besides, there's a distinct possibility of
going over 65,535 rows so hence another nod for automation I guess.
There is a SHEET keyword in the IMPORT command, but nothing similar in
the EXPORT or COPY. I think you'll have to automate. And if you
could go more than 65K, then definitely automate or export as csv.
:-(
There's also Christof's XML-SS for Excel but that's a bit more verbose
than I care to be for this.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[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.
