Hi, Is there a way to read an excel file with spaces in column names

@sheenajenp Hi, 'readExcelColumn' function in the above mentioned plugin should do the work for you when the header names differ from the field names in CDT. The column in the spreadsheet might have any name, but readExcelColumn reads the data based on sheet number.

Also bear in mind that readExcelColumn reads the first cell in the column, which could be typically the column header. If the first cell in the column is header, make sure that the first row is removed after building the cdt array from the results of parsed columns.

As far as the plugin implementation is considered, having the header names same as the field names in CDT will help you in keeping the implementation simple and clean as per my knowledge.

@sheenajenp Hi, 'readExcelColumn' function in the above mentioned plugin should do the work for you when the header names differ from the field names in CDT. The column in the spreadsheet might have any name, but readExcelColumn reads the data based on sheet number.

Also bear in mind that readExcelColumn reads the first cell in the column, which could be typically the column header. If the first cell in the column is header, make sure that the first row is removed after building the cdt array from the results of parsed columns.

As far as the plugin implementation is considered, having the header names same as the field names in CDT will help you in keeping the implementation simple and clean as per my knowledge.