How to read column in excel file and copy into another excel file

Help
,
71

@krishna124 after getrow item check for the null value

72

@Manjuts90
Hi bro,
I am getting the output correctly,after that i have to sort the “Store” column in ascending order.
For that,it is not sorting.Reading_files_in_folders_main.xaml (28.3 KB)

73

@krishna124 what error u getting.

74

@Manjuts90
I am not getting any error,but the output files are not getting.

75

@krishna124 i am not sure y u not getting, for me files are generated

76

@Manjuts90
Ok bro,
I need the store column be in sorting order(Ascending) and all the data related to that column have to be sorted.

77

@krishna124 u said now files are not getting generated

78

@Manjuts90
It is generating bro,i have made the changes,but the data is not coming in sorting order(ascending)
based on “Store Column.”

79

@krishna124 Before writing the excel sort the datatable then u will get sorted values. But my files are are in sorted order only

80

@Manjuts90
Hi bro,
I am getting the files in sorting order only, In each file “Store Column” is not in sorting order(ascending).
I need it in sorting order.

81

@Manjuts90
Hi bro,
Done,Files are coming in sorting order.

82

@Manjuts90
Hi bro,
Do u have any idea about running robot from aws ec2 instance.

83

@krishna124 i dont have idea

84

@Manjuts90
Ok bro

85

@Manjuts90
Hi bro,
In my work flow,while writing data into excel, “ColumnI” and Column “ID”(actually both the columns contains numeric values) is writing as text format,how can we change that format.Main.xaml (33.2 KB)

86

@Manjuts90
Hi bro,
These are the input and output files.New folder.zip (46.7 KB)

In the output file “ColumnI” and column “ID” are writing as text format.

87

@krishna124 i don’t have uipath in my system. I will look into ur query once i install uipath

88

@Manjuts90
Ok bro