XlsWorkbook module

class XlsWorkbook.XlsWorkbook

Bases: XlsObject, IWorkbook

Activate()
property ActiveSheet: IWorksheet
property ActiveSheetIndex: int
AddFont(fontToAdd: IFont) → IFont
property AddInFunctions: IAddInFunctions
property Allow3DRangesInDataValidation: bool
property ArgumentsSeparator: str
property Author: str
property BuiltInDocumentProperties: IBuiltInDocumentProperties
property Charts: ICharts
Clone() → IWorkbook
Close
<summary>

Closes the object and saves changes into specified file.

</summary> <param name=”Filename”>

File name in which workbook will be saved if SaveChanges is true.

</param>

property CodeName: str
ContainsFont(font: XlsFont) → bool
CopyToClipboard()
CreateFont
CreateTemplateMarkersProcessor() → IMarkersDesigner
property CurrentHeaderId: int
property CurrentObjectId: int
property CurrentShapeId: int
property CustomDocumentProperties: ICustomDocumentProperties
static DEF_BAD_SHEET_NAME() → str
static DEF_COMENT_PARSE_COLOR() → Color
static DEF_FIRST_USER_COLOR() → int
property DataConns: DataConnections
property Date1904: bool
DecodeName(name: str) → str
property DefaultXFIndex: int
property DetectDateTimeInValue: bool
property DisableMacrosStart: bool
property DisplayWorkbookTabs: bool
property DisplayedTab: int
Dispose()
EncodeName(strName: str) → str
FileWidthToPixels(fileWidth: float) → float
FindOne
property FirstCharSize: int
property FullFileName: str
GetBookIndex(referenceIndex: int) → int
GetMaxDigitWidth() → float
GetNearestColor
GetPaletteColor(color: ExcelColors) → Color
property HasDuplicatedNames: bool
property HasMacros: bool
property InnerAddInFunctions: XlsAddInFunctionsCollection
property InnerFonts: XlsFontsCollection
property IsCellProtection: bool
property IsDisplayPrecision: bool
IsExternalReference(reference: int) → bool
IsFormatted(xfIndex: int) → bool
property IsHScrollBarVisible: bool
property IsLoaded: bool
property IsRightToLeft: bool
property IsVScrollBarVisible: bool
property IsWindowProtection: bool
property Loading: bool
property MaxColumnCount: int
property MaxDigitWidth: float
property MaxIndent: int
property MaxRowCount: int
property MaxXFCount: int
property Names: INameRanges
property ObjectCount: int
property OleSize: IXLSRange
property Palette: List[Color]
property PasswordToOpen: str
PixelsToWidth(pixels: float) → float
Protect
property ReadOnly: bool
property ReadOnlyRecommended: bool
Replace
ResetPalette()
property RowSeparator: str
Save()
SaveAs
SaveAsEmfStream(sheetIndex: int, EmfStream: Stream, firstRow: int, firstColumn: int, lastRow: int, lastColumn: int)
SaveAsHtml(fileName: str, saveOption: HTMLOptions)
SaveAsImageOrXps
SaveAsImages
SaveChartAsEmfImage(worksheet: Worksheet, chartIndex: int, imageOrPrintOptions: ConverterSetting, emfStream: Stream) → Stream
SaveChartAsImage
SaveToPdf
SaveToXlsm
property Saved: bool
property Saving: bool
property SecondCharSize: int
SetActiveWorksheet(sheet: XlsWorksheetBase)
SetChanged()
SetColorOrGetNearest
SetMaxDigitWidth(w: int)
SetPaletteColor(index: int, color: Color)
SetSeparators(argumentsSeparator: int, arrayRowsSeparator: int)
SetWriteProtectionPassword(password: str)
property StandardFont: str
property StandardFontSize: float
property StandardRowHeight: float
property StandardRowHeightInPixels: int
property Styles: IStyles
property TabSheets: ITabSheets
property ThrowOnUnknownNames: bool
Unprotect
property Version: ExcelVersion
WidthToFileWidth(width: float) → float
property Worksheets: IWorksheets