How to read the csv file which has formula value in header , but we want to read the value and not formula of the same

In the above screenshot we could see the yellow color row , i wanted to read that row as Jan-22 in the header

uncheck AddHeaders in the read range property.

In User case it may be Has Headers.

thanks abhishek for you reply .

But from the above solution , im getting the below result

i wanted to read and write in the below format

You Have to convert the format after reading the file.
Currently your getting the Normal DT Date. To Convert it use

CDate(Date).ToString("dddd, MMMM d")

or use

CDate(Date).ToString("MMM yy") 

To get this one
Date is a String Type.
Let me know if this works for you.

can you please explain steps how to do it

After getting your result as you have shown above
apply the CDate(Date).ToString("MMM yy") to each date value you need to convert.
Date is a string variable which holds the current Cell data. Refer the code and let me if it works for you.
Main(Autosaved).xaml (7.8 KB)
If this Doesnot work please update your excel file here

hi abhishek ,
can you please share the complete folder of your solution ?

Sorry for the delay. What you mean by folder?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.