I have an Excel file containing bill data. I need to use UiPath to automate the following process: Split the data: For each unique bill number found in column E, create a separate Excel workbook. Naming Convention: Name each new workbook using the format “Bill_[bill_number]_[timestamp].xlsx”. Work…

Hi @CHINH_TRANTAN Can you try this [This image shows an automation workflow that reads data from an Excel sheet, groups it, and writes each group to a separate workbook. (Captioned by AI)] For Each : dt_Input.AsEnumerable().GroupBy(Function(x) x("Bill").ToString()).Select(Function(x) x.CopyToDa…

Create a separate workbook for each unique bill number,

Help StudioX

system (system) Closed March 15, 2025, 8:42am 6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Splitting Excel Data into Multiple Sheets Based on Unique Values Studio studio , question , activities_panel	3	853	May 20, 2023
Separate unique values from a column and write them on another sheet Studio activities , studio , question	5	1483	May 2, 2023
Identify range numbers Help	3	1054	February 28, 2019
Select a particular element checkbox using classic click StudioX studiox , question	1	43	July 26, 2024
How to save excel files with different names or number? + Additional questions Help excel , activities	10	2780	April 27, 2019

Create a separate workbook for each unique bill number,

Related topics