Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing XLSX FILES
Message
 
 
To
27/08/2011 19:16:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01522010
Message ID:
01522013
Views:
87
Check http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx

>
>A client of mine needs to import prices from an Excel file.
>
>Till now he could do this with the only condition of renaming file without spaces
>
> IMPORT FROM (NARCHI) TYPE XLS
>
>works fine.
>
>But...
>
>Now there is another provider and he publishs his prices in a XLSx file...
>
>I did it easy. I "saved as..." 97-2003 format and Excel warned me: "Some characteristics... Proceed any way?" YES
>
>Now I have an XLS and I try to import.
>
>I don't know the message in English but a translation could be:
>
>"VFP SP2 is not working any more. Do you want to search a solution on line or close VFP?"
>
>If I choose "search" it seems to search but it closes without saying "Sorry" at least.
>
>Till now I haven't seen when I choose "search" it finds any solution for any trouble like this.
>
>Is there any way of importing XLSx files in VFP SP2?
>
>I must say the problem is between TRY... CATCH structure but VFP laught at them...
>
>You know I can't tell my client "You can't actualize your prices" so I'll export and change columns and arrange the file and FINALLY I'll convert the file so that there is not problem but since my client is not a corporate client and he doesn't want to be one of that kind I can't tell him every steps he would have to do if I die.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform