It I want combine file excel follow date after _ data ( _27052021 3 file —> 1 file , _28052021 3 file ) [image] From Example : I have file name _27052021 3 file —> I want output 3 sheet but 1 file and keep source column width. data.zip (43.5 KB) Example file 27052021 : output_27052021.xls (58.5…

Hi @fairymemay , Please try following steps to reach your goal: new DirectoryInfo(folder_path) (Assign it to dir_info as shown below: [image] Loop it in for loop with the file format [image] Now each for loop item will give you the file name As per your condition make sure that the fi…

@Shubham_Varshney How to match file name(same date) and write keep source column width?

from the 3rd step, you will get the file name of all the files in the folder. You can compare that against your requirement. If you are good with the solution, please mark it as solution :slight_smile:

@Shubham_Varshney How to write excel keep source column width?

For Column width you can refer the following article: [image] How to Set Column width in Excel Help Hello @iumerparay , After writing data in excel, you want to auto-fit the column right? Then, using Invoke VBA could be a option. firstly write the code below in txt file…

Combine excel multiple file?

Help Activities

Shubham_Varshney (Shubham Varshney) May 30, 2021, 11:01am 6

For Column width you can refer the following article:

1 Like

Topic		Replies	Views
Loop through file names including date Help excel	5	855	October 24, 2019
Merge excels from 3 folder Activities datatable , excel , uiautomation , mail , activities , question	3	294	November 28, 2023
How to merge different excel files into single excel file Automation Ops question , automation_ops	32	747	November 21, 2023
Merge multiple excel files into one Activities excel , activities , question	2	2184	July 6, 2023
Need help in merging 3 excels Studio excel , studio , question , activities_panel , excel-automation	3	406	October 19, 2023

Combine excel multiple file?

Related topics