How to automate day to day excel reports

Help Activities
, ,
1

I want to automate my day to day excel reports

2

Can you provide more details wnat exactly do you need, if you want to work with excel you could use Excel activities from UiPath, screenshot below:
You could try classic n modern both.

image
image480×690 17.9 KB

3

Hi @giriharishg

You can automate the excel automation with excel activities. For using the excel activities install the UiPath.Excel.activities package from the manage packages in UiPath Studio. Find the below image for excel activities.

image
image383×870 24 KB

Instead of using excel activities you can use the workbook activities. Search the workbook activities in Activities panel. Find the below image for Workbook activities.
image

To Learn about the excel activities, find the below link:
https://docs.uipath.com/activities/other/latest/user-guide/about-the-excel-activities-pack

Hope it helps!!

5

Hi @giriharishg ,

Depending on your requirement of the report to automate,

You can either use UiPath.Excel.Activities packages which gives you a range of excel related activities.

Or

An exvel Vba code which can be triggered from UiPath only using invoke vba.

Or

Create a Excel Macro, vba inside excel itself , again this also can be triggered from UiPath.

If you need more detailed steps. We need more details the steps involved in creating the report forumlae, pie charts, pivots etc…,

Thanks,
Gautham.