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

Help Studio
, , ,
1

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

2

uncheck AddHeaders in the read range property.

image
image965×441 22.7 KB

3

In User case it may be Has Headers.
image

4

thanks abhishek for you reply .

But from the above solution , im getting the below result
image

i wanted to read and write in the below format
image

5

You Have to convert the format after reading the file.
image
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
image
Date is a String Type.
Let me know if this works for you.

6

@abhishek.gupta
can you please explain steps how to do it

7

After getting your result as you have shown above
image
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

8

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

9

Sorry for the delay. What you mean by folder?

10

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