Excel version issue while automating

[Tanya_Verma]

I’m trying to take filtered output out of the data table into excel but unfortunately, the version installed on my machine is 2007 and UiPath is asking me to have a 2010 or newer version of excel due to which I’m not able to automate my excel. Please suggest to me if I can continue my work with the help of workbook activities then what steps need to be taken or upgrading excel is the only option?

[Venkat4 (Venkat)]

Hello @Tanya_Verma

you can use Write Range Workbook activity. It does not require the excel to be installed on the machine and hope you can try opening the excel with 2007 version after executing.

Cheers

[Anil_G (Anil Gorthi)]

@Tanya_Verma

Welcome to the community

As suggested you can use workbook activities which does not need Excel.

Also you can try going to Activities → Then filter Icon → Show classic

Then you can see classic excel activities which might support 2007

cheers

[Tuannna1 (Tuan Anh)]

You can use the Excel Application Scope activity in UiPath to automate your work with Excel 2007. You will need to add the activity to your workflow and then configure it to connect to the existing Excel 2007 installation on your machine. Once you have an Excel Application Scope, you can use the various workbook activities such as Read Range, Write Range, and Append Range to interact with your Excel data.

It’s important to note that while you can use Excel 2007 with UiPath, some of the features and functionalities of the automation may not be fully supported, so you may encounter limitations.

Here are the steps to automate your work with Excel 2007 in UiPath:

1. Add the Excel Application Scope activity to your workflow.
2. Configure the Excel Application Scope to connect to your existing Excel 2007 installation.
3. Use the workbook activities to read, write, and manipulate your data in Excel.

Keep in mind that it’s recommended to use a more recent version of Excel, such as 2010 or newer, for full support and compatibility with UiPath.

[Tanya_Verma]

Thank you so much @Venkat4

[Tanya_Verma]

Thank you so much @Anil_G
It worked

[Anil_G (Anil Gorthi)]

@Tanya_Verma

Happy Automation

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Cheers

[Tanya_Verma]

Thank you so much for your reply @Tuannna1
I appreciate your suggestions, I’ll surely do the same.