Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Greg Green XLSXWorkBookVFPX for extracting from Ex
Message
 
 
To
30/11/2018 09:01:15
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01663900
Message ID:
01663909
Views:
55
>>Hi,
>>
>>I am looking at the Greg Green's XLSXWorkbook VFPX project. I would like to try it for extracting/converting an Excel file into a DBF/Cursor.
>>
>>I see a small program, testextract.prg But when I run it, it take an Excel (xlsx file that I specify) and creates another Excel file. This test program is using a method SaveWorkbookAs() but when I search through the PDF documentation I cannot find this method. I am guessing that this method has a parameter that can be used to save the resulting file into a cursor or a table.
>>But since I don't see the docs, I can't figure it out.
>
>See if the discussion in my article helps:
>
>http://www.tomorrowssolutionsllc.com/Articles/Sending%20Crosstabs%20to%20Excel.PDF
>
>Don't be thrown by it mentioning crosstabs.
>
>Tamar

I scanned (I admit I didn't read) your article. And it talks about converting data into an Excel file. I am looking for a way to use the XLSXWorkbook VFPX project to convert data from Excel into a DBF/cursor.
I use XLSXWorkbook VFPX project for converting cursor to an Excel and it works perfectly. And now I am trying to figure how to use it in the opposite direction.
"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