I have an excel file which has formula in it i.e. =C2+2 and in C2 cell i have =TODAY() date, you can find the details in the excel file provided by me
Book1.xlsx (10.1 KB)
, when i read this cell by ticking preserve format Check box in datatable it is reading it in general format. Example in an excel file which contains a date 6/30/2021 after reading it, it is getting converted to general format 44377. You can check the output provided in output.xlsx file
output.xlsx (8.4 KB)
Please help me as to how i can solve this issue. Any guidance will be really helpful and appreciated.
Please find the attached workflow which i used for reading and writing the excel file.
BlankProcess2.zip (15.9 KB)