Saving website data as an excel file with Matlab

1 次查看（过去 30 天）
Jared Johnson
Jared Johnson 2015-11-22
评论： Geoff Hayes 2015-11-24
Is it possible to save a webpage as an excel file via Matlab? Something similar to the websave function, which saves as a .html.
Using the import function in Excel gives me exactly what I need, but I really need this to be automated.

请先登录，再回答此问题。

采纳的回答

Geoff Hayes
Geoff Hayes 2015-11-22
Jared - can you provide an example url to a page that you wish to save to an Excel file? Perhaps you could use webread to get the data from the web page and then use xlswrite to write that data to an Excel spreadsheet.
  2 个评论
Jared Johnson
Jared Johnson 2015-11-22
No problem,
http://www.cfbstats.com/2015/team/8/index.html
Excel import gives me the values for each stat in its own cell and it works pretty great.
Geoff Hayes
Geoff Hayes 2015-11-24
Hi Jared - I hadn't realized that there would be that much HTML formatting on your webpage which probably makes it difficult to parse and get to the table data.
Try using Sven Koerner's submission to the File Exchange: Get HTML-table data into MATLAB via urlread and without builtin browser. With your link I coded
tableData = getTableFromWeb_mod('http://www.cfbstats.com/2015/team/8/index.html',1);
and it created a 34x3 cell array which you can then (more easily) write to an Excel spreadsheet using xlswrite.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by