Get HTML Table Data into MATLAB

Identify tables and interactively select the data to bring into MATLAB.

Description

Through the MATLAB Web Browser tables are identified and are interactively selected and the data is imported into MATLAB as a cell array.

• Acknowledgements: This submission has inspired the following:; Get HTML-table data into MATLAB via urlread and without builtin browser
• MATLAB release: MATLAB 7.7 (R2008b)

[Kalev]

 

[Kalev]

 

[Anders Brun]

Nice thing. Too bad the Matlab web browser doesn´t have the same functionality as other browsers though... I could not even load the page that I am most interested in importing. Then again, I could ofcourse save this page as HTML using Firefox, Safari or Explorer and then use your tool to import it into Matlab, which is nice since I don´t have to open up Excel.

[Michael Solis Chacon]

Don't work for me, any suggestion

>> getTableDataScript
??? Attempt to reference field of non-structure array.

Error in ==> getTableFromWeb>updateHTML at 47
pageString = reshape(url.toCharArray, 1, []);

Error in ==> getTableFromWeb at 36
newUrlText = updateHTML(urlText);

Error in ==> getTableDataScript at 14
getTableFromWeb

[Yuri Kotliarov]

Even better which(mfilename)

[Yuri Kotliarov]

Sorry, somehow I didn't send the full comment. This is great tool and I looked for such functionality in MATLAB. One issue is that it searching for the icon in current directory. It better to store it together with the function. Use fileparts(which(mfilename)) instead of pwd.

[Yuri Kotliarov]

Unfortunately does not take properly table with rowspan (probably colspan as well, I didn't test).

[Savas]

Thanks!

[Sven Körner]

Great Tool!

[Grace]

Great tool! I've been using it to download daily stock option price for a class assignment. So cool to have this automatically down

[Jesse Blocher]