Hello all, I have been stuck on this for an embarrassing amount of time. I am getting categories from outlook messages and building a data table to output to an excel sheet. Basically the every time I run the bot it should output a row like… Date | Category Count 2/28/2024 | 8 And every time I u…

[UiPath Code] This is what I am using. Basically sheet two outputs a row and I want to move that row to sheet 3 that has all the rows from every bot run. But the problem, lets say I write range gets 10 emails, those 10 emails should be aggregrated into one row, but in the append range it adds a ro…

in the append range you are writing a different datatable that is not needed , Instead write the same datatable specified in writerange

Append Range: Exception from HRESULT: 0x800A03EC - I am getting this error now for the append range. I have troubleshooted everything, but still getting the error.

Hi @srobey888 Please try this [image] OldData: [image] NewData: [image] FinalData:(OldData) [image] Regards,

Hello, I have not been able to use the workbook activities because I get the Method not found “Void ClosedXML” error and could not figure out why

@srobey888 Can you please share your xaml file

Unfortunately I can’t because of the sensitive data, but I do have all my packages fully updated, so I know that is not the problem.

@srobey888 No problem. Atleast can you share the ss of workflow

@srobey888 Why are you using Write Range and Read Range? No need to use Write Range and Read Range you can directly use Append Range activity [image]

Adding new rows to excel sheet

Help Studio

lrtetala (Lakshman Reddy) March 1, 2024, 4:45pm 18

@srobey888

Try to update UiPath.Excel.Activities Package

Topic		Replies	Views
Adding new rows to a sheet and keeping old rows Studio datatable , excel , uiautomation , mail , studio , question , activities_panel	12	298	June 6, 2024
How to achieve this Activities excel , activities , question	6	390	January 3, 2024
Need to append row at the bottom of the excel Help studio	16	14441	March 11, 2019
Append to datatables using write range Activities excel , activities , studio , question	8	1354	July 24, 2023
How to store all the data using write range when I am trying to add new data it's replacing old data Activities excel , studio	10	148	October 3, 2024

Adding new rows to excel sheet

Related topics