I am importing data from an excel and getting this error " Definition of columns headers must start at the A1 cell in the 'Table 1' Worksheet. " I have attached a image of the excel sheet i am trying to import
Hi Piyush Vijay,
Can you confirm that the structure you are using to convert Excel to List of Records ('Record Definition' property of the 'ExcelToRecordList') has the same structure as Excel? Does it have 3 attributes: ZIPCode, City and Country?
Would it be possible to share the excel sheet that you are trying to import ? Or may be a subset if whole file cannot be shared.
The 3rd column name in excel is 'County' instead of the 'Country', can you please rename that and try it.
I created a bootstrap sample for zipcode import at my end and it is working fine, attached the oml.
Can you please share your excel file and the structure attribute with data type as well as Entity Attribute with data type.
ThanksPankaj