Hello, Thanks for posting your code to append from XLSX type. I am getting an error "Unknown LAFIELD - Undefined". What is the correct way to call your AppendFromXLSX ? Thanks for your help !! Kent
Can you elaborate, maybe provide a sample to my email, please? The table or cursor must be opened before calling the prg. USE mytable && or SELECT mytable do appendfromxlsx WITH "my_excel_file.xlsx","mytable"
To skip first row from the xlsx document: do appendfromxlsx WITH "my_excel_file.xlsx","mytable","",2
To get data from the third sheet, begining with the fifth row: do appendfromxlsx WITH "my_excel_file.xlsx","mytable","",5,3
If the sheet has empty cells, then the last parameter must be true: do appendfromxlsx WITH "my_excel_file.xlsx","mytable","",5,3,.T.
Finally, to populate only a subset of table's fields: do appendfromxlsx WITH "my_excel_file.xlsx","mytable","field1,field2,field3"
Hello, Thanks for posting your code to append from XLSX type. I am getting an error "Unknown LAFIELD - Undefined". What is the correct way to call your AppendFromXLSX ? Thanks for your help !! Kent
RăspundețiȘtergereCan you elaborate, maybe provide a sample to my email, please?
RăspundețiȘtergereThe table or cursor must be opened before calling the prg.
USE mytable && or SELECT mytable
do appendfromxlsx WITH "my_excel_file.xlsx","mytable"
To skip first row from the xlsx document:
do appendfromxlsx WITH "my_excel_file.xlsx","mytable","",2
To get data from the third sheet, begining with the fifth row:
do appendfromxlsx WITH "my_excel_file.xlsx","mytable","",5,3
If the sheet has empty cells, then the last parameter must be true:
do appendfromxlsx WITH "my_excel_file.xlsx","mytable","",5,3,.T.
Finally, to populate only a subset of table's fields:
do appendfromxlsx WITH "my_excel_file.xlsx","mytable","field1,field2,field3"