Effacer les filtres
Effacer les filtres

publish excel as web page

4 vues (au cours des 30 derniers jours)
Saulius
Saulius le 5 Fév 2015
Modifié(e) : zhichuan wang le 20 Sep 2018
I want to publish excel file as web file. Beggining:
Excel = actxserver('Excel.Application');
WB = Excel.Workbooks.Open(fileResult,0,false);
If I use 'save as' function it creates single .htm file
WB.SaveAs('C:\xxx\result.htm')
I need to save as full web page so that .htm file and ALSO a folder containing files filelist.xml, sheet001.htm, sheet002.htm, ... , stylesheet.css, tabstrip.htm would be created (just like saving excel file as web page). I assume PublishObjects should be used. However this gives an error:
WB.PublishObjects.Add('xlSourceRange','C:\xxx\result.htm')
What is a correct code? I want to save all workbook with all sheets to a web page type.
In this link: explanation in vba is example how to publish excel, however it is not in a matlab syntax and I can't find a way to make this code work...
  1 commentaire
zhichuan wang
zhichuan wang le 20 Sep 2018
Modifié(e) : zhichuan wang le 20 Sep 2018
PublishObjects.Add Method (Excel) gives the method to save Excel as .html file.
WB.PublishObjects.Add('xlSourceSheet','C:\xxx\result.htm',SheetName)
For example:
Workbooks.Item(1).PublishObjects.Add('xlSourceSheet','SelfTestState.html'],'Test_1')

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by