André Vieira wrote: Hello Sir,
I am sorry because I haven't post my question separately. Because I have same question.
"None of the column headers match with the record attributes".
At the time of ExportToExcel I have set Date column as Text DataType and used DateToText() function to convert it into Text format. Because I am showing "-" OR "TBD" text depends on condition into date column.
Date 05-16-2013 OR Date "-" OR Date "TBD" i.e. I have set date column to Text datatype
At time of ImportToExcel I have used TextToDate() to assign date value to respective date column.
Please suggest me, How to solve above error.
Thanks and Regards,
My first suggestion is to use the debug feature to understand the flow, the TextToDate is only used in the assign node and that node most certainly comes after the ExcelToRecordList node. The exception you are getting is on the ExcelToRecordList node. Make sure you pass the right binary content to it and that the structure definition matches the one of the Excel file - names and types (Text is a fail safe type in this case so you can try to create a structure with the same attributes as the excel, with attributes names matching the values in the first row of the excel, and with Text data type for everything).