Axolot Data

Hi.

Does XLSReadWrite support .xlsm files?

Best regards
d3nton

Hello

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

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.

Hello

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

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.

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

Hello

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