How to get Excel auto sum from UiPath

Help
,
1

The question is: how to perform auto-sum of certain cells in an Excel workbook from UiPath and get the type of auto-sum value back into the UiPath variable (double, for example, or numeric, number, “0” …).
It is necessary without visualization and preferably without macros.
I use excellent packages from BalaReva, but I did not find a similar opportunity.

2

Can you send a sample excel file and output how you want??

3

I am a new user. I can’t upload files.
Task: through algorithms and UiPath tools, get the automatic sum of cells (for example, B2: B11) from an Excel workbook.

4

Or like this: to simulate an Excel action, the automatic sum and transfer the received value to UiPath in the original received data type (for example, numeric)

5

Purpose: Check that the auto-sum in Excel recognizes the cells as a number format.

6

Check this workflow, @Russia_N_Novgorod
Test_3.xaml (6.0 KB)
This workflow may give an idea to you.

7

Thanks for trying, but that is not it.

8

This may help couple of our readers of the post: Learn How to Apply Formulas in Excel Automation

1 Like
9

Thank. Good videos.
The main thing is that there is an automatic translation of subtitles into Russian!

1 Like
10

Could you help in this matter?