Dodatni članovi API-ja biblioteke

Ova stranica upotpunjuje referencu za javne tipove koji podržavaju glavne API-je radnih knjiga, radnih listova, iscrtavanja, uvoza, dijagnostike i preglednika, ali ne zahtijevaju zaseban vodič usmjeren na zadatak

Filtriranje i uvjetno oblikovanje

TXLSCfValue, TXLSDataBarSpec, TXLSColorScaleSpec, TXLSIconSetSpec i TXLSDxfStyle prihvaćaju AttachWriteGuardOwner, povezujući objekt pravila s njegovom radnom knjigom vlasnikom tako da izmjene automatski stječu zaštitu zapisa; vlasnik implementira TXLSCondFormatWriteGuardOwner čija jedina metoda AcquireWriteGuard predaje pravilu zaštitu zapisa radne knjige. TXLSDxfStyle dodaje FontColorIndex s FontColorIsIndexed uz parove FillFgColorIndex / FillFgColorIsIndexed i FillBgColorIndex / FillBgColorIsIndexed za boje pravila kao indekse u paleti, te nadjačave diferencijalnog fonta FontName, FontSize i FontScheme (prazan string, veličina u točkama ili slot tematskog fonta poput major / minor) uz postojeće članove za bold, italic, underline i boju; svaka dodjela stječe write guard i označava pravilo kao dirty za ponovno ispisivanje

TXLSConnections, TXLSDataTables i TXLSQueryTables izlažu OnAcquireWriteGuard (tipovi TXLSConnectionAcquireWriteGuard, TXLSDataTableAcquireWriteGuard i TXLSQueryTableAcquireWriteGuard), udicu kojom njihovi putevi izmjena stječu IXLSWorkbookWriteGuard radne knjige vlasnika prije mutacije te nakon nje pomiču generaciju radne knjige; zaštita bilježi StartGeneration, a Complete označava zapis dovršenim pa se ovisne predmemorije mogu ponovno izgraditi

Zadržane podatkovne veze nose tipizirani opis: TXLSConnectionKind (xlckUnknown, xlckOdbc, xlckDao, xlckFile, xlckWeb, xlckOleDb, xlckText, xlckAdo) razvrstava vezu, TXLSConnectionCredentials (xlccIntegrated, xlccNone, xlccStored, xlccPrompt) bilježi njezin način provjere autentičnosti, a svaka vrijednost parametra veze označena je s TXLSConnectionParameterValueKind (xlcpvNone, xlcpvBoolean, xlcpvDouble, xlcpvInteger, xlcpvString, xlcpvCell). Tablice podataka „what-if“ izvještavaju o vrsti svoje pohranjene definicije kroz TXLSDataTableKind

Tablice podataka „what-if“ i grupiranje u sažetim tablicama

Pragovi skupa ikona mogu se iscrtati ili provjeriti programski: XLSCfIconSetCount izvještava koliko ikona definira TXLSIconSetType, a XLSBuildCfIconGeometry popunjava TXLSCfIconGeometry primitivama (TXLSCfIconPrimitive, vrsta TXLSCfIconPrimitiveKind: cfipPolygon, cfipEllipse, cfipRect, cfipLine) i točkama (TXLSCfIconPoint) koje crtaju jednu ikonu, tako da prilagođeni iscrtavatelji odgovaraju Excelovim ugrađenim oblicima ikona

Dijagnostika, praćenje formula i provjera valjanosti

Pravila spremanja vanjskih veza

TXLSExternalLinkUpdateMode = (xluPromptUser, xluNever, xluAlways);

property IXLSWorkbook.SaveExternalLinkValues: Boolean;
property IXLSWorkbook.UpdateLinks: TXLSExternalLinkUpdateMode;
property TXLSXWorkbook.SaveExternalLinkValues: Boolean;
property TXLSXWorkbook.UpdateLinks: TXLSExternalLinkUpdateMode;
      

Revizija izračuna i savjeti radne knjige

