Dokumentacija HotXLS Vsebina Domov Pregled TGridToXLS IXLSWorkbook Domov Vsebina Pregled

vmesnik IXLSWorkbook

Enota: lxHandle
Predstavlja a Microsoft Excel Workbook

Lastnosti

Colorslastnost Nameslastnost Worksheetslastnost Sheetslastnost ActiveSheetlastnost ActiveSheetIndexlastnost FirstSheetlastnost TabRatiolastnost ShowSheetTabslastnost ShowHorizontalScrolllastnost ShowVerticalScrolllastnost AutoFilterDateGroupinglastnost Minimizedlastnost WindowHiddenlastnost Window geometry properties Calculation properties Document properties LastSavedBylastnost UserNamelastnost Date1904lastnost ReferenceStylelastnost IsProtectedlastnost VBAProjectlastnost OnUserFunction / OnUserFunctionEx callback

Metode

Closemetoda Calculatemetoda Openmetoda OpenCSVmetoda GetSheetNamesmetoda ResetColorsmetoda Protectmetoda UnProtectmetoda VBADefinedmetoda HasVBAProjectmetoda LoadVBAProjectFromFilemetoda SaveVBAProjectToFilemetoda ClearVBAProjectmetoda SetCodePagemetoda Savemetoda SaveAsmetoda SaveAsCSVmetoda SaveAsHTMLmetoda SaveAsRTFmetoda

Primer

This example creates new Workbook and saves it into C:\book.xls and C:\book.html files var Workbook: IXLSWorkbook; begin Workbook := TXLSWorkbook.Create; Workbook.Sheets.Add; Workbook.Sheets[1].Name := 'Sheet1'; {...} Workbook.SaveAs('C:\book.xls'); Workbook.SaveAsCSV('C:\book.csv'); Workbook.SaveAsHTML('C:\book.html'); Workbook.SaveAsRTF('C:\book.rtf'); end; Copyright © 2010-2026 losLab Software