File Exchange

image thumbnail

Get HTML Table Data into MATLAB

version 1.3.0.1 (27.6 KB) by

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

44 Downloads

Updated

View License

Editor's Note: This file was selected as MATLAB Central Pick of the Week

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

Comments and Ratings (23)

Jan

Jan (view profile)

None

None (view profile)

RAUSHAN SINGH

Great effort.....best

wilnic

wilnic (view profile)

I keep getting this:

Undefined function or variable
'showToolbar'.

Error in getTableFromWeb (line 31)
activeBrowser =
com.mathworks.mde.webbrowser.WebBrowser.createBrowser(showToolbar,
showAddressBox);

I'm not sure how to solve this.
Thank you.

Germán Lopez

Error using imread (line 349)
File "mlPage.jpg" does not exist.

Error in getTableDataScript (line 15)
im = imread('mlPage.jpg');

Kevin

Kevin (view profile)

Raul

Raul (view profile)

Thanks! It works perfect.

Song

Song (view profile)

the script doesn't work. There is no file

mlPage.jpg

Andrea

Andrea (view profile)

hi

this is a very usefull work! and it works great.
i have just some little problem about the type of information lead into cells:

for finance analisy's porpouse i need to have numbers into cells instead of 'char'. any ideas about how to change it?

thanks so much. anyway, great work!

Ivan

Ivan (view profile)

Dear colegues. Great work but not working for

http://www.hupx.hu/market/electricity/auction.html

Any help??
Please?

Regards, Ivan

Michael

not working for me. What is required version?

Richard Crozier

Great, thanks!

Jesse Blocher

Grace

Grace (view profile)

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

Sven Koerner

Sven Koerner (view profile)

Great Tool!

Savas

Savas (view profile)

Thanks!

Yuri K

Yuri K (view profile)

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

Yuri K

Yuri K (view profile)

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 K

Yuri K (view profile)

Even better which(mfilename)

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

Anders Brun

Anders Brun (view profile)

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.

Kalev

Kalev (view profile)

Kalev

Kalev (view profile)

Updates

1.3.0.1

Updated license

1.3

Added copyright tags

1.2

Changed resolution of icon location.

MATLAB Release
MATLAB 7.7 (R2008b)

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video