Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Want to open tables in browser page in Excel spreadsheet

  
   Macintosh computer (Home) -> Excel RSS
Related Topics:
Use Excel spreadsheet in Entourage calendar? - Hello, can I set up my Entourage calendar to tie in with dates set up in an Excel I have applied a formula to tally my bills and would like to have this in my Entourage calendar so I can see Thanks.

Entering data into Excel spreadsheet - Using Office 2008 on IMAC 24, Leopard 10.5.2 When I input ANY number into an excel it divides by 10. 10000 become 1000 1 becomes .1 Help!

Date Stamp in MS Excel Spreadsheet - I use a form written in MS XL that has a cell with a date formula of =TODAY(). Every time I open this blank form (I have one for each customer with that customers billing on it) to enter a new order for that customer, the date is..

macintosh works 3.0 spreadsheet filet export to excel w/ n.. - how do i transfer a macintosh works 3.0 file to any version of excel that operates in any version of mac operating an excel in mac os 9.2 classic or mac os 10.4 this works file, several cells have

Unable to open files with Pivot Tables - I have been having a problem with a file with several pivot tables in it. I have a data set then make a few different pivot tables to look at the data in different ways. Then I create charts from each of the pivot tables. We are talking a data set of..
Next:  Entourage 2008 address book synch  
Author Message
bmwmcrider

External


Since: Jan 25, 2008
Posts: 5



(Msg. 1) Posted: Mon Jan 28, 2008 7:33 am
Post subject: Want to open tables in browser page in Excel spreadsheet
Archived from groups: microsoft>public>mac>office>excel (more info?)
Hello,<br>
<br>
Does anyone know of a tool that can convert HTML tables in a browser (Firefox) page to a form that can be opened into an Excel worksheet?<br>
<br>
Thanks,<br>
<br>
Mike

 >> Stay informed about: Want to open tables in browser page in Excel spreadsheet 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 2) Posted: Mon Feb 04, 2008 9:01 am
Post subject: Re: Want to open tables in browser page in Excel spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <ee8af6d.-1.RemoveThis@webcrossing.caR9absDaxw>,
bmwmcrider.RemoveThis@officeformac.com wrote:

> Hello,<br>
> <br>
> Does anyone know of a tool that can convert HTML tables in a browser
> (Firefox) page to a form that can be opened into an Excel worksheet?<br>

Not sure what you're looking for here...

If you Save Page As and choose Web Page, HTML Only, XL will open the
file directly.

You can also usually copy a table and paste it directly into an XL
worksheet.

A third alternative is to use a web query. See

http://support.microsoft.com/default.aspx?scid=kb;en-us;274787

 >> Stay informed about: Want to open tables in browser page in Excel spreadsheet 
Back to top
Login to vote
bmwmcrider

External


Since: Jan 25, 2008
Posts: 5



(Msg. 3) Posted: Mon Feb 04, 2008 10:25 am
Post subject: Re: Want to open tables in browser page in Excel spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,<br>
<br>
I've already tried the first two suggestions you offered but neither worked. The third is not an option since the table appearing in my web browser was generated locally by another app running on my Mac.<br>
<br>
Using the first suggestion when I open Excel and browse for the saved file it is greyed out and I can't select it. Using the copy and paste option I loose all the table formatting - the data is not arranged in rows and columns as it is on the browser page.<br>
<br>
Maybe I'll just write a VBA script to parse out the data from the HTML file and put in a worksheet.<br>
<br>
Thanks for your help,<br>
<br>
Mike
 >> Stay informed about: Want to open tables in browser page in Excel spreadsheet 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 4) Posted: Mon Feb 04, 2008 1:38 pm
Post subject: Re: Want to open tables in browser page in Excel spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <ee8af6d.1.RemoveThis@webcrossing.caR9absDaxw>,
bmwmcrider.RemoveThis@officeformac.com wrote:

> Using the first suggestion when I open Excel and browse for the saved file it
> is greyed out and I can't select it.

How about if you select "All files" from the Enable dropdown in the Open
dialog?
 >> Stay informed about: Want to open tables in browser page in Excel spreadsheet 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 5) Posted: Mon Feb 04, 2008 1:47 pm
Post subject: Re: Want to open tables in browser page in Excel spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <ee8af6d.1 DeleteThis @webcrossing.caR9absDaxw>,
bmwmcrider DeleteThis @officeformac.com wrote:

> Using the copy and paste option I loose all the table formatting - the data
> is not arranged in rows and columns as it is on the browser page.

Hmm... it works for me from a large number of tables that I've tried.
 >> Stay informed about: Want to open tables in browser page in Excel spreadsheet 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 6) Posted: Mon Feb 04, 2008 1:47 pm
Post subject: Re: Want to open tables in browser page in Excel spreadsheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <ee8af6d.1 RemoveThis @webcrossing.caR9absDaxw>,
bmwmcrider RemoveThis @officeformac.com wrote:

> The third is not an option since the table appearing in my web browser was
> generated locally by another app running on my Mac.

Just use the proper URI - e.g.,:

file:///Users/<your name>/Documents/html_tables.html
 >> Stay informed about: Want to open tables in browser page in Excel spreadsheet 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]