[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. :-(
_______________________________________________
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.
