Hi,
I access an Excel table like this:
goExcel = CREATEOBJECT("excel.application")
loBook = goExcel.Workbooks.Open(lcSourceFile)
goExcel.Visible = .T.
lnRows = loBook.ActiveSheet.UsedRange.Rows.Count
lnCol = loBook.ActiveSheet.UsedRange.Columns.Count
But I do not know how to transfer the content of the opened Excel sheet to a VFP table.
Has anyone an idea? Any help would be appriciated.
Best regards
Klaus
I access an Excel table like this:
goExcel = CREATEOBJECT("excel.application")
loBook = goExcel.Workbooks.Open(lcSourceFile)
goExcel.Visible = .T.
lnRows = loBook.ActiveSheet.UsedRange.Rows.Count
lnCol = loBook.ActiveSheet.UsedRange.Columns.Count
But I do not know how to transfer the content of the opened Excel sheet to a VFP table.
Has anyone an idea? Any help would be appriciated.
Best regards
Klaus