Insert row at any position in an excel file

Help
1

I can’t use app integration in excel as it doesn’t work in my laptop.
So there is any logic to insert a row at any position in excel using other technique.

2

You can interact with excel files using VB.Net code and the InvokeCode UiPath activity:

https://social.msdn.microsoft.com/Forums/office/en-US/751c9308-3ef9-4354-a4d8-2d84716ab30f/insert-a-row-in-excel?forum=exceldev

3

Can you share me workflow

4

There are many examples on the forum of interacting with Excel using VB code.

However, if “excel doesn’t work on your laptop”, it may still not help you. You need excel to work with excel files.

5

I have tried all the possible sol to excel to work but not get the output so, plz find any way to insert row in database,
Thanks in advance.

6

What database are you referring to? If you do not have excel you cannot use the UiPath excel activities.

7

To perform some of the Excel services even when Excel is not installed on your machine, you can use “Workbook” related activities.
I have created a workflow that uses “Workbook” activities and inserts a row at any position - InsertRowAtAnyPositionInExcelWithoutUsingExcel.xaml (10.5 KB)
The steps followed were -

  1. Read the input sheet into a data table
  2. Find out the position where you want to insert the new row.
  3. Copy the rows that are present before the insert position from input data table to a new data table
  4. Now add the new row to the new data table
  5. Copy remaining rows from the input data table to the new data table.

Hope this helps!

1 Like
8

@KartikPurohit - Did you try the above workflow? :slight_smile:

9

Yes,but I am working on some project in which I have to insert new row multiple times also have a watch on time complexity , tnkx for your assistance and sorry for late reply.