function TXLSWorkbook.RecalcAndVerify(MaxIssues: Integer = 10000): TXLSCalculationAuditReport;
function TXLSXWorkbook.RecalcAndVerify(MaxIssues: Integer = 10000): TXLSCalculationAuditReport;
function TXLSWorkbook.RecalcAndVerifyEx(const Options: TXLSRecalcAuditOptions): TXLSCalculationAuditReport;
function TXLSXWorkbook.RecalcAndVerifyEx(const Options: TXLSRecalcAuditOptions): TXLSCalculationAuditReport;
function TXLSWorkbook.RunCalculationAudit(const Options: TXLSRecalcAuditOptions): TXLSCalculationAuditReport;
function TXLSWorkbook.FormulaIsVolatile(Formula: WideString): Boolean;

function TXLSWorkbook.AuditOverlayHash(SheetIndex, Row, Col: Integer): Integer;
function TXLSWorkbook.AuditOverlayRead(SheetIndex, Row, Col: Integer; var Value: Variant): Boolean;
procedure TXLSWorkbook.AuditOverlayWrite(SheetIndex, Row, Col: Integer; const Value: Variant);
procedure TXLSWorkbook.AuditOverlayClear;

TXLSCalculationAuditIssueKind = (xlcaiCacheMismatch, xlcaiParseFailure,
  xlcaiMissingFunction, xlcaiMissingName, xlcaiUnsupportedArguments,
  xlcaiCircularReference, xlcaiExternalReferenceDenied,
  xlcaiExternalReferenceMissing, xlcaiDataTableSkipped, xlcaiCancelled,
  xlcaiInternalFailure);

TXLSCalculationAuditIssue = record
  Kind: TXLSCalculationAuditIssueKind;
  SheetIndex: Integer;
  SheetName: WideString;
  Row: Integer;
  Col: Integer;
  Formula: WideString;
  Symbol: WideString;
  Expected: Variant;
  Actual: Variant;
  ResultCode: Integer;
  Stack: WideString;
  ExternalTarget: WideString;
end;
TXLSCalculationAuditIssues = array of TXLSCalculationAuditIssue;

TXLSRecalcAuditProgress = procedure(ASender: TObject;
  ACurrent, ATotal: Integer; var ACancel: Boolean) of object;

property WorkbookCodeName: WideString;
property CalculationThreadMode: TXLSCalculationThreadMode;
property ForceFullCalculationState: TXLSOptionalBooleanState;
property RefreshAllOnLoadState: TXLSOptionalBooleanState;
      

Formule tablica i IME stanje

property TXLSXTable.ColumnCalculatedFormulaArrayStates[Index: Integer]: TXLSTableFormulaArrayState;
property TXLSXTable.ColumnTotalsFormulaArrayStates[Index: Integer]: TXLSTableFormulaArrayState;
property TDataValidation.ImeMode: TXLSDataValidationImeMode;
property TXLSXDataValidation.ImeModeKind: TXLSDataValidationImeMode;
      

Pregled i uklanjanje okna zadataka web-dodatka

function IXLSWorkbook.HasWebAddinTaskPanes: Boolean;
function IXLSWorkbook.WebAddinTaskPaneCount: Integer;
function IXLSWorkbook.RemoveWebAddinTaskPanes: Integer;
function TXLSXWorkbook.HasWebAddinTaskPanes: Boolean;
function TXLSXWorkbook.WebAddinTaskPaneCount: Integer;
function TXLSXWorkbook.RemoveWebAddinTaskPanes: Integer;
      

Pravila prikaza objekata radne knjige

TXLSObjectDisplayMode = (xlsodmShowAll, xlsodmShowPlaceholders,
  xlsodmHideAll);

property IXLSWorkbook.ObjectDisplayMode: TXLSObjectDisplayMode;
property TXLSWorkbook.ObjectDisplayMode: TXLSObjectDisplayMode;
property TXLSXWorkbook.ObjectDisplayMode: TXLSObjectDisplayMode;
property TXLSPaginationModel.ExportObjectPlaceholders: Boolean;
property TXLSPDFExport.ExportObjectPlaceholders: Boolean;
property TXLSSvgExport.ExportObjectPlaceholders: Boolean;
property TXLSPageImageExporter.ExportObjectPlaceholders: Boolean;
property TXLSPrintDocument.ExportObjectPlaceholders: Boolean;
property TXLSXHtmlExportOptions.ExportObjectPlaceholders: Boolean;
      

Vrijednosti kalibracije iscrtavanja i snimci

TXLSRenderCalibration = record
  WidthCorrection: Double;
  HeightCorrection: Double;
  LineSpacing: Double;
  CellMarginFactor: Double;
  ScreenScaling: Integer;
  MeasurementDpi: Integer;
