Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing excel file
Message
 
To
28/10/2004 11:30:49
Eric Gauthier
Transcontinental Interweb (Montreal)
Boucherville, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Database:
Jet/Access Engine
Miscellaneous
Thread ID:
00955330
Message ID:
00955430
Views:
23
This sounds strange to me. Usually "import crash" because of some Excel features included in the sheet, like improper formattings or links. In many cases they cannot be recognized or simply ignored with the VFP import command. Even if you know the Excel version and the number of records in the sheet, it will not help.


>Hi all,
>
>Someone can help me?
>I need to know how to obtain the recordcount of a sheet in a excel file and the file version of this .xls. I can't use excel.application so I need another solution.
>
>Because when a use :
> import from (FILE NAME) XL8 | XL5 | XLS sheet (NAME SHEET)
>
>I dont know the file version and if the sheet (NAME SHEET) is empty, import crash.
>
>Thx.
Previous
Reply
Map
View

Click here to load this message in the networking platform