>>>>Take a look at:
>>>>
>>>>
http://vfpx.codeplex.com/wikipage?title=XLSXWorkbook&referringTitle=Home>>>
>>>Greg, Antonio
>>>
>>>I have downloaded the class and I'm looking at the example form. I have looked through the documentation PDF file. But I cannot find how to Save an XLSX (or XLS) file previously opened into CSV format ? Any suggestions.
>>
>>Greg already gave you a suggestion on how to do it, but just remember that once you have XLSX data in a VFP table or cursor, the capacity of export it to CSV is native to VFP.
>>
>>Don't forget, also, that if the source file is in XLS format - that is, in the binary format that preceded XLSX - then VFP is able to natively support its ingestion.
>
>Thanks Antonio. I need to support both XLS and XLSX as I will not know what format is being sent. Users ... ! :)
By now, you already know that you must read them separately, but once they are in a table/cursor, they both can be handled in the same way. Something like this (no error handling or tidying up):
LOCAL lcFile AS String
DO CASE
CASE UPPER(JUSTEXT(m.lcFile)) == "XLSX"
ImportXLSXIntoACursor(m.lcFile)
CASE UPPER(JUSTEXT(m.lcFile)) == "XLS"
IMPORT FROM (m.lcFile) TYPE XLS
OTHERWISE
ENDCASE
COPY TO outputFileName.csv TYPE CSV
----------------------------------
António Tavares Lopes