How to save an Excel sheet as PDF through MATLAB?

Question

Ziggy Zigg 2012-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/52668-how-to-save-an-excel-sheet-as-pdf-through-matlab

回答： Intissar El Bouanani 2023-8-10

I am using the following code:

hExcel = actxserver('Excel.Application');
hWorkbook = hExcel.Workbooks.Open(sprintf('%s','C:\test.xlsx'));
hWorksheet = hWorkbook.Sheets.Item(1);
hRange = hWorksheet.Range('A1:O10');
hRange.ExportAsFixedFormat('xlTypePDF','test_out.pdf');

The Excel ActiveX server allows me to do the usual stuff, but the last line doesn't do anything. Neither does it throw any error.

Does anyone know how to do this?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Praveen 2016-12-28

hRange.ExportAsFixedFormat('xlTypePDF','test_out.pdf'); In this code give the path name, it works.. For example 'C:\test_out.pdf' instead of test

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cel Kulasekaran 2015-1-13

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/52668-how-to-save-an-excel-sheet-as-pdf-through-matlab#answer_164789

编辑：Cel Kulasekaran 2015-1-13

在 MATLAB Online 中打开

First, set the print area within the workbook itself, then you'll need to call ExportAsFixedFormat on the worksheet or workbook object. You cannot call it on the range object. Hope this helps, see below:

hExcel = actxserver('Excel.Application');
hWorkbook = hExcel.Workbooks.Open(sprintf('%s','C:\test.xlsx'));
hWorksheet = hWorkbook.Sheets.Item(1);
% print this sheet to PDF
hWorksheet.ExportAsFixedFormat('xlTypePDF','C:\test_out.pdf');

5 个评论
显示 3更早的评论隐藏 3更早的评论

Garrett Cassidy 2021-1-27

Is there a way to make it save 'Entire workbook'? When I manualy save as PDF I can click 'Options' then save 'Entire workbook' this saves each sheet as a page in the PDF.

Garrett Cassidy 2021-1-27

在 MATLAB Online 中打开

Answer my own question:

hExcel = actxserver('Excel.Application');
hWorkbook = hExcel.Workbooks.Open(sprintf('%s','C:\test'));
% Pring the workbook
hWorkbook.ExportAsFixedFormat('xlTypePDF','C:\test_out.pdf');