how create excel from table

[Qleoz12]

hey Im trying to get luck with this and dont works could you gime some advices, thank you in advance.

loExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx") lnWb = loExcel.CreateWorkbook("ArabicTest.xlsx")

always I have this message "Invalid key lenght" im new in foxpro Im jus triyng to create simple program,I have three files dbf on my folder and my finally objecty is run somthing like this ---folder your files from zip (WorkbookXLSX R31.zip)

table1.dbf table2.dbf table3.dbf

set defa to "folder" modi command testprogram

(inside testprogram) loExcel = NEWOBJECT("VFPxWorkbookXLSX", "VFPxWorkbookXLSX.vcx") loExcel.SaveTabletoWorkbook(table1.dbf, "myexcel.xlsx", .T., .T.) loExcel.SaveTabletoWorkbook(table2.dbf, "myexcel.xlsx", .T., .T.) loExcel.SaveTabletoWorkbook(table3.dbf, "myexcel.xlsx", .T., .T.)

[ggreen86]

Please send me a copy of the tables if possible so that I can reproduce your error message? As for your test code, the fourth parameter in the method (.T.) indicates to save the table to a physical file. So you need to have different xlsx file names or the first two calls to the method has .F. for this parameter which will then add a new sheet. The last call will then save to a physical xlsx file.