Inserting a table in a webpage into an identically organized table in Excel
A web page I accessed has information supplied via a table. Is there a way I can have it appear in an Excel spreadsheet just as it is on the web page? Some web sites provide a direct transfer into Excel. This web page does not. It would require an inordinate amount of time to take the data an place it in individual Excel cells, as it appears in the web page.
A web page I accessed has information supplied via a table. Is there a way I can have it appear in an Excel spreadsheet just as it is on the web page? Some web sites provide a direct transfer into Excel. This web page does not. It would require an inordinate amount of time to take the data an place it in individual Excel cells, as it appears in the web page.
所有回覆 (1)
If using copy and paste, in Excel you can use Paste Special and choose the Unicode text option. Another option is to use the Dafizilla Table2Clipboard extension to copy the table.
由 TonyE 於 修改