Paul Newton wrote: > Ricardo Aráoz wrote: >> Problem is I don't find any property that allows to open (or import) a >> file in a specific worksheet. So if I am to use several worksheets I'm >> stuck with either inserting cell by cell, or opening a file (csv) in a >> second (auxiliary) workbook and then cut and paste (which can be >> vulnerable through the clipboard). >> > Ricardo > > I think you are trying to rely too much on Excel and not enough on VFP. > > First of all I assume you are trying to get a large number of rows of > data from VFP into Excel. > > 1. Different versions of Excel have different (row) limits, IIRC ca > 16K/64K depending on version > 2. Again IIRC EXPORT/COPY TO ...TYPE ... respects the > (appropriate/corresponding) Excel limits - no that's not right - check > the (VFP) help - I know that VFP has similar limits (16K/64K rows) for > this/these commands. > > So > > Use (Dave C's suggestion) of DATATOCLIP but do it 16K/64K rows at a time. > > From VFP, create/open an Excel workbook - add as many worksheets as you > need (in advance or as needed) > > For each DATATOCLIP, set the active cell in Excel to the corresponding > cell (A1) and worksheet and paste the data. > > Does that help ? > > Paul Newton > >
Thanks Paul, that's approximately what I'm doing (when the tables are big, else I copy a cell at a time through automation). The problem is it interferes with the clipboard, and if the user is working, say in word and cutting and pasting then both works will suffer. Here most people keep working on other stuff while reports are generated so now and then that problem arises. What I was looking for is a way to import a csv file or another xls to a specific worksheet without using the clipboard. Cheers _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
