Excel Not opening

Hi i try to develop login to different websites using stored login credentials from excel and upon logging in download docs and store them in separate folders. but excel itself not opening its showing on error could you anyone can help. Exception screenshot attached.

image

@Shriharsha_H_N

If you want to work with Excel Application Scope activity then Excel application is installed in your machine and then only it will work.

Else you can try with Workbook activities and for this no need of excel application to be installed in our machine. Attached is the Workbook Read Range activity.

image

1 Like

Hi @lakshman
i used excel application scope and read range activity both

@Shriharsha_H_N

First tell me one thing Is Excel application is installed in your machine or not ?

@lakshman Yes Installed

@Shriharsha_H_N

Ok. Go to Manage Packges and update required packages like UIPath.Excel.Activities and try once.

1 Like

@lakshman I tried and update to latest version but same problem

1 Like

@Shriharsha_H_N

May I know what version of UIPath are you using it ? And also is it Community or Enterprise Edition ?

@lakshman Studio 2018.4.6 - 06/04/2019
Community Edition
Windows Installer

Expires in 8 weeks
License Provider: External

Microsoft Windows 10 Enterprise 64-bit
.NET Framework Version 4.7.2 or later

@Shriharsha_H_N

There is new version of community edition available. Could you please install latest one 2019.6 and then try it once.

Ok will check and get back to you
Thanks

1 Like

@lakshman i have updated the studio version but having same issue

@Shriharsha_H_N

Open one excel file and show me screenshot of it.

And also share your workflow with me and will check and update you.


Medical_Insurance.zip (19.2 KB)

@Shriharsha_H_N

I ran the same workflow file you sent and its working fine from my end. Don’t know whats went wrong your side.

Could you please try with different Excel package versions. And also then excel you installed in 32 or 64 bit ?

image

1 Like

Hi buddy
@Shriharsha_H_N

I think we need to remove th win32 if win64 bit is used of excel
Kindly have a view on this which could solve your issue for sure
Error opening workbook. Make sure Excel is installed

Or still if this issue persists use read range from workbook activities in the activity panel instead of excel activity

Cheers @Shriharsha_H_N

@Palaniyappan Thanks its works

@lakshman Thanks for your pressies time spend for solving my problem

3 Likes

Fantastic
Cheers @Shriharsha_H_N

Kindly close this topic with right comment marked as solution that could help others as well buddy
Cheers @Shriharsha_H_N

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