Import html
I Use importhtml on Google spreadsheet can I use it with numbers, since Google make very much problems using it sloe loading and more
I Use importhtml on Google spreadsheet can I use it with numbers, since Google make very much problems using it sloe loading and more
The hosting software would not let me update my post after I removed the junk above, and provided the following content within my 15 minute grace period.
Numbers v3.6.1 has no import menu item, so importing HTML is not going to work as you experience it with Google.
If you have a pure, unstyled, HTML table on a web page, when you select it, you will see discrete rows and columns.
When you Copy/Paste and Match Style this table into the first cell of a Numbers spreadsheet, it will automatically expand to fill the rows and columns from the HTML table. Other HTML/CSS3 styled tables, and especially pure CSS3/div tables will land in Numbers as a mess.
If you have a pure HTML table on a web page, when you select it, you will see discrete rows and columns. When you copy/paste this into the first cell of a Numbers spreadsheet, it will automatically expand to fill the rows and columns from the HTML table. On the otherhand, if someone has styled an HTML table with CSS3, or created a table exclusively in CSS3 using divs, then the copy/paste results into Numbers will be ugly.
Copy/paste this pure HTML table into Numbers v3.6.1.
| Year | Interest | Tax | Net | Monthly | Balance |
|---|
1 20,370,771 8,015,898 12,354,872 1,029,572 512,354,872 2 20,874,128 8,213,969 12,660,158 1,055,013 525,015,031 3 21,389,922 8,416,934 12,972,987 1,081,082 537,988,019 4 21,918,461 8,624,914 13,293,547 1,107,795 551,281,566
Thank you VikingOSX
this can not sub the IMPORTHTML formula
I need to use IMPORTHTML and keep constant updating for new quotes (I use it for stocks etc...)
If you have any idea to help please let me know its will help me a lot,
Import html