"Validation Errors" while Publish

[GhostBuster]

I wrote a simple flowchart to read a value from an existing Excel file by using following two activities:

1. System - file - workbook - read cell
2. App integration - Excel - read cell

With activity 1, the Publish is completed successfully. But it fails with 2nd activity with an error message below:

Thanks in advance!

[Yoichi]

Hi,

Is there a warning icon at the upper right corner of the Read Cell Activity?
You need to use “App integration - Excel - read cell” in “Excel Application Scope”.

Regards,

Yoichi

[GhostBuster]

Hi, @Yoichi,

There is no warning icon as show below and it works perfectly in local Studio.

[Yoichi]

Hi,

If you use 2019.8CE, press shift+F8 and check Error List. (Click “Error list” at the bottom of the window)
Can you try it?

Regards,

Yoichi

[GhostBuster]

No Errors found.
As I mentioned, it works perfectly in Studio but is not able to be published.

[Yoichi]

Hi,

I suppose there might be a file which includes some errors and the file is not related with running.
Is there a file with warning red icon in the project panel - expand all?

Regards,

Yoichi

[AndyMenon]

There was an issue with the Excel App Scope early this week. I posted a bug report on it.
Can you check this post here?

RunAllTests.xaml Failing with ExcelApplicationScope Error!

The only change since last night was that I installed the Computer Vision Package into my UiPath CE Studio environment. The version is 2019.8.0 CE. I’m not sure what happened here. But here are the issues that I’m facing. Screenshots published below each of the items listed below : All the REFramework Projects successfully deployed to Orchestrator are failing to deploy There is only one error that is preventing the deployment: [image] If I Run the RunAllTests.xaml, it fails with this err…

[jogayon001 (Jay Armand Ogayon)]

Hi.

The solution for this is to create an output (variable) for the Excel Application Scope.

Please read on this post by @Lahiru.Fernando for further details.

How to Solve The Recent Validation Error In Excel Application Scope

Hello Guys, Problem Statement With the latest update of the UiPath studio, there are concerns around the Excel Application Scope as it throws out validation errors. Many are complaining about this error “Excel Workbook Application is not defined”, and I have personally come across this in my automation solutions. You could easily locate this error by simply clicking on the Validate button on the top ribbon. If you have excel application scope, most probably you’ll see this error. It doesn’t …

Hope this helps.

[Natapong (Natapong Raojutitam)]

Hi @GhostBuster

Could you please try to import Microsoft.Office.Core to your project namespace

Please refer below link

"Word document is not defined" error encountered during validation

@Anna.Fortuito Welcome to UiPath forum In this case, You need to import namespace for Microsoft office. Microsoft.Office.Core [image] [image] [image] [image] [image] After you import Microsoft.Office.Core, you will able to publish package with Word Application Scope. I hope it will be help you

I hope it will be useful to you

[loginerror (Maciej Kuźmicz)]

Hi @GhostBuster

Could you confirm if the solution linked by @jogayon001 in this post worked?

"Validation Errors" while Publish

Hi. The solution for this is to create an output (variable) for the Excel Application Scope. Please read on this post by @Lahiru.Fernando for further details. Hope this helps.

[GhostBuster]

Yes, it works.
Thank @loginerror, @jogayon001, @Yoichi, @AndyMenon for your adivces,