How to select Header Value

[mohamedalthaf]

Hi Guys!!

The attached screenshot is my input excel. In the input sheet the header is Jan-2022 but its value is showing as 01-01-2022. when I try to get the values in Jan-2022 column BOT showing “no Jan-2022 column found” error due to its 01-01-2022 value. How can i make the Jan-2022 as my header value

Plz help me on this!!
Thanks in Advance

[jack.chan]

can you type Jan-22 as 'Jan-22?

[muhamed.fasil]

when you check the column value , try to parse exact the value you have to date format and cross verify

[Sam_Abraham (Sam Thomas Abraham)]

Can you try giving Preserve Format while reading datatable

[ppr (Peter)]

preserve format option for read range would slow down the process but maybe can help

otherwise:

• untick addHeaders option
• read range
• rename the column names with the help of DateTime.ParseExact(…).toString(“MMM-yy”)
• remove first row after column name renaming

[mohamedalthaf]

Hey @ppr Can Plz explain me the Third Point in Detail

[mohamedalthaf]

Hi @Sam_Abraham If I enable Preserve Formatting Option, then all the values of the column were wrote in the preserve format, is there any way to get the values in normal type