Save Excel as .txt keeping the format of cells?

Hi All,

I can’t find an option to save from excel to .txt so I’m using the activity for .csv, the problem is that it does not keep the same format as the sheet…at least not for dates; how can I do that?

Example:

Input:

Output:

image

image

I tried what you made,
the problem i encountered is the data type in the excel file.
When the data type in Excel is replaced with a text type, it will run smoothly

1 Like

Since I can’t change the source format due to a restriction, then what I did was create a macro in excel to save a copy in .txt format, in this way it preserves the source format; after that, I just ran the macro from uiPath.

Macro:
image

Activity:
image

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