Find if the Worksheet is Dialog Sheet

Possible Usage Scenarios

Dialog Sheet is an old format of the sheet that contains a dialog box. Such a sheet could be inserted by an older version of Microsoft Excel e.g. 2003 as shown in this screenshot. It can also be inserted with VBA in newer versions e.g. Microsoft Excel 2016.

Find if the Worksheet is Dialog Sheet

Aspose.Cells for Python via Java provides you with the ability to check if the worksheet is a dialog sheet. For this, it provides the Worksheet.Type property. If Worksheet.Type returns enumeration value SheetType.DIALOG, then it means, you are dealing with a dialog sheet.

The following code snippet shows how to check for a dialog sheet. The console output generated by the code is given below for reference.

Console Output

Worksheet is a Dialog Sheet.