Skip to content

Add support for reading XLM (Macro Sheet) files#724

Merged
appel1 merged 1 commit into
ExcelDataReader:developfrom
hughbe:xlm-support
Nov 3, 2025
Merged

Add support for reading XLM (Macro Sheet) files#724
appel1 merged 1 commit into
ExcelDataReader:developfrom
hughbe:xlm-support

Conversation

@hughbe

@hughbe hughbe commented Nov 1, 2025

Copy link
Copy Markdown
Contributor

These are described by a BIFFTYPE of 0x0040. We can take the same approach as for Worksheets. Both have a globals stream - see https://learn.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/0dddd943-f77a-4fc2-bf92-868acb4587f7

I was able to fire up Excel 2.0 on a VM and create an example file.
Screenshot 2025-11-01 at 21 00 54

I can't add the file directly as GitHub doesn't allow XLM attachments, but they are in a zip file attached.
Files.zip

@hughbe

hughbe commented Nov 1, 2025

Copy link
Copy Markdown
Contributor Author

I should say I've added a bunch more missing BIFF codes from the MS-XLS Spec and from Open Office spec. I'm pretty sure that BIFF2 column/row widths/heights aren't being read either.

@appel1 appel1 merged commit 5767412 into ExcelDataReader:develop Nov 3, 2025
1 check passed
@hughbe hughbe deleted the xlm-support branch November 3, 2025 12:46
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants