How to maintain Datatable format while writing in Excel

Help Studio
, ,
1

Hi,

I have datatable whose columns headers can contain any “9-10” like header name
So after writing in excel, this header is formatted to “10-Sep” which is incorrect

Does anyone has any solution to maintain the format of DT while writing in excel?

2

@Shreya_Rao1

May I know from where you are getting this Input data ?

If you are reading data from Excel file using Read Range activity then check Preserve Format option in it and then check once.

3

Hi @lakshman ,

I tried this but still not working
Below highlighted header is from input file for which I need to preserve the format

image
image741×142 5.2 KB

and this is how its coming up in output file even after doing what u suggested

image
image908×137 3.85 KB

4

Hi @Shreya_Rao1

You can try to change the value in the cell.

use Excel application Scope → Your path

Use Write Cell Activity

Set the Range based on the need

image

Can you share the sample excel file

5

But the position of that column is not fixed

6

HI @Shreya_Rao1

Try to change the cell format

Regards
Gokul