Is it possible to enable read-only on downloaded excel from datatables?

ejselloria

I am trying to make a Download to Excel file read-only.
If not, is it possible to insert VBA code before downloading?

Thank you!

allan

I am trying to make a Download to Excel file read-only.

There isn't a built in option for that, but if you know what XML triggers it being a readonly file, you can inject that XML with the customize callback of the excelHtml5 button type.

is it possible to insert VBA code before downloading?

Same answer I'm afraid. There is no option for that in our code, but you can customize the generated XML as needed.

Option 1 I suspect will be a lot easier. If you do find it, I'd be interested to know what it is.

Allan