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?
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
could u plz share workflow
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
Try Read CSV passing your text file-> create DataTable
Excel Scope → Write Range → pass same DataTable
im getting error file is too big in read text file
message was too large to process
@Ananya1 you should not be reading it as text file, you should use the read CSV file as @bcorrea has mentioned
but file is in notepad then im converting it in excel
then y we will use csv