Text to excel issues

Help
1

i have a text file in notepad seprated by commas
i have used excel application scope in which i have passed file name.txt extension

then i select column A and navigate to data->text to columns->delimited width and so on
but the file which is saved is notepad file not excel file

how to save that file?

2

Fine
—use a READ TEXT FILE activity and pass the valve file as input and get the output with a variable of type string named str_input
—now use a GENERATE DATATABLE ACTIVITY and pass the str_input as input and get the output with a variable of type datatable named dt
—now use a excel application scope and inside that a write range activity with dt as input

Cheers @Ananya1

3

could u plz share workflow

4

Sorry buddy I don’t have my laptop near to me
These are the activities to be in sequence
Kindly try this and pls let know for any queries or clarification
I m sure you can do this
Cheers @Ananya1

5

Try Read CSV passing your text file-> create DataTable
Excel Scope → Write Range → pass same DataTable

1 Like
6

im getting error file is too big in read text file

7

message was too large to process

8

@Ananya1 you should not be reading it as text file, you should use the read CSV file as @bcorrea has mentioned

9

but file is in notepad then im converting it in excel
then y we will use csv