Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using TableToExcel.prg
Message
 
 
To
19/05/2018 19:45:50
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01660176
Message ID:
01660178
Views:
89
>The example PRG is for demo only and I use it to open the table. The methods SaveTableToWorkbook() and SaveTableToWorkbookEx() both take the first parameter as the alias (or table path). If you pass the cursor alias name to the method as the first parameter then it will use that as the source for output. If you pass a table file name with path that is not opened then the method will open and close the table for output. The SaveTableToWorkbook() method outputs all columns of the alias passed; whereas, SaveTableToWorkbookEx() allows you to pass an array containing the names of the fields (and column names) to be outputted.

Thank you very much! Yes, I replaced the first parameter with the cursor name and it works!

A cursor with about 2200 records and 52 columns/fields take about 1 minute to export. I am not at all complaining about the speed; the customer will wait whatever is necessary. But, in your opinion, is this normal amount of time?

Update: Please confirm my understanding that in order to use your library I need to include in the project the "vfpxworkbookxlsx.vcx" and nothing else, right?

Update2. I noticed that the book name in the resulting .xlsx file is actually the name of the cursor. And in my case the name of the cursor is sys(2015) so it looks like "_48445354". Is there a way to specify a book name in English so that it looks readable (by the customer)?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform