Trying to read cels from sheet and write in another sheet while transposing values

Help
1

First I get the Workbook Sheet name stored in a string variable SheetName

Then I create two variables to get the source sheet cell… SColCount and SRowCount.
I also create two variables for the destination sheet cell… DColCount and DRowCount.

I assign 1 to both those variables.

Now I need to read the cell A1 in Sheetname. How can I transform SColCount and SRowCount (both 1) to A1?
Content goes to variable CelTransfer

Now I need to write CelTransfer at cell A1 of sheet DESTINATION. Again, I will need to write to cell DColCount DRowCount, and it should be A1. How can I do that?

After writing reading and writing first cell, source cell (to be read) must go down while destination cell must go right.

So SRow = SRow+1 and DCol=DCol+1

And repeat.

What I am stuck is at using two variables that are integers to become a cell address.

I tried this formula which I found at another thread, but I got an error message
convert.ToChar(SColCount+64).ToString+SRowCount

“compiler error found while processing the formula
Option Strict On does not allow implicit conversions of string into double”??

2

Any idea why the formula is giving me an error?

3

Sorry i wasn’t able to get the question buddy, can you come again with what you would like to resolve…? hope you don’t mistake buddy @Rogerio_Penna

Cheers

4

Well, let me try to simplify the question to the maximum.

An Excel cell is composed of a letter (column) and a number (row). I will assign a variable to control letter and another to control number, so I can change the variables and get any cell I want.

So… questions:

  1. How do I deal with the LETTER part of the cel address? I use an INT32 and the number gets automatically converted to a letter when inserting the var into some Excel activity??

  2. How to tell UiPath a cell address based on two different variables (one for column and other for row?

5

For example… let’s say I need to read a specific cell in Excel. B4. But with every loop of the UI Path programming, both column and row should increase…

Read B4
Read C5
Read D6
… etc