HotXLS 開發者參考

Use this reference to find classic XLS automation IXLSWorkbook 介面 the expIXLSWorkbook 介面ed XLSX facade, including workbook, worksheet, range, formatting, image, page setup, hyperlink, name, chart, table, validation, filter, view-stateAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too export APIs

開啟目錄

開啟目錄 查看 XLSX 支援 從概述開始
456

傳統 XLS 和 擴充 XLSX API, guide, 和 Pascal example topics 是 可用 directly 中的 web help

傳統 XLS 和 擴充 XLSX API, guide, 和 Pascal example topics 是 可用 directly 中的 web help

Português (Brasil)

Português (Portugal) lxHIXLSWorkbook 介面leX NederlIXLSWorkbook 介面s

Svenska

Português (Portugal) lxHIXLSWorkbook 介面leX facade for Excel 2007+ workbooks, worksheet collections, styles, shared strings, defined namesAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too OOXML save/open workflows

XLSX 外觀概觀 .ods XLSX 外觀概觀 Open or OpenODS現代 工作表 功能 SaveAsODSUse 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 panesAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too auto-filter criteria TODSExportOptionsTXLSXWorksheet 類別

OpenDocument Spreadsheet I/O

XLSX 外觀概觀 .ods XLSX 外觀概觀 Open or OpenODS 現代 工作表 功能 SaveAsODS 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 panesAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too auto-filter criteria TODSExportOptions Attach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too round-trip styles, images, charts, validations, conditional formats, print setupAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too sheet structure

XLSX 外觀概觀 .ods XLSX 外觀概觀 Open or OpenODS 現代 工作表 功能 SaveAsODS 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 panesAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too auto-filter criteria TODSExportOptions TXLSXWorksheet 類別

TXLSXWorkbook ODS APIs

Conditional Formatting Extensions

Add Data Bar, Color ScaleAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too Icon Set rules on both BIFF8 IXLSWorkbook 介面 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 controlAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too cfRule priority pinning Sheets.AddChartSheet TCondFormat 參考

BIFF8 Chart 工作表

BIFF8 Chart 工作表

Programmatically build chart tabs into a .xls workbook with Sheets.AddChartSheet — column, bar, lineAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too pie chart kinds, with title, axis titlesAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too series bound to A1-range references AddTableAddChartSheet 方法 EncryptionPassword BIFF8 表格 和 Encryption FILESHARING, FILESHARING2, PROT4REVAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too PROT4REVPASSProgrammatically build chart tabs into a .xls workbook with Sheets.AddChartSheet — column, bar, lineAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too pie chart kinds, with title, axis titlesAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too series bound to A1-range references AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword BIFF8 表格 和 Encryption FILESHARING , FILESHARING2 , PROT4REV Attach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ 活頁簿中繼資料 保留 TEMPLATE , TABID Attach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too BOOKEXT Address cell fill, fontAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too 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-tripAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptions USERSVIEWBEGIN / USERSVIEWEND Interior.SetThemeColor 方法 HIDEOBJ活頁簿中繼資料 保留 TEMPLATE, TABIDAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too BOOKEXT Address cell fill, fontAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too 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-tripAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too expert shape code can inspect or edit raw OfficeArt FOPT PIDs through TXLSShape.OfficeArtOptionsUSERSVIEWBEGIN / USERSVIEWENDInterior.SetThemeColor 方法

SheetExt IXLSWorkbook 介面 Header / Footer Extras

SheetExt IXLSWorkbook 介面 Header / Footer Extras

XLSX 外觀概觀 SheetExt Create typed classic XLS pivot tables, inspect Excel-authored pivot workbooks, preserve raw pivot recordsAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too configure field axes, subtotals, page filtersAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too data-field number formats TXLSWorksheet.TabColor 建立, open, 樣式, automate, 和 export Excel 2007+ HFPicture 活頁簿 透過 dedicated OOXML API 範圍 HeaderFooter XLSX 外觀概觀 SetThemeColorTabColor 屬性 XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor SST Rich 文字 和 Phonetic Runs TXLSShape.OfficeArtOptions

Shared-string per-character font / color runs IXLSWorkbook 介面 Far-East phonetic annotations (furigana) survive load IXLSWorkbook 介面 save: the parser preserves rgRun IXLSWorkbook 介面 rgExtRst trailing blocks per unique stringAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too the writer re-emits them when the record fits one BIFF chunk

