Filter löschen
Filter löschen

publish excel as web page

4 Ansichten (letzte 30 Tage)
Saulius
Saulius am 5 Feb. 2015
Bearbeitet: zhichuan wang am 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 Kommentar
zhichuan wang
zhichuan wang am 20 Sep. 2018
Bearbeitet: zhichuan wang am 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')

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by