Hi All,
Am trying to import the excel file into DB using the Import Excel to Database smart service available in Excel tools. Am getting the following error when i try to run the process
???Unknown column '' in 'field list'???.
My table column names are same as the one in the file header.
Have anyone faced the similar issue , or aware of the constraints for this smart service can suggest on the same please??
Regards,
Thoufiq.
Discussion posts and replies are publicly visible
Hi Thoufiq,
you can use the below readExcelSheet function of Excel Tool plugins like this:
load(local!recordSets: readExcelSheet(excelDocument: ri!document,sheetNumber: 0,startRow: 2,numberOfColumns: 0 /*reading all columns*/).result.values,local!count: count(local!recordSets),a!forEach(items: 1 + enumerate(local!count),expression: load(local!data: split(joinarray(local!recordSets[fv!item],"; "),"; "),'type!{urn:com:appian:types:DTP}DTP_CustomerDetails'(FirstName: local!data[1],LastName: local!data[2],Address: local!data[3],Phone_Number: local!data[4]))))
would love to use readExcelSheet but they are deprecated and could stop working in future release of Appian
Hi Sitongc,
readExcelSheet() function is not deprecated. I have used the latest version only. Few people without verifying spreading wrong rumour. U can use the latest exceltools (v2.2.5)
Hiya Sitong - if you're unsure which plug ins we are using in our environment that are deprecated then get in touch with me at work. There have been many excel / csv style plug ins deprecated as the recommendation is to use Excel Tools instead, which does offer up various read options.