ReadExcelByHeaders

Question

Hi everyone , 
 I have a scenario to use ReadExcelByHeaders. 
 But it is throwing me an error: Expression evaluation error at function 'readexcelbyheaders' [line 3]: java.lang.NullPointerException: Cannot invoke "java.util.Map.entrySet()" because "expectedHeaders" is null

Anusuya K Mahalingam · Answer

This is working if we use the header patterns in Matchconfig.

Shubham Aware · Answer

I would recommend if you could need any more details to refer this document for future reference. PDF

Harsha Sharma · Answer

In database structures column names don't support spaces. And the excel columns headers also should not have spaces. This is to ensure proper match in case multiple columns are there with similar names. Thats why in standard practice avoid spaces in column/header names. If you are getting spaces dynamically then use functions like trim() to remove the leading/trailing spaces.

ReadExcelByHeaders

Top Replies