Data scraping to Excel and add formulas

Help
,
1

Hello,

Who can help me?

I used the data scraping tool to get all the information that i need (device name and listed price including VAT. then I wrote it down to Excel with Write range so far so good.

But when I want to add some forumlas to the sheet, Excel cannot read the pricetag someting with the format:

image
image1086×74 2.8 KB

How to change the format of the column “Price incl VAT” so my formulas are working again.

My workflow:

image
image493×1579 120 KB

2

Hi @AdminTT

Welcome UiPath community…

To which format you would like to change it buddy…for the column price incl vat

Cheers

3

Hi @Palaniyappan

Thank you for the quick response!

I would like to change it into Valuta or numbers, some format that Excel can use to execute math formulas, such as calculate “Price incl VAT to Price excl VAT”

Greetings

4

Can i have a view of that column alone as a screenshot to make sure that next to 649 is always ,- in 659,-
or will have value instead of -
Do you need that value for your consideration buddy

This can sorted out
Cheers…

5

Here is a view of the column:
,- this part is not mainly needed but came with the data scraping.

image
image454×689 8.04 KB

6

@AdminTT
Buddy, thank you

So its always - only next to the number and comma…Great

  1. now use a for each loop to iterate through the datatable

  2. inside which use a assign activity like
    row(“Price incl VAT”) = Convert.ToDouble(row(“Price incl VAT”).ToString.Replace(“,-”," ").Trim)

  3. Now all the value in that column will get converted to double datatype of value

  4. now you export the datatable with this new column to a excel and apply your formula

Hope this would help you buddy
Kindly revert if any tweak needed on to resolve this

Cheer…!

7

Is that working buddy

Cheers

8

Not yet, trying to find out the following error, maybe I do someting wrong :slight_smile:

After implement:

I get the following error:
Implicit conversions from String to integer are not allowed by the option strict on

9

Buddy

try with row.item(“Price incl VAT”) buddy instead of row(“Price incl VAT”) in left side and in right side as well
Convert.ToDouble(row.item(“Price incl VAT”).ToString.Replace(“,-”," ").Trim)

The reason why we get this error is the column Price incl VAT is of type string while we are trying to assign a double value… that why showing error " mplicit conversions from String to integer are not allowed by the option strict on"

Cheers

10

Thank you for your help so far,

Here I am with the next one, could not find .item within the editor, when I try this I get the following error “item is not a member of System.Data.DataTable”

image
image1968×687 27.2 KB

Greetings

11

row.Item(columnindex) buddy, may i at which activity you are assigning this

Cheers

12

row.item(columnindex) not found.

I uploaded my workflow.xaml maybe when you see my workflow you see what I’m doing wrong

Main.xaml (17.3 KB)

1 Like
13

@AdminTT
Here is your xaml buddy hope got resolved

Main.xaml (20.6 KB)

Cheers

2 Likes
14

Thank you for you help, I see now what I did wrong.

Greetings.

1 Like
15

Cheers buddy keep going

16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.