Σημειώσεις έκδοσης

Βοήθεια στοιχείου 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)

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

Português (Brasil)

Português (Portugal)

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Επισκόπηση Πρόσοψης XLSX (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) 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

TXLSXWorksheet κλάση

OpenDocument Spreadsheet I/O

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

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Επισκόπηση Πρόσοψης XLSX (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) XlsApplyThemeColorToDrawing / XlsGetDrawingThemeColor Επισκόπηση Πρόσοψης XLSX (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) 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 Επισκόπηση Πρόσοψης XLSX (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) HFPicture Classic XLS Pivot Tables HeaderFooter Create, open, style, automateAddChartSheet μέθοδος export Excel 2007+ .xlsx workbooks through the dedicated OOXML API surface TXLSShape.OfficeArtOptions

TabColor ιδιότητα

Επισκόπηση Πρόσοψης XLSX (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)

Επισκόπηση Πρόσοψης XLSX (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) 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Επισκόπηση Πρόσοψης XLSX (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) 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

Επισκόπηση Πρόσοψης XLSX (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)

βιβλίο εργασίας 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

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 Classic XLS API πινάκων περιστροφής

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

Μοντέλο χρωμάτων classic XLS TXLSShapes.DeleteInRange Μοντέλο χρωμάτων classic 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

Μοντέλο χρωμάτων classic XLS TXLSShapes.DeleteInRangeΜοντέλο χρωμάτων classic XLS TXLSWorksheet.ForEachCellTcxGridAddExcel στοιχείο TXLSWorksheet.WriteCellsExport DBGrid content to Excel with header, detail, grouping, formattingAddChartSheet μέθοδος event hooks TXLSWorksheet.ApplyAutoFilterΕπισκόπηση στοιχείο AutoFilterColumns

English (US)

Dataset Export

Σημειώσεις έκδοσης

TGridToXLS στοιχείο

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 στοιχείο

Languages:

Open sample workflows for purchase orders, grouped exports, imagesAddChartSheet μέθοδος common workbook automation

English (US)

Σημειώσεις έκδοσης

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

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

Languages:

English (US)

TGridToXLS

English (UK)

Languages:

Εξερεύνηση υποστήριξης 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 Languages: English (US) 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 English (UK) Languages: English (UK) Bahasa Indonesia English (UK) Languages: Languages: Slovenčina Bahasa Indonesia Hrvatski Srpski (latinica) Srpski (latinica) Slovenščina Lietuvių Bahasa Indonesia Hrvatski Srpski (latinica) Srpski (latinica) Español (Latinoamérica) Slovenščina Norsk Bahasa Indonesia Español (Latinoamérica) Español (Latinoamérica) Srpski (latinica) Deutsch Français Italiano Italiano Norsk Português (Brasil) Português (Portugal) 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