I have a existing excel file and i want to write my build data table data into my existing excel file but which has some data present into my existing excel?how?

Help Studio
, ,
1

hi team,

i have a existing excel file and i want to write my build data table data into my existing excel file but which has some data present into my existing excel?how?

please find the existing excel file below
Existing table.xlsx (9.0 KB)
actual output.xlsx (9.1 KB)

this my data table data file below:
New Microsoft Excel Worksheet.xlsx (7.4 KB)

My acutual output like this below excel sheet

2

Hi @Naveen_Kanike

The Append Range activity automatically adds the new data below the last used row without requiring you to calculate the starting cell.

Use the Append Range activity, specify the sheet name, and pass the DataTable. The data will be appended at the end of the existing data.

Thanks,
Muthuraj

3

Can u tell me how to do that with example of given excel sheets

4

Hi @Naveen_Kanike ,

Please check this xaml file.

Thanks,
Muthuraj
AppendDataTable.xaml (9.9 KB)

5

i want my output as like this below
actual output.xlsx (9.1 KB)

6

are you there @Muthuraj_Chidhambaram1 ?

7

Yes @Naveen_Kanike

Give 5 Mins I will send you a xaml file.

Thanks,
Muthuraj

8

okay @Muthuraj_Chidhambaram1

9

Hi @Naveen_Kanike ,

Use this xaml file
Main.xaml (12.9 KB)

This image shows a screen from UiPath Studio, highlighting a "Watch" window with data entries and workflow steps related to manipulating Excel files. (Captioned by AI)
This image shows a screen from UiPath Studio, highlighting a "Watch" window with data entries and workflow steps related to manipulating Excel files. (Captioned by AI)1725×856 64.7 KB

Thanks,
Muthuraj

10

i use that but iam not get any thing in existing table.xlsx file?

i tried to print in message box which show empty message box

11

Hi @Muthuraj_Chidhambaram1
when ever i tried to write in different file it not writing po number and bill of entry and amount values.

If possible could u connect i show my results

12

Are you there @Muthuraj_Chidhambaram1 ?

13

Hi @Naveen_Kanike
Yes we can connect

Thanks,
Muthuraj

1 Like
14

Hi @Muthuraj_Chidhambaram1,

Could you please connect i can explain to its only 10 min please ?

15

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