topic Re: Creating Pivot tabele using Excel VBo in Product Forum

Creating Pivot tabele using Excel VBo

igor_rosancic — Fri, 17 May 2024 12:57:16 GMT

Hi,

I'm trying to create pivot table in excel but all the time I finish with error.

This is simple action. Also i can use all other action in excel VBO with this file without error. Adding new sheet also working but I obviously doing something wrong with this action.

If you have any ideas of what's wrong, I'd appreciate it.

Re: Creating Pivot tabele using Excel VBo

harish.mogulluri — Fri, 17 May 2024 13:21:50 GMT

Hello,
Are you using the latest MS excel VBO
I would suggest get latest VBO from digital exchange

1) Try to create pivot table manually with the same excel file and see whether you are encountering the similar issue
2) close all the excel instances and try to run the same stage again and see whether you are encountered the same issue

Exception in the screenshot is generic one you can see below threads some of the reason for this exception.

https://stackoverflow.com/questions/891394/excel-error-hresult-0x800a03ec-while-trying-to-get-range-with-cells-name

https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?ui=en-us&rs=en-us&ad=us

https://support.blueprism.com/en/support/solutions/articles/7000078247-bpe-error-why-do-i-get-result-0x800a03ec-when-using-a-write-stage-within-excel-vbo

https://uk.mathworks.com/matlabcentral/answers/101631-why-do-i-receive-an-error-error-code-0x800a03ec-when-using-xlswrite-in-matlab

Re: Creating Pivot tabele using Excel VBo

igor_rosancic — Fri, 17 May 2024 13:33:15 GMT

Thanks. Manually I can create Pivot.

Also I copy just part of data into new excel (on picture above) and try with it. But all the time I got same error. So quantity of data isn't problem.

My main concern was that i doing something wrong with input parameters.

Also, on digital exchange for this action in manual there isn't any explanation how to use action.

In any case, maybe I missed some example which can be download so that I can import it on my dev environment and test how it will work. That would be helpful.

In any case thank for answer.

Re: Creating Pivot tabele using Excel VBo

Mohamad_Dakkouri — Sat, 18 May 2024 20:35:18 GMT

Hi @igor_rosancic

Is it possible to use a Macro or your only need to do it with Blue Prism ?

If the Vba is possible i can help you ti create the code then you just need to run it via the action run macro in Blue Prism