Saving website data as an excel file with Matlab

2015 11 22
1 个回答
回答已采纳
更新时间：2015 11 24
35 次查看（30 天）

0 个投票

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

0 个投票

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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by