end;

function XLSDefaultRenderCalibration: TXLSRenderCalibration;
function XLSValidateRenderCalibration(const AValue: TXLSRenderCalibration;
  out AInvalidField: TXLSRenderCalibrationField): Boolean;
      

Geometrija iscrtavanja i mjerenje fontova

TXLSRenderGeometryBackend = (xlsrgbAutoFit, xlsrgbPagination, xlsrgbPdf,
  xlsrgbSvg, xlsrgbBitmap, xlsrgbPrintPreview, xlsrgbViewer, xlsrgbHtml);

TXLSRenderFont = record
  Name: WideString;
  Size: Double;
  Styles: TXLSRenderFontStyles;
  Charset: Byte;
end;

function CreateXLSRenderGeometry(
  const ACalibration: TXLSRenderCalibration;
  AWorkbookGeneration: UInt64;
  ABackend: TXLSRenderGeometryBackend;
  ACacheCapacity: Integer = 4096): IXLSRenderGeometry;

property TXLSHTMLExport.RenderGeometry: IXLSRenderGeometry;
property TXLSXHtmlExportSession.RenderGeometry: IXLSRenderGeometry;
      

Uvoz, generiranje koda, usporedba i nadzor

Pomoćne funkcije za pakete i binarno spremište

Dodaci za crteže i preglednik radnih knjiga

Paginacija, slikovni izlaz i ispis

Klasični modeli grafikona i objekti grafikona radnog lista

Tipizirani model dekodiranja grafikona

Dekodirano stanje grafikona izlaže se kao obični zapisi i enumeracije tako da kod za pregled nikada ne mora prolaziti kroz sirove BIFF zapise: TXLSChartInfo nosi sažetak dekodiranog grafikona s TXLSChartTypeFamily (cfBar, cfLine, cfPie, cfArea, cfScatter, cfRadar, cfDoughnut, cfSurface, cfBubble), svaki niz izvještava TXLSChartSeriesType, a TXLSChart3DState uz TXLSChart3DInfo opisuju trodimenzionalne poglede. TXLSChartAxisType (catCategory, catValue, catSeries, catDate) i TXLSChartLegendPosition razvrstaju osi i legende, dok model datumskih osi koristi TXLSChartDateUnit (xcduDays, xcduMonths, xcduYears) i TXLSChartDateValues. TXLSCustomChart dekodirani model izlaže kroz TXLSChartInfo; napomene linija trenda i stupaca pogreške tipizirani su objekti (TXLSChartTrendline, TXLSChartErrorBars) dostižni iz svakog niza

Zapisi za izradu grafikona

Izrada listova grafikona i graditelja prihvaća obične zapise umjesto grafova objekata: TXLSChartTrendlineInfo, TXLSChartErrorBarsInfo, TXLSChartDataLabelsInfo i TXLSChartSeriesStyleInfo popunjavaju unose nizova koji se predaju TXLSWorksheets.AddChartSheet i zajedničkom graditelju grafikona, a TXLSPivotChartInfo opisuje uokvirivanje pivot grafikona koje se koristi kada se grafikon veže uz pivot tablicu

PDF privitci, potpisi i HTML izvoz

Revizija izračuna i kontrole radne knjige

Kompatibilnost naslijeđenog uokvirivanja PivotCache-a

StreamId upisuje se kao zapis SXStreamID ([MS-XLS] §2.4.303) i ponavlja kao polje idstm zaglavlja SXDB, kojem mora biti jednako; SourceDataType upisuje se kao zapis SXVS ([MS-XLS] §2.4.317: $0001 radni list, $0002 vanjska, $0004 konsolidacija, $0010 scenarij) i ponavlja kao polje vsType zaglavlja SXDB, kojem mora biti jednako. Predmemorije izgrađene iz raspona radnog lista počinju s tipom radnog lista, dok predmemorije ponovno pročitane iz datoteke zadržavaju vrijednost koju je njihov podtok nosio, tako da BIFF pisac nikada ne ostavlja polje SXDB koje navodi zapis koji nije ispisao; RawHasStorageStream označava predmemoriju učitanu iz vlastitog toka spremišta čiji opis na razini radne knjige prethodi predmemoriranim zapisima

Integracija međuspremnika i opcije lijepljenja

