Hello,
I'm trying to import data from a website (www.motionindustries.com)
i have a spreadsheet with all the part numbers(Ex E35B42).
The values that i need to have in the spreadsheet are description, price and MI part number.
After I searched on internet I found Selenium , but is too complicate for me to understand.
Tried to look in the source of html to find the values, but don't know how to import them.
Ex: E35B42
Price source
Description
Part number
My table looks like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]CRT#[/TD]
[TD]DESCRIPTION[/TD]
[TD]PRICE[/TD]
[TD]P#MI[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E42B35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E35B26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Another
2000 items...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I look forward to your help to complete my table like this.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[TD]CRT#[/TD]
[TD]DESCRIPTION[/TD]
[TD]PRICE[/TD]
[TD]P#MI[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E42B35[/TD]
[TD]Stock Bore Sprocket - 35 / 3/8 in, Rough Stock Bore, 42 Teeth, 3/4 in, Steel
[/TD]
[TD]121.80[/TD]
[TD]00179193[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E35B26[/TD]
[TD]Stock Bore Sprocket - 35 / 3/8 in, Rough Stock Bore, 26 Teeth, 3/4 in, Steel
[/TD]
[TD]94.68[/TD]
[TD]00179178[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Another
2000 items...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you,
J
I'm trying to import data from a website (www.motionindustries.com)
i have a spreadsheet with all the part numbers(Ex E35B42).
The values that i need to have in the spreadsheet are description, price and MI part number.
After I searched on internet I found Selenium , but is too complicate for me to understand.
Tried to look in the source of html to find the values, but don't know how to import them.
Ex: E35B42
Price source

Description

Part number

My table looks like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]CRT#[/TD]
[TD]DESCRIPTION[/TD]
[TD]PRICE[/TD]
[TD]P#MI[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E42B35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E35B26[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Another
2000 items...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I look forward to your help to complete my table like this.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[TD]CRT#[/TD]
[TD]DESCRIPTION[/TD]
[TD]PRICE[/TD]
[TD]P#MI[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E42B35[/TD]
[TD]Stock Bore Sprocket - 35 / 3/8 in, Rough Stock Bore, 42 Teeth, 3/4 in, Steel
[/TD]
[TD]121.80[/TD]
[TD]00179193[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E35B26[/TD]
[TD]Stock Bore Sprocket - 35 / 3/8 in, Rough Stock Bore, 26 Teeth, 3/4 in, Steel
[/TD]
[TD]94.68[/TD]
[TD]00179178[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Another
2000 items...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thank you,
J
Last edited: