HotXLS utvecklarreferens

Versionsinformation

Hjälp för HotXLS-komponenten

Hjälp för HotXLS-komponenten Use this reference to find classic XLS automation Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection the expCreate, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspectioned XLSX facade, including workbook, worksheet, range, formatting, image, page setup, hyperlink, name, chart, table, validation, filter, view-stateAddChartSheet metod export APIs Öppna innehåll
Utforska XLSX-stöd

Börja med översikten

Börja med översikten

Srpski (latinica)

Srpski (latinica)

Deutsch

Français

Italiano lxHCreate, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspectionleX Italiano

Norsk

NederlCreate, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspections

utökat XLSX stöd .ods utökat XLSX stöd Open or OpenODSStart with the dedicated lxHCreate, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspectionleX facade for Excel 2007+ workbooks, worksheet collections, styles, shared strings, defined namesAddChartSheet metod OOXML save/open workflows SaveAsODSÖversikt XLSX-fasad TODSExportOptionsmodern kalkylblad funktioner

Use XLSX ranges, formulas, whole-range or merge-across merged cells, loaded-cell scan/write helpers, text find/replace, hyperlinks, comments, images, tables, charts, conditional formatting, data validation, frozen panesAddChartSheet metod auto-filter criteria

utökat XLSX stöd .ods utökat XLSX stöd Open or OpenODS , save ODS output with SaveAsODS , tune exports with TODSExportOptions AddChartSheet metod round-trip styles, images, charts, validations, conditional formats, print setupAddChartSheet metod sheet structure

Use XLSX ranges, formulas, whole-range or merge-across merged cells, loaded-cell scan/write helpers, text find/replace, hyperlinks, comments, images, tables, charts, conditional formatting, data validation, frozen panesAddChartSheet metod auto-filter criteria Sheets.AddChartSheet TXLSXWorksheet klass

Add Data Bar, Color ScaleAddChartSheet metod Icon Set rules on both BIFF8 Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection XLSX with shared spec classes, DXF Style overrides for font/fill/weight, theme color round-trip, formula-based threshold round-trip, per-stop icon overrides, icon threshold include/exclude controlAddChartSheet metod cfRule priority pinning

Add Data Bar, Color ScaleAddChartSheet metod Icon Set rules on both BIFF8 Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection XLSX with shared spec classes, DXF Style overrides for font/fill/weight, theme color round-trip, formula-based threshold round-trip, per-stop icon overrides, icon threshold include/exclude controlAddChartSheet metod cfRule priority pinning

TCondFormat referens AddTableBIFF8 Chart blad EncryptionPassword Use XLSX ranges, formulas, whole-range or merge-across merged cells, loaded-cell scan/write helpers, text find/replace, hyperlinks, comments, images, tables, charts, conditional formatting, data validation, frozen panesAddChartSheet metod auto-filter criteria Sheets.AddChartSheet — column, bar, lineAddChartSheet metod pie chart kinds, with title, axis titlesAddChartSheet metod series bound to A1-range references FILESHARING, FILESHARING2, PROT4REVAddChartSheet metod PROT4REVPASSAddChartSheet metod HIDEOBJBIFF8 tabeller och Encryption TEMPLATE, TABIDAddChartSheet metod BOOKEXT arbetsboksmetadata bevarCreate, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspectioneUSERSVIEWBEGIN / USERSVIEWENDBIFF8 tema färger och XFExt

Address cell fill, fontAddChartSheet metod per-edge border colors through the 12 Office theme slots with optional tint via SetThemeColor , or write exact RGB through the XFExt $087D rich-color side record so Excel 2007+ reopens with the literal color while Excel 97-2003 still sees the indexed palette approximation. Drawings (shapes, chart fills) follow through the XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor helper pair with same-process round-tripAddChartSheet metod expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions

Address cell fill, fontAddChartSheet metod per-edge border colors through the 12 Office theme slots with optional tint via SetThemeColor , or write exact RGB through the XFExt $087D rich-color side record so Excel 2007+ reopens with the literal color while Excel 97-2003 still sees the indexed palette approximation. Drawings (shapes, chart fills) follow through the XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor helper pair with same-process round-tripAddChartSheet metod expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions

