- Create a new workbook in Excel.
- Right click on worksheets » Insert… » International Macro Sheet
- A new sheet Macro1 is inserted
Then the following code:
var workbook = new Workbook("InternationalMacroSheet.xlsm"); var sheetType = workbook.Worksheets.Type;
Results in an incorrect sheet type: “Worksheet”. In the docs, there are two types related to macros (VB and BIFF4Macro). Maybe one of them is expected, or a new sheet type “IntlMacro”.
Download the sample file here: InternationalMacroSheet.zip (6.6 KB)