XLSM support

[d3nton]

Hi.

Does XLSReadWrite support .xlsm files?

Best regards
d3nton

[larsa]

Hello

Yes, XLSM is the same as XLSX but XLSM files are macro enabled.

[d3nton]

Thank you.

How do I create a xlsm file?
The following example results in an invalid xlsm file.

var
ExcelFile5 : TXLSReadWriteII5;
begin
ExcelFile5 := TXLSReadWriteII5.Create(nil);
ExcelFile5.Filename := 'C:\output.xlsm';
ExcelFile5[0].AsString[0,0] := 'test';
ExcelFile5.Write;

best regards.

[larsa]

Hello

You can't create XLSM files but you can read them.

[d3nton]

Okay. Thanks for the prompt reply.

Are there any plans to integrate xlsm-write support?
Or maybe at least writing 'normal' data (e.g. without any new makros) into existing xlsm files?

best regards.

[d3nton]

Hi!
Any news on this?
Basic xlsm support as mentioned above would be nice.

[larsa]

Hello

An XLSM files contains macros and tehre are no plans for supporting macros right now.