enable macros using spire.xls

[aksh0614]

hello,
I have a macro-enable file which runs macros when we open a worksheet.
I was trying to download this .xlsm i.e macro-enabled worksheet using spire.xls but it was giving security warning.
1. Can we enable this setting using spire.xls?
2. Can we save this macro-enabled file into PDF format using spire.xls?

[Betsy.jiang]

Hi,

Thanks for your inquiry.
1. I loaded and saved a .xlsm file, when opening there is no security warning. Please provide your input file and the code you were using for further investigation.
2. As per my understanding, you want to convert the file which has run the Macro to PDF. If so, sorry that our Spire.XLS doesn't support running Macro. If I misunderstand, please provide detailed information along with the input Excel and the excepted PDF.

Sincerely,
Betsy
E-iceblue support team

[aksh0614]

Below is the code we are using to load a file from the stream and download that file using return file

Code: Select all


MemoryStream memory = new MemoryStream();
//Stream stream = "This stream contains .xlsm file";
 Workbook book = new Workbook();
book.LoadFromStream(stream);
Worksheet sheet = book.Worksheets[1];
sheet.InsertDataTable(dataTable, true, 1, 1);
book.SaveToStream(memory);
return File(memory , "application/vnd.ms-excel.sheet.macroEnabled.12", "Filename.xlsm");



[Betsy.jiang]

Hi,

Thanks for your information.
I have noticed the issue. After further investigation, I am afraid our product cannot control that settings, since it is controlled by the MS Excel tool. If you set following settings, when opening there will be no security warning. Hope you could understand.

Sincerely,
Betsy
E-iceblue support team