Web query

dim4x4 · May 9th, 2002, 11:32 PM

Hi,

I was just wondering whether it is possible to retrieve into Excel only one particular cell from HTML table (instead of the whole talble).

I'm using Excel 2002 (XP) and it seems only to be able to retrieve whole tables or paragraphs, but not single cells within tables.

Is there a workaround to get a number from on cell in HTML table into one Excel cell?

Thanks!

Tom Schreiner · May 10th, 2002, 12:53 AM

Hi
There may be a prettier way to do this.
My workaround has been to simply link to the cell affected by the data you are interested in seeing.
Import as little of the page as you can on one sheet, and link your selected cell to another sheet.
Tom

dim4x4 · May 10th, 2002, 08:33 AM

Thanks TsTom! I guess that's the only way.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 11:32 PM	#1
dim4x4 Board Regular Join Date: May 2002 Posts: 72	Hi, I was just wondering whether it is possible to retrieve into Excel only one particular cell from HTML table (instead of the whole talble). I'm using Excel 2002 (XP) and it seems only to be able to retrieve whole tables or paragraphs, but not single cells within tables. Is there a workaround to get a number from on cell in HTML table into one Excel cell? Thanks!

May 10th, 2002, 12:53 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi There may be a prettier way to do this. My workaround has been to simply link to the cell affected by the data you are interested in seeing. Import as little of the page as you can on one sheet, and link your selected cell to another sheet. Tom

May 10th, 2002, 08:33 AM	#3
dim4x4 Board Regular Join Date: May 2002 Posts: 72	Thanks TsTom! I guess that's the only way.