XLSX 外觀概觀

XLSX 外觀概觀 SheetExt Create typed classic XLS pivot tables, inspect Excel-authored pivot workbooks, preserve raw pivot recordsAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too configure field axes, subtotals, page filtersAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too data-field number formats TXLSWorksheet.TabColor建立, open, 樣式, automate, 和 export Excel 2007+ HFPicture 活頁簿 透過 dedicated OOXML API 範圍 HeaderFooter XLSX 外觀概觀

XLSX 外觀概觀

活頁簿 API

Create, open, save, protect, calculateAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too export Excel XLSX 外觀概觀 the main workbook interface, including saved-by metadata, file-sharing metadata preservationAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too pivot cache inspection rgRun IXLSWorkbook 介面 rgExtRst 傳統 XLS 樞紐分析表

Create typed classic XLS pivot tables, inspect Excel-authored pivot workbooks, preserve raw pivot recordsAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too configure field axes, subtotals, page filtersAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too data-field number formats

Create typed classic XLS pivot tables, inspect Excel-authored pivot workbooks, preserve raw pivot recordsAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too configure field axes, subtotals, page filtersAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too data-field number formats

傳統 XLS 樞紐分析表 API .xlsx 活頁簿中繼資料

Svenska

, 和 saved-透過 metadata 當 傳統 XLS 活頁簿 pass 透過 HotXLS

, 和 saved-透過 metadata 當 傳統 XLS 活頁簿 pass 透過 HotXLS

傳統 XLS 活頁簿中繼資料

工作表 API

傳統 XLS 色彩 模型 TXLSShapes.DeleteInRange 傳統 XLS 色彩 模型 TXLSWorksheet.ForEachCell TcxGridAddExcel 元件 TXLSWorksheet.WriteCells Export DBGrid content to Excel with header, detail, grouping, formattingAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too event hooks TXLSWorksheet.ApplyAutoFilter IXLSWorkbook 元件 AutoFilterColumns

TXLSWorksheet 參考

範圍 Editing

範圍 Editing FILESHARING, FILESHARING2, PROT4REV, PROT4REVPASS, HIDEOBJ活頁簿中繼資料 保留 TEMPLATE, TABID, BOOKEXT, USERSVIEWBEGIN, USERSVIEWENDIXLSRange 介面

XLS 色彩 模型

Review ThemeColor, TintAndShade, 和 傳統 XLS palette-基於 formatting decision

傳統 XLS 色彩 模型 TXLSShapes.DeleteInRange傳統 XLS 色彩 模型 TXLSWorksheet.ForEachCellTcxGridAddExcel 元件 TXLSWorksheet.WriteCellsExport DBGrid content to Excel with header, detail, grouping, formattingAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too event hooks TXLSWorksheet.ApplyAutoFilterIXLSWorkbook 元件 AutoFilterColumns

English (UK)

Optional cxTcxGridAddExcel 元件

Open release notes TcxGridDBTableView data with workbook targeting, grouped output, formatting controlsAttach Excel ListObject tables to a range via AddTable , opt into compact shared-formula output, or generate Excel-compatible password-protected .xls files through the EncryptionPassword property. Excel-authored workbook sharing IXLSWorkbook 介面 revision-protection metadata, including FILESHARING , FILESHARING2 , PROT4REV BIFF8 佈景主題 色彩 和 XFExt PROT4REVPASS , now survives classic XLS open/save cycles. Workbook view IXLSWorkbook 介面 extension globals such as HIDEOBJ , zero-length TEMPLATE , TABID BIFF8 佈景主題 色彩 和 XFExt BOOKEXT are preserved as well. Excel Custom View blocks ( USERSVIEWBEGIN / USERSVIEWEND ) are preserved in workbook globals IXLSWorkbook 介面 worksheet substreams too export events when the optional cxGrid unit is added to a project

TcxGridAddExcel 元件

Review HTML version history 用於 HotXLS 傳統 XLS, 擴充 XLSX, export, compatibility, 和 documentation updates 在 multiple languages

Open release notes TcxGridDBTableView 傳統 XLS 和 擴充 XLSX API, guide, 和 Pascal example topics 是 可用 directly 中的 web help

Tiếng Việt

HotXLS 元件說明

Tiếng Việt

Bahasa Indonesia
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