For above question, try below below file.
sample----- (2).xaml (30.0 KB)
I have the input files in a folder,i have to read each excel sheet in the folder and i need the output as shown in output folder,In the L column with customer id L0712 represents date.
I need that to be write into another excel file,In some excel files,there are multiple dates,i need to read it dynamically.
Can u please give me the sample file of this.New folder.zip (49.0 KB)
Hi Manju Natha
I have done the work flow for the above excel files.reading_excel_files_in_folder.xaml (18.6 KB)
It is showing the following error.
Can u please help me on this by modifying my work flow related to the data as shown in the excel files.
Ok Manju Natha,
I need the output as shown in the output folder of excel files.
@krishna124 no bro i am occupied with some work. After i become free i will look into urs.
@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)
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.
@ 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)
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.