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

CHINH_TRANTAN (CHINH TRANTAN) March 12, 2025, 8:11am 4

Dear Irtetala,

Thank you so much for your support!

Your idea was exactly what I needed to fix my problem. I really appreciate it.

1 Like

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