Excel Not opening

Shriharsha_H_N · July 10, 2019, 2:20am

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.

lakshman · July 10, 2019, 2:30am

@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.

Shriharsha_H_N · July 10, 2019, 2:35am

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

lakshman · July 10, 2019, 2:37am

@Shriharsha_H_N

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

Shriharsha_H_N · July 10, 2019, 2:45am

@lakshman Yes Installed

lakshman · July 10, 2019, 2:47am

@Shriharsha_H_N

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

Shriharsha_H_N · July 10, 2019, 2:54am

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

lakshman · July 10, 2019, 2:56am

@Shriharsha_H_N

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

Shriharsha_H_N · July 10, 2019, 3:00am

@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

lakshman · July 10, 2019, 3:05am

@Shriharsha_H_N

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

Shriharsha_H_N · July 10, 2019, 3:16am

Ok will check and get back to you
Thanks

Shriharsha_H_N · July 10, 2019, 3:30am

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

lakshman · July 10, 2019, 3:33am

@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.

Shriharsha_H_N · July 10, 2019, 3:36am

Medical_Insurance.zip (19.2 KB)

lakshman · July 10, 2019, 4:02am

@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 ?

Palaniyappan · July 10, 2019, 4:19am

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

Shriharsha_H_N · July 10, 2019, 4:23am

@Palaniyappan Thanks its works

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

Palaniyappan · July 10, 2019, 4:25am

Fantastic
Cheers @Shriharsha_H_N

Palaniyappan · July 10, 2019, 5:13am

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

system · July 13, 2019, 4:27am

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