Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel and 16383 records
Message
From
27/08/1999 10:28:47
 
 
To
27/08/1999 10:16:01
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00258393
Message ID:
00258404
Views:
15
Hey Kevin,
I think that is a limit in Excel 95(?). I think in Excel 97 it is raised to 65,536 rows. You use several pages if you needed to. I've found that the fastest way to do this is to use VFP.DataToClip() and paste it onto the Excel sheet.

Which building are you in? I'm in URP1.

HTH


>Hello all!
>
>I have an Excel problem that I was wondering if anyone else has run up against and if so how they may have got around it.
>
>It seems that Excel can only handle up to 16,383 records in a worksheet. In my program, a excel file is created from VFP and then excel is opened with that file. IOW:
>
> loexcel = createobject('Excel.Application')
> loexcel.workbooks.open((localpath)+"query.xls")
> loexcel.visible = .t.
>
>The problem is that it will only show the first 16,383 records. Does anyone know a workaround for this? Or am I missing something simple here? I was thinking about breaking up the data and opening multiple worksheets in a workbook but I'm not sure how to do this or if it would even work.
>
>Any help would be appreciated!
>
>Thanks!!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform