Cant manage to pass extracted price with Get text activity to Excel

[Favarelaa (Francisco Augusto Varela Aguirre)]

I have a list with lots of URLS on an excel and I made a robot that navigates in to each URL and extracts the price.

I cant use the wizard so I used Get Text, but afterwords I cant type the extracted info back to to the excel.
Can I get any sugestions on how to do it or how to correct this?

[mkankatala (Mahesh Kankatala)]

Hi @Favarelaa

In where to write field in the write cell activity give like this CurrentRow.Byfield(“Column name”)

In the place of column name give the required column name present in the Excel.

Make sure to check the auto increment row option.

Hope it helps!!

[Yoichi]

HI,

It’s because you set range instead of cell address.
So can you try either of the following?

Where to write

Excel.Sheet("IINKS").Cell("F"+(CurrentIndex+1).ToString)

OR

Where to write

Excel.Sheet("IINKS").Cell("F1")

Turn ON AutoIncrement row property

Regards,

[Favarelaa (Francisco Augusto Varela Aguirre)]

@Yoichi

Excel.Sheet("IINKS").Cell("F1")

Both work great! Thank you!
My excel has the thousand separator in dots and the decimal separator in comas.
Do you know how I can make the Write Cell activity put the price in that format?

[Yoichi]

Hi,

In general, we can use FormatCells activity if your input string is numeric and your excel locale is same style what you want to input.

If your locale is not same, it may be necessary to convert string to what you want and input it as text to excel.

Regards,