Excel - Web Query

Forums › Desktop computing › Excel - Web Query

KillerHulk

348 posts

Ultimate Geek
+1 received by user: 24

#222541 16-Aug-2017 16:09

HI,

have hard time trying to get data from my chrome webpage to excel sheet.

Just doesn't allow to use chrome, and defaults to IE (which i dont want to use)

Any solution where i can use chrome to import data to excel?

Sorry if i missed something

I Eat Dumbbells for Breakfast

348 posts

Ultimate Geek
+1 received by user: 24

#1847653 16-Aug-2017 16:26

Also the data is on our erp system.

I Eat Dumbbells for Breakfast

2523 posts

Uber Geek
+1 received by user: 953

#1847659 16-Aug-2017 16:32

Which ERP are you using and are you using Chrome as the client?

348 posts

Ultimate Geek
+1 received by user: 24

#1847664 16-Aug-2017 16:39

kryptonjohn:

Which ERP are you using and are you using Chrome as the client?

we use Netsuite & yes chrome

I Eat Dumbbells for Breakfast

348 posts

Ultimate Geek
+1 received by user: 24

#1847668 16-Aug-2017 16:43

in some cases, i would just copy and paste in excel.

But this time i have check boxes and empty boxes to enter data in and so on.

Thus every time i copy paste to excel, it pastes vertically and as i try to remove the format, it freezes and i have to force close it.

I Eat Dumbbells for Breakfast

2523 posts

Uber Geek
+1 received by user: 953

#1847673 16-Aug-2017 16:47

Bugger, I have no experience with NetSuite - kinda slack that it doesn't have an "Export to Excel/CSV" facility. JDEdwards has it.

Scraping web pages can be messy because of all the hidden stuff embedded in it.