Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Print Excel sheet in report.
Message
From
12/03/1998 05:38:14
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00083817
Message ID:
00084109
Views:
37
>>>Is there any possibility to print information from Excel sheet?
>>>Without running Excel application?
>>>From report?
>>>
>>>Giedrius
>>
>>You can IMPORT excel data to VFP cursor and use it as report source.
>How it can be done programatically.
import from testbook.xls type xl5 sheet cSheetName
* Currently excel97 is not recognized - save as Excel 5.0
*VFP creates a table with field names A,B,C and so on. Tablename is
* same as xls by default
*If a column includes a non-numeric value then a char field is created
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform