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

@krishna124 no bro i am occupied with some work. After i become free i will look into urs.

@Manjuts90
OK bro,
When u r free,once look into it.

@Manjuts90
Hi bro,
Have u seen that sample file.

@krishna124 I changed few things. Check the workflow. Y u didn’t checked headers options in both read range and write range activities.

Reading_files_in_folders.xaml (25.5 KB)

@Manjuts90
Hi,
It is showing the error “object reference not set to an instance of the object.”

@krishna124 need input file to check that error bro may be error occurring due null value generated somewhere also.

1 Like

@Manjuts90
Ok bro,
Have u seen my input files and output excel files.

@ krishna124 I dont have any files bro.

@krishna124 i have modified file. Find the file below. Change the input folder path.

Reading_files_in_folders.xaml (26.3 KB)

@Manjuts90
Hi bro,
For this i am getting only the single date data writing into excel file(i.e; for 12th which is in sample2.xlsx) and not getting data from “sample1.xlsx”(in this data,i have 13th and 14th date data).
It is not writing into separate excel file.

1 Like

@krishna124 I have made changes. Check the file below.

Reading_files_in_folders.xaml (27.5 KB)

@Manjuts90
Hi bro,
If i have more files in the folder,getting the error as “If : Object reference not set to an instance of an object.”

1 Like

@Manjuts90
Hi bro,
While i am running my original files,there is some empty data in “L” column.
That is why it is showing this error.
Is there any way,to remove empty rows before using get row item of columnL.

1 Like

@krishna124 use if condition to check null value, If value is null, skip the that row.

1 Like

@Manjuts90
Ok bro,
If condition is to write above the Get row item or below the get row item.

1 Like

@krishna if that value is null what u wanted to do?

1 Like

@Manjuts90
If the value is null,i want to skip it.

@Manjuts90
Hi bro,
I got it and the the sorting order in Store column is missing in output.Reading_files_in_folders_main.xaml (28.3 KB)

@krishna124 u want skip entire process after it.

@Manjuts90
No bro,
I want to skip the rows,where it is empty.