Read Excel Range of Decimals; Write Each To Specific Cells

Help Studio
, ,
1

Hello,

I have an MS Excel spreadsheet that has a series of decimal values in range “B15:B27”:

4.125
4.000
3.875
…and so on

I have a Read Range activity that outputs to DataTable “tblRate”

I have a do while loop setup to increment “counter” by 1 as it runs through it, starting at 0.

I am trying to write each element of the tblRate datable to a specific cell in another worksheet.

To write the specific element from the table to a cell, what should the syntax be?

I have a Write Cell activity where i have the file name, the tab name, the specific cell with the following input:

tblRate.ToString(counter)

Ideally, this would write 4.125 into a specific cell I’ve defined.

I know this isn’t correct, but I am not sure how to course correct here.

Any guidance or examples would be greatly appreciated.

Thanks.

Brett

1 Like
2

Hey @Brett_Johnson

If counter starts from 0

tblrate.Rows(counter)(colName or colIndex).ToString

Thanks
#nK