"Validation Errors" while Publish

Off-Topic Discussions
1

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:

snap904

Thanks in advance! :pray::pray:

2

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

3

Hi, @Yoichi,

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

snap906

4

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

5

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

snap907

6

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

7

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?

8

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.

1 Like
9

Hi @GhostBuster

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

Please refer below link

I hope it will be useful to you

10

Hi @GhostBuster

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

11

Yes, it works.
Thank @loginerror, @jogayon001, @Yoichi, @AndyMenon for your adivces,
:+1::+1::pray::pray: