Prikazi radne knjige, veze i XML karte
Ova referenca pokriva metapodatke radne knjige koje je moguće uređivati, a koji se nalaze izvan mreže ćelija i moraju ostati dosljedni kada se mijenjaju listovi, rasponi, filtri i dijelovi paketa
Klasični prilagođeni prikazi
TXLSWorksheet.CustomViews vraća TXLSCustomViews čiji članovi Count, Items, Invalidate i SyncToRaw čuvaju tipizirane i nepoznate zapise prilagođenih prikaza
TXLSCustomView izlaže ViewId, Zoom, GridColorIndex, ActivePane, ShowPageBreaks, ShowFormulas, ShowGridLines, ShowHeadings, ShowOutlineSymbols, ShowZeroValues, CenterHorizontally, CenterVertically, PrintHeadings, PrintGridLines, AutoFilterVisible, SplitVertically, SplitHorizontally, TopLeftRow, TopLeftColumn, SplitX, SplitY, RightPaneColumn, BottomPaneRow, SelectionCount, Selections, HorizontalPageBreaks, VerticalPageBreaks, HasPageSetup, PaperSize, PrintScale, PageSetupFlags, HorizontalResolution, VerticalResolution, HeaderMargin, Copies, ClearFilterCriteria, RawRecordCount, RawRecordIds i RawRecordData
TXLSCustomViewCellRange, TXLSCustomViewCellRanges, TXLSCustomViewSelectionInfo, TXLSCustomViewPageBreak i TXLSCustomViewPageBreaks prenose odabir i sadržaj prijeloma stranica u vlasništvu prikaza
XLSX prozori radne knjige
TXLSXWorkbook.WorkbookViews sadrži uređene unose TXLSXWorkbookView konfigurirane putem TXLSXWorkbookViewVisibility
| TXLSXWorkbookView | Assign, ActiveTab, Visibility, Minimized, ShowHorizontalScroll, ShowVerticalScroll, ShowSheetTabs, XWindow, YWindow, WindowWidth, WindowHeight, TabRatio, AutoFilterDateGrouping, UnknownAttributes i Extensions |
| TXLSXWorkbookViews | Add, Insert, Delete, Move, Clear, Count i Items |
Umetanje, brisanje i premještanje listova ponovno mapira aktivni i prvi vidljivi list svakog prozora uz očuvanje neovisne geometrije i postavki prikaza
Odabiri po plohi
TXLSXWorksheet.Selections vraća TXLSXSelections; TXLSXSelectionPane prepoznaje ciljnu plohu, a svaki TXLSXSelection pohranjuje Pane, ActiveCell, ActiveCellId i Sqref s više područja
TXLSXSelection.Assign kopira jedan odabir, dok TXLSXSelections.Add, AddSelection, Assign, Clear, Delete, IndexOfPane, Count i Items održavaju uređenu zbirku prikaza lista
Podmodeli veza
TXLSConnection čuva metapodatke baze podataka, weba, teksta i OLAP-a. Njegov web model koristi WebParsePre, WebHtmlTables i WebTables; njegov model fiksnog teksta koristi TextSourceFile i TextFields; njegov OLAP model koristi HasOlapProperties, OlapLocal, OlapLocalConnection, OlapLocalRefresh, OlapSendLocale, OlapRowDrillCount, OlapServerFill, OlapServerNumberFormat, OlapServerFont, OlapServerFontColor, OlapExtraAttributesXml i OlapChildrenXml
SourceFile pohranjuje izvor veze na najvišoj razini, dok TextSourceFile pohranjuje neovisni izvor uvoza textPr; prazan TextSourceFile vraća se na SourceFile radi kompatibilnosti
TXLSWebTableSelectorKind konfigurira TXLSWebTableSelector čiji članovi Kind, Name, Index, ExtraAttributesXml, ChildrenXml, Assign i Validate čuvaju imenovane, indeksirane i potpune odabirače tablica
TXLSWebTableSelectors pruža Add, AddExisting, Assign, Validate, Delete, Clear, Count, Items, ExtraAttributesXml i UnknownChildrenXml
TXLSTextImportFieldType konfigurira TXLSTextImportField čiji članovi Position, ExtraAttributesXml, ChildrenXml, Assign i Validate definiraju jedno polje fiksnog teksta
TXLSTextImportFields pruža Add, AddExisting, Assign, Validate, Delete, Clear, Count, Items, ExtraAttributesXml i UnknownChildrenXml
Potpuni članovi veza
Zajednička svojstva TXLSConnection su Id, TypeCode, SourceFile, OdcFile, SingleSignOnId, KeepAlive, Interval, BackgroundRefresh, RefreshOnLoad, SaveData, SavePassword, NewConnection, Deleted, OnlyUseConnectionFile, ReconnectionMethod, RefreshedVersion, MinRefreshableVersion, ConnectionString, CommandText, ServerCommandText, CommandType, Parameters i ExtensionXml
Web svojstva su WebUrl, WebPost, WebEditPage, WebHtmlFormat, WebXml, WebSourceData, WebConsecutive, WebFirstRow, WebXl97, WebTextDates, WebXl2000, WebExtraAttributesXml i WebChildrenXml
Tekstualna svojstva su TextSourceFile, TextPrompt, TextDelimited, TextCodePage, TextFirstRow, TextCharacterSet, TextQualifier, TextFileType, TextDecimal, TextThousands, TextTab, TextSpace, TextComma, TextSemicolon, TextConsecutive, TextDelimiter, TextExtraAttributesXml i TextChildrenXml; čuvanje baze podataka koristi DbExtraAttributesXml i DbChildrenXml
TXLSConnections.Assign kopira zbirku, IndexOfId pronalazi stabilan identifikator veze, a RootAttributesXml plus UnknownChildrenXml čuvaju nepodržani sadržaj korijena
Parametri veza
TXLSConnectionParameter koristi Name, ParameterType, SqlType, RefreshOnChange, Prompt, CellReference, IntegerValue, DoubleValue, BooleanValue, StringValue, ValueKind, ExtraAttributesXml i Assign
TXLSConnectionParameters pruža Add, AddExisting, Assign, Delete, Clear, Count i Items
Upitne tablice i polja
TXLSQueryTable koristi Assign, ConnectionId, ResultTableName, ResultRange, RowNumbers, DisableRefresh, BackgroundRefresh, RefreshOnLoad, GrowShrinkType, RemoveDataOnSave, DisableEdit, PreserveFormatting, Intermediate, AutoFormatId, ApplyNumberFormats, ApplyBorderFormats, ApplyFontFormats, ApplyPatternFormats, ApplyAlignmentFormats, ApplyWidthHeightFormats, PreserveSortFilterLayout, AdjustColumnWidth, HeadersInLastRefresh, MinimumVersion, UnboundColumnsLeft, UnboundColumnsRight, DeletedFields, SortStateXml, ExtensionXml, RefreshExtensionXml, UnknownChildrenXml, ExtraAttributesXml, RefreshExtraAttributesXml i RefreshUnknownChildrenXml
TXLSQueryTableField koristi Id, Name, TableColumnId, DataBound, RowNumbers, Clipped, ExtraAttributesXml, Assign i Validate
TXLSQueryTableFields pruža Add, AddExisting, Assign, NextId, Validate, Delete, Clear, Count i Items; TXLSQueryTables.Assign kopira zbirku upitnih tablica radnog lista
XML karte i prilagođeni XML
TXLSXWorkbook.XmlMaps vraća TXLSXXmlMaps, a TXLSXWorksheet.XmlCellBindings vraća zbirku povezivanja lista
| TXLSXXmlDataBinding | Pohranjuje identifikator odnosa i metapodatke osvježavanja koji povezuju kartu s prilagođenim XML dijelom |
| TXLSXXmlSchema | Pohranjuje jedan identifikator sheme, prostor naziva i sačuvani XML sheme |
| TXLSXXmlMap | Pohranjuje identitet karte, korijenski element i prostor naziva te svoj DataBinding |
| TXLSXXmlMaps | AddSchema, AddMap, DeleteSchema, DeleteMap, Clear, Validate, SelectionNamespaces, SchemaCount, Schemas i MapCount |
| TXLSXXmlCellBinding | Mapira jedan raspon radnog lista na XPath i identifikator XML karte |
| TXLSXXmlCellBindings | Preopterećenja Add, Delete, Clear, Validate, Count i Items |
| TXLSXCustomXmlPart | AddSchemaRef povezuje prilagođenu XML stavku s referencom sheme |
Napredni članovi kloniranja, HTML-a i slika
TXLSXRangeClonePart, TXLSXRangeCloneParts i TXLSXRangeCloneSourceCounts definiraju kloniranje raspona svjesno ovisnosti. TXLSXWorksheet.CaptureRangeCloneSourceCounts, AuthorizeRepeatedDisjointRangeClones, ResizeTableRows i TileRangeAxisMetadata napredne su strukturno-uređivačke kuke koje koriste širenje kompiliranih izvještaja i prilagođeni sudionici
TXLSXHtmlExportSessionState opisuje TXLSXHtmlExportSession; koristite BeginExport, ExportNextSheet i Reset, zatim provjerite State, Active, ExportedSheetCount i TotalSheetCount. Postavite TXLSXHtmlExportOptions.IncludeDrawings za iscrtavanje podržanih objekata radnog lista u HTML sesiji
TXLSXImage izlaže Gamma, ShadowColor, ShadowOpacity, ShadowBlur, ShadowOffsetX i ShadowOffsetY za zajedničko iscrtavanje PDF-a, SVG-a, HTML-a, bitmape i metafile-a