ข้อมูลอ้างอิงสำหรับนักพัฒนา HotXLS

บันทึกประจำรุ่น

วิธีใช้คอมโพเนนต์ HotXLS

วิธีใช้คอมโพเนนต์ HotXLS 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 เมธอด export APIs เปิดสารบัญ
สำรวจการรองรับ XLSX

เริ่มจากภาพรวม

เริ่มจากภาพรวม

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

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 Support .ods 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 Support 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 เมธอด OOXML save/open workflows SaveAsODSภาพรวม Classic XLS Pivot Tables TODSExportOptionsModern เวิร์กชีต Features

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 เมธอด auto-filter criteria

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 Support .ods 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 Support Open or OpenODS , save ODS output with SaveAsODS , tune exports with TODSExportOptions AddChartSheet เมธอด round-trip styles, images, charts, validations, conditional formats, print setupAddChartSheet เมธอด 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 เมธอด auto-filter criteria Sheets.AddChartSheet TXLSXWorksheet คลาส

Add Data Bar, Color ScaleAddChartSheet เมธอด 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 เมธอด cfRule priority pinning

Add Data Bar, Color ScaleAddChartSheet เมธอด 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 เมธอด cfRule priority pinning

OpenDocument Spreadsheet I/O AddTableExpCreate, 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 Support .ods 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 Support Open or OpenODS , save ODS output with SaveAsODS , tune exports with TODSExportOptions AddChartSheet เมธอด round-trip styles, images, charts, validations, conditional formats, print setupAddChartSheet เมธอด sheet structure 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 เมธอด auto-filter criteria Sheets.AddChartSheet — column, bar, lineAddChartSheet เมธอด pie chart kinds, with title, axis titlesAddChartSheet เมธอด series bound to A1-range references FILESHARING, FILESHARING2, PROT4REVAddChartSheet เมธอด PROT4REVPASSAddChartSheet เมธอด HIDEOBJBIFF8 Tables 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 Encryption TEMPLATE, TABIDAddChartSheet เมธอด BOOKEXT เวิร์กบุ๊ก metadata preservationUSERSVIEWBEGIN / USERSVIEWENDAddress cell fill, fontAddChartSheet เมธอด 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 เมธอด expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions

Address cell fill, fontAddChartSheet เมธอด 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 เมธอด expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions

Address cell fill, fontAddChartSheet เมธอด 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 เมธอด expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions

Interior.SetThemeColor เมธอด SetThemeColorภาพรวม Classic XLS Pivot Tables XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor ภาพรวม Classic XLS Pivot Tables 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 เมธอด the writer re-emits them when the record fits one BIFF chunk TXLSWorksheet.TabColor ภาพรวม Classic XLS Pivot Tables HFPicture Classic XLS Pivot Tables HeaderFooter Create, open, style, automateAddChartSheet เมธอด export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface TXLSShape.OfficeArtOptions

TabColor คุณสมบัติ

ภาพรวม Classic XLS Pivot Tables

ภาพรวม Classic XLS Pivot Tables 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 เมธอด the writer re-emits them when the record fits one BIFF chunk TXLSWorksheet.TabColorภาพรวม Classic XLS Pivot Tables HFPicture Classic XLS Pivot Tables HeaderFooter Create, open, style, automateAddChartSheet เมธอด export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface

Create, open, style, automateAddChartSheet เมธอด export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface

ภาพรวม Classic XLS Pivot Tables

เวิร์กบุ๊ก 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 อินเทอร์เฟซ

Classic XLS Pivot Tables

Classic XLS Pivot Tables

Create typed classic XLS pivot tables, inspect Excel-authored pivot workbooks, preserve raw pivot recordsAddChartSheet เมธอด configure field axes, subtotals, page filtersAddChartSheet เมธอด data-field number formats .xlsx API ตาราง pivot ของ XLS แบบคลาสสิก

Norsk

ช่วง Editing FILESHARING , FILESHARING2 , PROT4REV , PROT4REVPASS , HIDEOBJ , zero-length TEMPLATE , TABID , BOOKEXT , USERSVIEWBEGIN , USERSVIEWEND AddChartSheet เมธอด saved-by metadata when classic XLS workbooks pass through HotXLS

ช่วง Editing FILESHARING , FILESHARING2 , PROT4REV , PROT4REVPASS , HIDEOBJ BIFF8 Tables 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 Encryption TEMPLATE , TABID , BOOKEXT , USERSVIEWBEGIN , USERSVIEWEND IXLSRange อินเทอร์เฟซ

Classic XLS เวิร์กบุ๊ก metadata

เวิร์กชีต API

โมเดลสีของ XLS แบบคลาสสิก TXLSShapes.DeleteInRange โมเดลสีของ XLS แบบคลาสสิก TXLSWorksheet.ForEachCell TcxGridAddExcel คอมโพเนนต์ TXLSWorksheet.WriteCells Export DBGrid content to Excel with header, detail, grouping, formattingAddChartSheet เมธอด event hooks TXLSWorksheet.ApplyAutoFilter ภาพรวม คอมโพเนนต์ AutoFilterColumns

English (US)

ช่วง Editing

ช่วง Editing FILESHARING, FILESHARING2, PROT4REV, PROT4REVPASS, HIDEOBJBIFF8 Tables 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 Encryption TEMPLATE, TABID, BOOKEXT, USERSVIEWBEGIN, USERSVIEWENDIXLSRange อินเทอร์เฟซ

Optional cxTcxGridAddExcel คอมโพเนนต์

Review the ThemeColor, TintAndShadeAddChartSheet เมธอด classic XLS palette-based formatting decision

โมเดลสีของ XLS แบบคลาสสิก TXLSShapes.DeleteInRangeโมเดลสีของ XLS แบบคลาสสิก TXLSWorksheet.ForEachCellTcxGridAddExcel คอมโพเนนต์ TXLSWorksheet.WriteCellsExport DBGrid content to Excel with header, detail, grouping, formattingAddChartSheet เมธอด event hooks TXLSWorksheet.ApplyAutoFilterภาพรวม คอมโพเนนต์ AutoFilterColumns

English (US)

Optional cxTcxGridAddExcel คอมโพเนนต์

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

TcxGridAddExcel คอมโพเนนต์

Review the HTML version history for HotXLS classic XLS, 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, export, compatibilityAddChartSheet เมธอด documentation updates in multiple languages

Open release notes TcxGridDBTableView สำรวจการรองรับ XLSX

Classic XLS 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 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 API, guideAddChartSheet เมธอด Pascal example topics are available directly in the web help

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