Interior.SetThemeColor metod SetThemeColorSST Rich text och Phonetic Runs XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor SST Rich text och Phonetic Runs SheetExt Shared-string per-character font / color runs Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection Far-East phonetic annotations (furigana) survive load Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection save: the parser preserves rgRun Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection rgExtRst trailing blocks per unique stringAddChartSheet metod the writer re-emits them when the record fits one BIFF chunk TXLSWorksheet.TabColor Översikt XLSX-fasad HFPicture klassisk XLS pivottabeller HeaderFooter Create, open, style, automateAddChartSheet metod export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface TXLSShape.OfficeArtOptions

TabColor egenskap

SST Rich text och Phonetic Runs

SST Rich text och Phonetic Runs SheetExt Shared-string per-character font / color runs Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection Far-East phonetic annotations (furigana) survive load Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection save: the parser preserves rgRun Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection rgExtRst trailing blocks per unique stringAddChartSheet metod the writer re-emits them when the record fits one BIFF chunk TXLSWorksheet.TabColorÖversikt XLSX-fasad HFPicture klassisk XLS pivottabeller HeaderFooter Create, open, style, automateAddChartSheet metod export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface

Create, open, style, automateAddChartSheet metod export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface

Översikt XLSX-fasad

arbetsbok API rgRun Create, open, save, protect, calculate, and export Excel workbooks through the main workbook interface, including saved-by metadata, file-sharing metadata preservation, and pivot cache inspection rgExtRst TGridToXLS gränssnitt

klassisk XLS pivottabeller

klassisk XLS pivottabeller

Create typed classic XLS pivot tables, inspect Excel-authored pivot workbooks, preserve raw pivot recordsAddChartSheet metod configure field axes, subtotals, page filtersAddChartSheet metod data-field number formats .xlsx klassisk XLS pivottabell API

Norsk

område Editing FILESHARING , FILESHARING2 , PROT4REV , PROT4REVPASS , HIDEOBJ , zero-length TEMPLATE , TABID , BOOKEXT , USERSVIEWBEGIN , USERSVIEWEND AddChartSheet metod saved-by metadata when classic XLS workbooks pass through HotXLS

område Editing FILESHARING , FILESHARING2 , PROT4REV , PROT4REVPASS , HIDEOBJ BIFF8 tabeller och Encryption TEMPLATE , TABID , BOOKEXT , USERSVIEWBEGIN , USERSVIEWEND IXLSRange gränssnitt

klassisk XLS arbetsboksmetadata

kalkylblad API

klassisk XLS färg modell TXLSShapes.DeleteInRange klassisk XLS färg modell TXLSWorksheet.ForEachCell TcxGridAddExcel komponent TXLSWorksheet.WriteCells Export DBGrid content to Excel with header, detail, grouping, formattingAddChartSheet metod event hooks TXLSWorksheet.ApplyAutoFilter Översikt komponent AutoFilterColumns

TXLSWorksheet referens

område Editing

område Editing FILESHARING, FILESHARING2, PROT4REV, PROT4REVPASS, HIDEOBJBIFF8 tabeller och Encryption TEMPLATE, TABID, BOOKEXT, USERSVIEWBEGIN, USERSVIEWENDIXLSRange gränssnitt

XLS färg modell

Review ThemeColor, TintAndShade, och klassisk XLS palette-baserad formatting decision

klassisk XLS färg modell TXLSShapes.DeleteInRangeklassisk XLS färg modell TXLSWorksheet.ForEachCellTcxGridAddExcel komponent TXLSWorksheet.WriteCellsExport DBGrid content to Excel with header, detail, grouping, formattingAddChartSheet metod event hooks TXLSWorksheet.ApplyAutoFilterÖversikt komponent AutoFilterColumns

English (US)

Optional cxTcxGridAddExcel komponent

Open release notes TcxGridDBTableView data with workbook targeting, grouped output, formatting controlsAddChartSheet metod export events when the optional cxGrid unit is added to a project

TcxGridAddExcel komponent

TGridToXLS

English (UK)

Languages:
English (US) English (UK) Dansk Tiếng Việt Bahasa Indonesia ไทย Čeština Slovenčina Български Hrvatski Srpski (latinica) Slovenščina Lietuvių Українська Română עברית Ελληνικά Suomi Norsk Español (España) Español (Latinoamérica) Magyar Deutsch Français Italiano 日本語 Português (Brasil) Português (Portugal) Nederlands Svenska Polski Türkçe 한국어 العربية فارسی Русский 简体中文 繁體中文
Copyright © 2010-2026 losLab Software