How to import an excel file from the web?
14 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I would like to import an excel spreadsheet which is on the intranet. I can click the file to download it when I am on that page. Now I am able to read the source code of that page using 'urlread', but not sure how to open the actual file.
Any clue?
Thanks,
Feng
0 comentarios
Respuesta aceptada
Walter Roberson
el 11 de En. de 2013
xlsread()
2 comentarios
Walter Roberson
el 12 de En. de 2013
urlread() of the download page will allow you to find the URL of the file itself; it will probably be in the form of a file: URL or possibly an http: or https: URL. Once you have extracted that URL, urlread() or urlwrite() the file itself.
Más respuestas (1)
Jan
el 12 de En. de 2013
Editada: Jan
el 12 de En. de 2013
You can use URLREAD to read the Excel file, store it locally and use XLSREAD then.
Walter 's idea is better: urlwrite performs the storing to disk implicitly.
1 comentario
Walter Roberson
el 12 de En. de 2013
urlwrite() might make more sense than urlread() in this circumstance.
Ver también
Categorías
Más información sobre Standard File Formats en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!