TXLSPasteOption = (xlpoValuesOnly, xlpoInsertRows, xlpoInsertCols);
TXLSPasteOptions = set of TXLSPasteOption;

function XLSGetClipboardText: WideString;
function XLSSetClipboardText(const Text: WideString): Boolean;
function XLSSetClipboardTextAndHtml(const Text: WideString;
  const Html: AnsiString): Boolean;
function XLSBuildHtmlClipboard(const Html: AnsiString): AnsiString;
function XLSEncodeClipboardField(const Text: WideString): WideString;
function XLSClipboardHasText: Boolean;
function XLSParseClipboardGrid(const ClipboardText: WideString;
  Loader: TXLSCSVLoader): Boolean;
function XLSClipboardHasXmlSpreadsheet: Boolean;
function XLSGetClipboardXmlSpreadsheet: WideString;
function XLSClipboardHasBiff8: Boolean;
      

Razrješavanje teksta prikaza ćelije

TXLSCellDisplayMode = (xcdmFormattedValue, xcdmFormulaText,
  xcdmSuppressedZero);

TXLSCellDisplayOptions = record
  ShowFormulas: Boolean;
  ShowZeros: Boolean;
  SheetProtected: Boolean;
  FormulaWidthFactor: Double;
  DateSerialZero: Double;
end;

TXLSCellDisplayInput = record
  HasFormula: Boolean;
  FormulaHidden: Boolean;
  IsNumericZero: Boolean;
  FormulaText: WideString;
  FormattedText: WideString;
end;

TXLSCellDisplayResult = record
  Mode: TXLSCellDisplayMode;
  Text: WideString;
  TreatAsText: Boolean;
  EffectiveWidthFactor: Double;
end;

function XLSDefaultCellDisplayOptions: TXLSCellDisplayOptions;
function XLSNormalizeFormulaDisplayText(const FormulaText: WideString): WideString;
function XLSResolveCellDisplay(const Options: TXLSCellDisplayOptions;
  const Input: TXLSCellDisplayInput): TXLSCellDisplayResult;
      

Objekti klasične provjere podataka

TXLSDataValidationType = (xlsDvAny, xlsDvWhole, xlsDvDecimal, xlsDvList,
  xlsDvDate, xlsDvTime, xlsDvTextLength, xlsDvCustom);
TXLSDvErrorStyle = (xlsDvErrStop, xlsDvErrWarning, xlsDvErrInformation);

TDVRange = class;             { one validation rule over one or more ranges }
TDVRangeList = class;         { the per-sheet rule collection }
TDataValidator = class;       { engine that checks edits against the rules }
      

Skeniranje i razrješavanje indeksiranih boja

TXLSIndexedColorKind = (xickPalette, xickAutomatic, xickSystem, xickInvalid);
TXLSSystemColorRole = (xscrNone, xscrWindowText, xscrWindowBackground,
  xscrChartText, xscrChartBackground, xscrChartNeutral, xscrToolTipText);

TXLSIndexedColorResolution = record
  Kind: TXLSIndexedColorKind;
  RawIndex: Int64;
  PaletteSlot: Integer;
  SystemColorRole: TXLSSystemColorRole;
  ARGB: LongWord;
  HasResolvedColor: Boolean;
end;

TXLSNearestIndexedColorMatch = record
  InputARGB: LongWord;
  ColorIndex: Integer;
  PaletteSlot: Integer;
  ARGB: LongWord;
  DistanceSquared: Double;
  ExactMatch: Boolean;
end;

TXLSIndexedColorUsageKind = (xicukFont, xicukFillForeground,
  xicukFillBackground, xicukGradient, xicukBorder, xicukConditionalFormat,
  xicukChart, xicukShape, xicukComment, xicukWorksheet, xicukOther);
      

Pomoćne funkcije za A1 reference

function XLSA1CellRef(ARow, ACol: Integer): WideString;
function XLSTryParseA1CellRef(const ARef: WideString;
  out ARow, ACol: Integer): Boolean;
function XLSTryParseA1RangeRef(const ARef: WideString;
  out ARow1, ACol1, ARow2, ACol2: Integer): Boolean;
      

Vidi također

• Dodatni članovi API-ja za Classic XLS
• Napredni članovi XLSX API-ja
• Geometrija razrjeđene konture
• Praćenje i revizija formula
• Značajka preglednika radnih knjiga