import { ChartSpaceOptions, DataType, PositiveUniversalMeasure, UniversalMeasure } from "@office-open/core"; import { CustomDescriptor, WriteContext } from "@office-open/core/descriptor"; //#region src/parts/styles.d.ts interface FontOptions { bold?: boolean; italic?: boolean; underline?: boolean; strike?: boolean; size?: number; color?: string; font?: string; charset?: number; family?: number; condense?: boolean; extend?: boolean; vertAlign?: "superscript" | "subscript" | "baseline"; scheme?: "major" | "minor" | "none"; shadow?: boolean; outline?: boolean; } interface GradientStopOptions { position: number; color: string; } interface FillOptions { type?: "solid" | "pattern" | "gradient"; color?: string; patternType?: string; bgColor?: string; colorIndexed?: number; stops?: GradientStopOptions[]; gradientType?: "linear" | "path"; gradientDegree?: number; gradientLeft?: number; gradientRight?: number; gradientTop?: number; gradientBottom?: number; } interface BorderOptions { style?: "thin" | "medium" | "thick" | "dotted" | "dashed" | "hair" | "none"; color?: string; } interface BorderSideOptions { top?: BorderOptions; bottom?: BorderOptions; left?: BorderOptions; right?: BorderOptions; diagonal?: BorderOptions; diagonalUp?: boolean; diagonalDown?: boolean; start?: BorderOptions; end?: BorderOptions; vertical?: BorderOptions; horizontal?: BorderOptions; } interface AlignmentOptions { horizontal?: "left" | "center" | "right" | "fill" | "justify"; vertical?: "top" | "center" | "bottom"; wrapText?: boolean; textRotation?: number; indent?: number; relativeIndent?: number; justifyLastLine?: boolean; shrinkToFit?: boolean; readingOrder?: number; } interface StyleOptions { font?: FontOptions; fill?: FillOptions; border?: BorderSideOptions; numFmt?: string; alignment?: AlignmentOptions; quotePrefix?: boolean; pivotButton?: boolean; applyProtection?: boolean; protection?: CellProtectionOptions; } interface CellProtectionOptions { locked?: boolean; hidden?: boolean; } interface IndexedColorOptions { rgb: string; } interface ColorsOptions { indexedColors?: IndexedColorOptions[]; mruColors?: string[]; } interface DxfOptions { font?: FontOptions; fill?: FillOptions; border?: BorderSideOptions; numFmt?: string; } type TableStyleElementType = "wholeTable" | "headerRow" | "totalRow" | "firstColumn" | "lastColumn" | "firstRowStripe" | "secondRowStripe" | "firstColumnStripe" | "secondColumnStripe" | "firstHeaderCell" | "lastHeaderCell" | "firstTotalCell" | "lastTotalCell" | "subtotalRow1" | "subtotalRow2" | "subtotalRow3" | "subtotalColumn1" | "subtotalColumn2" | "subtotalColumn3" | "blankRow" | "firstColumnSubheading" | "secondColumnSubheading" | "thirdColumnSubheading" | "firstRowSubheading" | "secondRowSubheading" | "thirdRowSubheading" | "pageFieldLabels" | "pageFieldValues"; interface TableStyleElementOptions { type: TableStyleElementType; dxfId?: number; button?: boolean; } interface StyleExtensionOptions { uri: string; content?: string; } interface CustomTableStyleOptions { name: string; pivot?: boolean; elements?: TableStyleElementOptions[]; } interface CustomCellStyleOptions { name: string; xfId: number; builtinId?: number; customBuiltin?: boolean; iLevel?: number; hidden?: boolean; } interface CellXfEntry { fontId: number; fillId: number; borderId: number; numFmtId: number; alignment?: AlignmentOptions; quotePrefix?: boolean; pivotButton?: boolean; applyProtection?: boolean; protection?: CellProtectionOptions; } interface StylesState { customNumFmts: ReadonlyMap; fonts: FontOptions[]; fills: FillOptions[]; borders: BorderSideOptions[]; cellXfs: CellXfEntry[]; dxfs: DxfOptions[]; colors?: ColorsOptions; tableStyles?: CustomTableStyleOptions[]; customCellStyles?: CustomCellStyleOptions[]; styleExtensions?: StyleExtensionOptions[]; } interface IndexedXfEntry { fontId?: number; fillId?: number; borderId?: number; numFmtId?: number; alignment?: AlignmentOptions; protection?: CellProtectionOptions; quotePrefix?: boolean; pivotButton?: boolean; } interface TableStylesInfo { count?: number; defaultTableStyle?: string; defaultPivotStyle?: string; tableStyles?: CustomTableStyleOptions[]; } interface StylesParseResult { customNumFmtById?: Map; fonts?: FontOptions[]; fills?: FillOptions[]; borders?: BorderSideOptions[]; cellStyleXfs?: IndexedXfEntry[]; cellXfs?: IndexedXfEntry[]; customCellStyles?: CustomCellStyleOptions[]; dxfs?: DxfOptions[]; tableStylesInfo?: TableStylesInfo; colors?: ColorsOptions; styleExtensions?: StyleExtensionOptions[]; } declare class Styles { private fonts; private fontKeys; private fills; private fillKeys; private borders; private borderKeys; private customNumFmts; private nextCustomNumFmtId; private cellXfs; private cellXfKeys; private dxfs; private colors?; private tableStyles?; private customCellStyles?; private styleExtensions?; constructor(); register(opts: StyleOptions): number; registerDxf(opts: DxfOptions): number; setColors(opts: ColorsOptions): void; setTableStyles(styles: CustomTableStyleOptions[]): void; setExtensions(extensions: StyleExtensionOptions[]): void; setCustomCellStyles(styles: CustomCellStyleOptions[]): void; toDescriptorOptions(): StylesState; private registerFont; private registerFill; private registerBorder; private registerNumFmt; private cellXfKey; serialize(): string; private fontXmlStr; private borderXmlStr; private alignmentXmlStr; private protectionXmlStr; } interface StylesDocOptions { styles: Styles; } declare const stylesDesc: CustomDescriptor; //#endregion //#region src/parts/pivot/pivot-utils.d.ts declare const ConsolidateFunction: { readonly SUM: "sum"; readonly COUNT: "count"; readonly AVERAGE: "average"; readonly MAX: "max"; readonly MIN: "min"; readonly PRODUCT: "product"; readonly COUNT_NUMS: "countNums"; readonly STD_DEV: "stdDev"; readonly STD_DEV_P: "stdDevp"; readonly VAR: "var"; readonly VAR_P: "varp"; }; type ConsolidateFunction = (typeof ConsolidateFunction)[keyof typeof ConsolidateFunction]; interface PivotDataField { field: string; summarize?: ConsolidateFunction; name?: string; showDataAs?: string; baseField?: number; baseItem?: number; sortByTupleItems?: number[]; } interface PivotFieldOverrideOptions { field: string; allDrilled?: boolean; autoShow?: boolean; countSubtotal?: boolean; dataSourceSort?: boolean; defaultAttributeDrillState?: boolean; hiddenLevel?: boolean; hideNewItems?: boolean; insertBlankRow?: boolean; insertPageBreak?: boolean; itemPageCount?: boolean; measureFilter?: boolean; nonAutoSortDefault?: boolean; productSubtotal?: boolean; rankBy?: number; serverField?: boolean; showDropDowns?: boolean; showPropAsCaption?: boolean; showPropCell?: boolean; showPropTip?: boolean; stdDevPSubtotal?: boolean; stdDevSubtotal?: boolean; subtotalCaption?: string; topAutoShow?: boolean; uniqueMemberProperty?: boolean; varPSubtotal?: boolean; varSubtotal?: boolean; defaultItemSd?: boolean; } declare const PivotFilterType: { readonly UNKNOWN: "unknown"; readonly COUNT: "count"; readonly PERCENT: "percent"; readonly SUM: "sum"; readonly CAPTION_EQUAL: "captionEqual"; readonly CAPTION_NOT_EQUAL: "captionNotEqual"; readonly CAPTION_BEGINS_WITH: "captionBeginsWith"; readonly CAPTION_NOT_BEGINS_WITH: "captionNotBeginsWith"; readonly CAPTION_ENDS_WITH: "captionEndsWith"; readonly CAPTION_NOT_ENDS_WITH: "captionNotEndsWith"; readonly CAPTION_CONTAINS: "captionContains"; readonly CAPTION_NOT_CONTAINS: "captionNotContains"; readonly CAPTION_GREATER_THAN: "captionGreaterThan"; readonly CAPTION_GREATER_THAN_OR_EQUAL: "captionGreaterThanOrEqual"; readonly CAPTION_LESS_THAN: "captionLessThan"; readonly CAPTION_LESS_THAN_OR_EQUAL: "captionLessThanOrEqual"; readonly CAPTION_BETWEEN: "captionBetween"; readonly CAPTION_NOT_BETWEEN: "captionNotBetween"; readonly VALUE_EQUAL: "valueEqual"; readonly VALUE_NOT_EQUAL: "valueNotEqual"; readonly VALUE_GREATER_THAN: "valueGreaterThan"; readonly VALUE_GREATER_THAN_OR_EQUAL: "valueGreaterThanOrEqual"; readonly VALUE_LESS_THAN: "valueLessThan"; readonly VALUE_LESS_THAN_OR_EQUAL: "valueLessThanOrEqual"; readonly VALUE_BETWEEN: "valueBetween"; readonly VALUE_NOT_BETWEEN: "valueNotBetween"; readonly DATE_EQUAL: "dateEqual"; readonly DATE_NOT_EQUAL: "dateNotEqual"; readonly DATE_OLDER_THAN: "dateOlderThan"; readonly DATE_OLDER_THAN_OR_EQUAL: "dateOlderThanOrEqual"; readonly DATE_NEWER_THAN: "dateNewerThan"; readonly DATE_NEWER_THAN_OR_EQUAL: "dateNewerThanOrEqual"; readonly DATE_BETWEEN: "dateBetween"; readonly DATE_NOT_BETWEEN: "dateNotBetween"; readonly TOMORROW: "tomorrow"; readonly TODAY: "today"; readonly YESTERDAY: "yesterday"; readonly NEXT_WEEK: "nextWeek"; readonly THIS_WEEK: "thisWeek"; readonly LAST_WEEK: "lastWeek"; readonly NEXT_MONTH: "nextMonth"; readonly THIS_MONTH: "thisMonth"; readonly LAST_MONTH: "lastMonth"; readonly NEXT_QUARTER: "nextQuarter"; readonly THIS_QUARTER: "thisQuarter"; readonly LAST_QUARTER: "lastQuarter"; readonly NEXT_YEAR: "nextYear"; readonly THIS_YEAR: "thisYear"; readonly LAST_YEAR: "lastYear"; readonly YEAR_TO_DATE: "yearToDate"; readonly Q1: "Q1"; readonly Q2: "Q2"; readonly Q3: "Q3"; readonly Q4: "Q4"; readonly M1: "M1"; readonly M2: "M2"; readonly M3: "M3"; readonly M4: "M4"; readonly M5: "M5"; readonly M6: "M6"; readonly M7: "M7"; readonly M8: "M8"; readonly M9: "M9"; readonly M10: "M10"; readonly M11: "M11"; readonly M12: "M12"; }; type PivotFilterType = (typeof PivotFilterType)[keyof typeof PivotFilterType]; interface PivotFilterOptions { fld: number; type: PivotFilterType; id: number; mpFld?: number; evalOrder?: number; iMeasureHier?: number; iMeasureFld?: number; name?: string; description?: string; stringValue1?: string; stringValue2?: string; } interface PivotTableOptions { name?: string; source: string; sourceSheet?: string; location?: string; rows: string[]; columns?: string[]; data: PivotDataField[]; style?: string; filters?: PivotFilterOptions[]; pages?: string[]; pageCaptions?: string[]; dataOnRows?: boolean; grandTotalCaption?: string; errorCaption?: string; showError?: boolean; missingCaption?: string; showMissing?: boolean; pageStyle?: string; pivotTableStyle?: string; tag?: string; showItems?: boolean; editData?: boolean; disableFieldList?: boolean; showCalcMbrs?: boolean; visualTotals?: boolean; showMultipleLabel?: boolean; showDataDropDown?: boolean; showDrill?: boolean; printDrill?: boolean; showMemberPropertyTips?: boolean; showDataTips?: boolean; enableWizard?: boolean; enableDrill?: boolean; enableFieldProperties?: boolean; pageWrap?: number; pageOverThenDown?: boolean; subtotalHiddenItems?: boolean; fieldPrintTitles?: boolean; mergeItem?: boolean; showDropZones?: boolean; showEmptyRow?: boolean; showEmptyCol?: boolean; showHeaders?: boolean; published?: boolean; gridDropZones?: boolean; multipleFieldFilters?: boolean; rowHeaderCaption?: string; colHeaderCaption?: string; fieldListSortAscending?: boolean; mdxSubqueries?: boolean; customListSort?: boolean; asteriskTotals?: boolean; dataPosition?: number; immersive?: boolean; vacatedStyle?: string; calculatedItems?: CalculatedItemOptions[]; calculatedMembers?: CalculatedMemberOptions[]; pivotHierarchies?: PivotHierarchyOptions[]; pivotConditionalFormats?: PivotConditionalFormatOptions[]; chartFormats?: ChartFormatOptions[]; autoSortScope?: PivotAreaOptions; memberProperties?: MemberPropertyOptions[]; formats?: PivotFormatOptions[]; rowHierarchiesUsage?: HierarchyUsageOptions[]; colHierarchiesUsage?: HierarchyUsageOptions[]; locationColPageCount?: number; locationRowPageCount?: number; fieldOverrides?: PivotFieldOverrideOptions[]; } interface PivotFormatOptions { action?: "formatting" | "drill" | "formula" | "blank" | "subtotal" | "report"; dxfId?: number; pivotArea: PivotAreaOptions; } interface CalculatedItemOptions { field?: number; formula?: string; pivotArea?: PivotAreaOptions; } interface CalculatedMemberOptions { name: string; mdx: string; memberName?: string; hierarchy?: string; parent?: string; solveOrder?: number; set?: boolean; } interface PivotHierarchyOptions { outline?: boolean; multipleItemSelectionAllowed?: boolean; subtotalTop?: boolean; showInFieldList?: boolean; dragToRow?: boolean; dragToCol?: boolean; dragToPage?: boolean; dragToData?: boolean; dragOff?: boolean; includeNewItemsInFilter?: boolean; caption?: string; members?: MemberOptions[]; memberProperties?: MemberPropertyOptions[]; } interface MemberOptions { name: string; level?: number; } interface MemberPropertyOptions { field: number; name?: string; showCell?: boolean; showTip?: boolean; showAsCaption?: boolean; nameLen?: number; pPos?: number; pLen?: number; } interface PivotAreaOptions { field?: number; type?: "none" | "normal" | "data" | "all" | "origin" | "button" | "topEnd" | "topRight"; dataOnly?: boolean; labelOnly?: boolean; grandRow?: boolean; grandCol?: boolean; cacheIndex?: boolean; outline?: boolean; offset?: string; collapsedLevelsAreSubtotals?: boolean; axis?: "axisRow" | "axisCol" | "axisPage" | "axisValues"; fieldPosition?: number; references?: PivotAreaReferenceOptions[]; } interface PivotAreaReferenceOptions { field?: number; count?: number; selected?: boolean; byPosition?: boolean; relative?: boolean; defaultSubtotal?: boolean; sumSubtotal?: boolean; countASubtotal?: boolean; avgSubtotal?: boolean; maxSubtotal?: boolean; minSubtotal?: boolean; countSubtotal?: boolean; productSubtotal?: boolean; stdDevPSubtotal?: boolean; stdDevSubtotal?: boolean; varPSubtotal?: boolean; varSubtotal?: boolean; x?: number[]; } interface PivotConditionalFormatOptions { scope?: "selection" | "data" | "field"; type?: "none" | "all" | "row" | "column"; priority: number; pivotAreas?: PivotAreaOptions[]; } interface ChartFormatOptions { chart: number; format: number; series?: boolean; pivotArea?: PivotAreaOptions; } interface CacheHierarchyOptions { uniqueName: string; caption?: string; measure?: boolean; set?: boolean; parentSet?: number; iconSet?: number; attribute?: boolean; time?: boolean; keyAttribute?: boolean; defaultMemberUniqueName?: string; allUniqueName?: string; allCaption?: string; dimensionUniqueName?: string; displayFolder?: string; measureGroup?: string; measures?: boolean; count: number; oneField?: boolean; hidden?: boolean; memberValueDatatype?: "string" | "number" | "integer" | "boolean" | "error"; unbalanced?: boolean; unbalancedGroup?: boolean; groupLevels?: GroupLevelOptions[]; fieldsUsage?: FieldUsageOptions[]; } interface KpiOptions { uniqueName: string; caption?: string; displayFolder?: string; measureGroup?: string; parent?: string; value: string; goal?: string; status?: string; trend?: string; weight?: string; time?: string; } interface MeasureGroupOptions { name: string; caption: string; } interface SetOptions { count?: number; maxRank: number; setDefinition: string; sortType?: "none" | "ascending" | "descending" | "ascendingAlpha" | "descendingAlpha" | "ascendingNatural" | "descendingNatural"; queryFailed?: boolean; } interface ServerFormatOptions { culture?: string; format?: string; } interface FieldGroupOptions { parent?: number; base?: number; rangePr?: RangePropertiesOptions; discretePr?: number[]; groupItems?: string[]; } interface RangePropertiesOptions { autoStart?: boolean; autoEnd?: boolean; groupBy?: "range" | "seconds" | "minutes" | "hours" | "days" | "months" | "quarters" | "years"; startNum?: number; endNum?: number; startDate?: string; endDate?: string; groupInterval?: number; } interface PivotDimensionOptions { measure?: boolean; name: string; uniqueName: string; caption: string; } interface RangeSetOptions { i1?: number; i2?: number; i3?: number; i4?: number; ref?: string; name?: string; sheet?: string; rId?: string; } interface ConsolidationPageItemOptions { name: string; } interface ConsolidationPageOptions { items?: ConsolidationPageItemOptions[]; } interface ConsolidationOptions { autoPage?: boolean; pages?: ConsolidationPageOptions[]; rangeSets: RangeSetOptions[]; } interface TupleCacheEntryOptions { type: "m" | "n" | "e" | "s"; value?: number | string; } interface GroupMemberOptions { uniqueName: string; group?: boolean; } interface LevelGroupOptions { name: string; uniqueName: string; caption: string; uniqueParent?: string; id?: number; members: GroupMemberOptions[]; } interface GroupLevelOptions { uniqueName: string; caption: string; user?: boolean; customRollUp?: boolean; groups?: LevelGroupOptions[]; } interface FieldUsageOptions { value: number; } interface HierarchyUsageOptions { hierarchyUsage: number; } interface QueryCacheEntryOptions { mdx: string; tpls?: TupleOptions[]; } interface TupleOptions { items?: number[]; } interface MpMapOptions { x: number; } interface MeasureDimensionMapOptions { measureGroup?: number; dimension?: number; } interface OLAPPropertiesOptions { local?: string; localConnection?: string; sendLocale?: boolean; rowDrillCount?: number; colDrillCount?: number; localRefresh?: boolean; serverFill?: boolean; serverNumberFormat?: boolean; serverFont?: boolean; serverFontColor?: boolean; } interface PivotSourceData { fieldNames: string[]; records: (string | number | null | Date)[][]; } interface CacheFieldExtraAttrs { databaseField?: boolean; level?: number; mappingCount?: number; memberPropertyField?: number; propertyName?: string; serverField?: boolean; uniqueList?: boolean; containsMixedTypes?: boolean; containsNonDate?: boolean; longText?: boolean; maxDate?: string; minDate?: string; } interface PivotCacheDefinitionOptions { invalid?: boolean; saveData?: boolean; optimizeMemory?: boolean; enableRefresh?: boolean; refreshedBy?: string; refreshedDate?: number; refreshedDateIso?: string; backgroundQuery?: boolean; missingItemsLimit?: number; upgradeOnRefresh?: boolean; supportSubquery?: boolean; supportAdvancedDrill?: boolean; cacheHierarchies?: CacheHierarchyOptions[]; kpis?: KpiOptions[]; measureGroups?: MeasureGroupOptions[]; dimensions?: PivotDimensionOptions[]; sets?: SetOptions[]; serverFormats?: ServerFormatOptions[]; fieldGroups?: ReadonlyMap; consolidation?: ConsolidationOptions; entries?: TupleCacheEntryOptions[]; queryCache?: QueryCacheEntryOptions[]; mpMaps?: MpMapOptions[]; measureDimensionMaps?: MeasureDimensionMapOptions[]; cacheFieldOverrides?: ReadonlyMap; olapPr?: OLAPPropertiesOptions; } //#endregion //#region src/parts/shared-strings.d.ts type SstEntry = string | RichTextOptions; declare class SharedStrings { private entries; private indexMap; register(s: string): number; registerRich(rst: RichTextOptions): number; loadEntries(entries: SharedStringsDocOptions["entries"]): void; get count(): number; toDescriptorOptions(): { entries: SstEntry[]; uniqueCount: number; }; serialize(): string; } interface SharedStringsDocOptions { entries: (string | RichTextOptions)[]; uniqueCount: number; } declare const sharedStringsDesc: CustomDescriptor; //#endregion //#region src/parts/table.d.ts declare const TotalsRowFunction: { readonly NONE: "none"; readonly SUM: "sum"; readonly MIN: "min"; readonly MAX: "max"; readonly AVERAGE: "average"; readonly COUNT: "count"; readonly COUNT_NUMS: "countNums"; readonly STD_DEV: "stdDev"; readonly VAR: "var"; readonly CUSTOM: "custom"; }; type TotalsRowFunction = (typeof TotalsRowFunction)[keyof typeof TotalsRowFunction]; declare const TableType: { readonly WORKSHEET: "worksheet"; readonly XML: "xml"; readonly QUERY_TABLE: "queryTable"; }; type TableType = (typeof TableType)[keyof typeof TableType]; interface TableStyleInfoOptions { name?: string; showFirstColumn?: boolean; showLastColumn?: boolean; showRowStripes?: boolean; showColumnStripes?: boolean; } interface TableColumnOptions { name: string; totalsRowFunction?: TotalsRowFunction; totalsRowLabel?: string; calculatedColumnFormula?: string; totalsRowFormula?: string; totalsRowFormulaArray?: boolean; calculatedColumnFormulaArray?: boolean; uniqueName?: string; queryTableFieldId?: number; headerRowDxfId?: number; dataDxfId?: number; totalsRowDxfId?: number; headerRowCellStyle?: string; dataCellStyle?: string; totalsRowCellStyle?: string; } interface TableOptions { id: number; name?: string; displayName: string; ref: string; columns: TableColumnOptions[]; headerRowCount?: number; totalsRowCount?: number; totalsRowShown?: boolean; tableType?: TableType; style?: TableStyleInfoOptions; autoFilter?: string; insertRowShift?: boolean; published?: boolean; headerRowDxfId?: number; dataDxfId?: number; totalsRowDxfId?: number; headerRowBorderDxfId?: number; tableBorderDxfId?: number; totalsRowBorderDxfId?: number; headerRowCellStyle?: string; dataCellStyle?: string; totalsRowCellStyle?: string; } declare const tableDesc: CustomDescriptor; //#endregion //#region src/parts/worksheet.d.ts interface ColumnOptions { min: number; max: number; width?: number; hidden?: boolean; customWidth?: boolean; outlineLevel?: number; collapsed?: boolean; bestFit?: boolean; phonetic?: boolean; } interface RowOptions { cells?: CellOptions[]; height?: number | UniversalMeasure; hidden?: boolean; rowNumber?: number; spans?: string; customFormat?: boolean; thickTop?: boolean; thickBot?: boolean; ph?: boolean; } interface RichTextRunPropertiesOptions { font?: string; charset?: number; family?: number; bold?: boolean; italic?: boolean; strike?: boolean; outline?: boolean; shadow?: boolean; condense?: boolean; extend?: boolean; color?: string; size?: number; underline?: "single" | "double" | "singleAccounting" | "doubleAccounting" | "none"; vertAlign?: "superscript" | "subscript" | "baseline"; scheme?: "major" | "minor" | "none"; } interface RichTextRunOptions { properties?: RichTextRunPropertiesOptions; text: string; } interface PhoneticRunOptions { sb: number; eb: number; text: string; } interface RichTextOptions { text?: string; runs?: RichTextRunOptions[]; phonetics?: PhoneticRunOptions[]; } interface CellOptions { value?: string | number | boolean | Date | RichTextOptions | null; reference?: string; styleIndex?: number; style?: StyleOptions; formula?: FormulaOptions; } declare const FormulaType: { readonly NORMAL: "normal"; readonly ARRAY: "array"; readonly SHARED: "shared"; }; type FormulaType = (typeof FormulaType)[keyof typeof FormulaType]; interface FormulaOptions { formula: string; type?: FormulaType; reference?: string; sharedIndex?: number; aca?: boolean; dt2D?: boolean; dtr?: boolean; del1?: boolean; del2?: boolean; r1?: string; r2?: string; ca?: boolean; bx?: boolean; } interface ScenarioCellOptions { r: string; val: string | number; deleted?: boolean; undone?: boolean; } interface ScenarioDefinition { name: string; inputCells: ScenarioCellOptions[]; count?: number; user?: string; comment?: string; hidden?: boolean; locked?: boolean; } interface ScenarioOptions { scenarios: ScenarioDefinition[]; current?: number; show?: number; } interface MergeCellOptions { from: { row: number; col: number; }; to: { row: number; col: number; }; } interface SheetProtectionOptions { password?: string; algorithmName?: string; hashValue?: string; saltValue?: string; spinCount?: number; sheet?: boolean; objects?: boolean; scenarios?: boolean; formatCells?: boolean; formatColumns?: boolean; formatRows?: boolean; insertColumns?: boolean; insertRows?: boolean; insertHyperlinks?: boolean; deleteColumns?: boolean; deleteRows?: boolean; selectLockedCells?: boolean; sort?: boolean; autoFilter?: boolean; pivotTables?: boolean; selectUnlockedCells?: boolean; } interface ProtectedRangeOptions { sqref: string; name: string; password?: string; algorithmName?: string; hashValue?: string; saltValue?: string; spinCount?: number; securityDescriptor?: string; } interface FreezePaneOptions { row?: number; col?: number; } interface WorksheetImageOptions { data: DataType; type: "png" | "jpg"; col: number; row: number; } interface WorksheetChartOptions extends ChartSpaceOptions { col: number; row: number; } interface SheetViewOptions { showGridLines?: boolean; showRowColHeaders?: boolean; showZeros?: boolean; zoomScale?: number; tabSelected?: boolean; rightToLeft?: boolean; windowProtection?: boolean; showFormulas?: boolean; showRuler?: boolean; showOutlineSymbols?: boolean; defaultGridColor?: boolean; showWhiteSpace?: boolean; view?: "normal" | "pageBreakPreview" | "pageLayout"; colorId?: number; zoomScaleNormal?: number; zoomScaleSheetLayoutView?: number; zoomScalePageLayoutView?: number; pivotSelections?: PivotSelectionOptions[]; } interface PivotSelectionOptions { pane?: "bottomRight" | "topRight" | "bottomLeft" | "topLeft"; showHeader?: boolean; label?: boolean; data?: boolean; extendable?: boolean; count?: number; axis?: "axisRow" | "axisCol" | "axisPage" | "axisValues"; dimension?: number; start?: number; min?: number; max?: number; activeRow?: number; activeCol?: number; previousRow?: number; previousCol?: number; click?: number; rId?: string; } type HyperlinkTarget = { type: "external"; url: string; } | { type: "internal"; location: string; }; interface HyperlinkOptions { cell: string; target: HyperlinkTarget; tooltip?: string; display?: string; } interface HeaderFooterOptions { oddHeader?: string; oddFooter?: string; evenHeader?: string; evenFooter?: string; firstHeader?: string; firstFooter?: string; differentOddEven?: boolean; differentFirst?: boolean; scaleWithDoc?: boolean; alignWithMargins?: boolean; } type PageOrientation = "default" | "portrait" | "landscape"; interface PageSetupOptions { paperSize?: number; orientation?: PageOrientation; scale?: number; fitToWidth?: number; fitToHeight?: number; pageOrder?: "downThenOver" | "overThenDown"; useFirstPageNumber?: boolean; firstPageNumber?: number; paperHeight?: number | PositiveUniversalMeasure; paperWidth?: number | PositiveUniversalMeasure; usePrinterDefaults?: boolean; blackAndWhite?: boolean; draft?: boolean; cellComments?: "none" | "asDisplayed" | "atEnd"; errors?: "displayed" | "blank" | "dash" | "NA"; autoPageBreaks?: boolean; fitToPage?: boolean; } interface TabColorOptions { rgb?: string; theme?: number; tint?: number; indexed?: number; } interface ObjectAnchorOptions { moveWithCells?: boolean; sizeWithCells?: boolean; } interface CommentPropertiesOptions { locked?: boolean; defaultSize?: boolean; print?: boolean; disabled?: boolean; autoFill?: boolean; autoLine?: boolean; altText?: string; textHAlign?: "left" | "center" | "right" | "justify" | "distributed"; textVAlign?: "top" | "center" | "bottom" | "justify" | "distributed"; lockText?: boolean; justLastX?: boolean; autoScale?: boolean; anchor?: ObjectAnchorOptions; } interface CommentOptions { cell: string; author: string; text: string | RichTextOptions; commentPr?: CommentPropertiesOptions; } type DataValidationType = "none" | "whole" | "decimal" | "list" | "date" | "time" | "textLength" | "custom"; type DataValidationOperator = "between" | "notBetween" | "equal" | "notEqual" | "greaterThan" | "lessThan" | "greaterThanOrEqual" | "lessThanOrEqual"; interface DataValidationOptions { sqref: string; type?: DataValidationType; operator?: DataValidationOperator; formula1?: string; formula2?: string; allowBlank?: boolean; showErrorMessage?: boolean; errorTitle?: string; error?: string; showInputMessage?: boolean; promptTitle?: string; prompt?: string; errorStyle?: "stop" | "warning" | "information"; imeMode?: "noControl" | "on" | "off" | "disabled" | "hiragana" | "fullKatakana" | "halfKatakana" | "fullAlpha" | "halfAlpha" | "fullHangul" | "halfHangul"; showDropDown?: boolean; } type ConditionalFormatType = "cellIs" | "containsText" | "expression" | "top10" | "aboveAverage" | "colorScale" | "dataBar" | "iconSet"; type ConditionalFormatOperator = "lessThan" | "lessThanOrEqual" | "equal" | "notEqual" | "greaterThanOrEqual" | "greaterThan" | "between" | "notBetween" | "containsText" | "notContains" | "beginsWith" | "endsWith"; type CfvoType = "num" | "percent" | "max" | "min" | "formula" | "percentile"; interface CfvoOptions { type: CfvoType; val?: string | number; gte?: boolean; } type IconSetType = "3Arrows" | "3ArrowsGray" | "3Flags" | "3TrafficLights1" | "3TrafficLights2" | "3Signs" | "3Symbols" | "3Symbols2" | "4Arrows" | "4ArrowsGray" | "4RedToBlack" | "4Rating" | "4TrafficLights" | "5Arrows" | "5ArrowsGray" | "5Rating" | "5Quarters"; interface ColorScaleOptions { cfvo: CfvoOptions[]; colors: string[]; } interface DataBarOptions { cfvo: [CfvoOptions, CfvoOptions]; color: string; minLength?: number; maxLength?: number; showValue?: boolean; } interface IconSetOptions { cfvo: CfvoOptions[]; iconSet?: IconSetType; showValue?: boolean; percent?: boolean; reverse?: boolean; } interface ConditionalFormatRule { type: ConditionalFormatType; operator?: ConditionalFormatOperator; formulas?: string[]; priority?: number; dxfId?: number; colorScale?: ColorScaleOptions; dataBar?: DataBarOptions; iconSet?: IconSetOptions; stopIfTrue?: boolean; timePeriod?: "today" | "yesterday" | "tomorrow" | "last7Days" | "thisMonth" | "lastMonth" | "nextMonth" | "thisWeek" | "lastWeek" | "nextWeek"; rank?: number; equalAverage?: boolean; } interface ConditionalFormatOptions { sqref: string; rules: ConditionalFormatRule[]; } interface Top10FilterOptions { colId: number; top?: boolean; percent?: boolean; val: number; filterVal?: number; hiddenButton?: boolean; showButton?: boolean; } interface CustomFilterOptions { colId: number; operator?: "equal" | "notEqual" | "greaterThan" | "greaterThanOrEqual" | "lessThan" | "lessThanOrEqual"; val?: string; and?: boolean; val2?: string; hiddenButton?: boolean; showButton?: boolean; } interface SortCondition { ref: string; descending?: boolean; sortBy?: "value" | "cellColor" | "fontColor" | "icon"; customList?: string; iconId?: number; } interface AutoFilterOptions { ref: string; top10?: Top10FilterOptions[]; customFilters?: CustomFilterOptions[]; sort?: SortCondition[]; sortState?: SortStateOptions; colorFilters?: ColorFilterOptions[]; iconFilters?: IconFilterOptions[]; dynamicFilters?: DynamicFilterOptions[]; dateGroupItems?: DateGroupFilterOptions[]; filters?: FilterItemsOptions[]; } interface ColorFilterOptions { colId: number; dxfId?: number; cellColor?: boolean; } interface IconFilterOptions { colId: number; iconSet: number; iconId?: number; } interface FilterItemsOptions { colId: number; blank?: boolean; calendarType?: string; values?: string[]; } interface DynamicFilterOptions { colId: number; type: "null" | "aboveAverage" | "belowAverage" | "tomorrow" | "today" | "yesterday" | "nextWeek" | "thisWeek" | "lastWeek" | "nextMonth" | "thisMonth" | "lastMonth" | "nextQuarter" | "thisQuarter" | "lastQuarter" | "nextYear" | "thisYear" | "lastYear" | "yearToDate" | "Q1" | "Q2" | "Q3" | "Q4" | "M1" | "M2" | "M3" | "M4" | "M5" | "M6" | "M7" | "M8" | "M9" | "M10" | "M11" | "M12"; val?: number; maxVal?: number; valIso?: string; maxValIso?: string; } interface DateGroupFilterOptions { colId: number; dateTimeGrouping: "year" | "month" | "day" | "hour" | "minute" | "second"; year?: number; month?: number; day?: number; hour?: number; minute?: number; second?: number; } interface SortStateOptions { columnSort?: boolean; caseSensitive?: boolean; sortMethod?: "pinYin" | "stroke"; } interface PrintOptions { horizontalCentered?: boolean; verticalCentered?: boolean; headings?: boolean; gridLines?: boolean; gridLinesSet?: boolean; } interface SheetFormatPropertiesOptions { baseColWidth?: number; defaultColWidth?: number; defaultRowHeight?: number; zeroHeight?: boolean; thickTop?: boolean; thickBottom?: boolean; outlineLevelRow?: number; outlineLevelCol?: number; } interface SheetPropertiesOptions { syncHorizontal?: boolean; syncVertical?: boolean; syncRef?: string; transitionEvaluation?: boolean; transitionEntry?: boolean; published?: boolean; filterMode?: boolean; enableFormatConditionsCalculation?: boolean; outlineApplyStyles?: boolean; outlineShowSymbols?: boolean; outlineSummaryBelow?: boolean; outlineSummaryRight?: boolean; } interface IgnoredErrorOptions { sqref: string; evalError?: boolean; twoDigitTextYear?: boolean; numberStoredAsText?: boolean; formula?: boolean; formulaRange?: boolean; unlockedFormula?: boolean; emptyCellReference?: boolean; listDataValidation?: boolean; calculatedColumn?: boolean; } interface PhoneticPropertiesOptions { fontId: number; type?: "fullwidthKatakana" | "halfwidthKatakana" | "Hiragana" | "noConversion"; alignment?: "left" | "center" | "distributed"; } interface SheetBackgroundImageOptions { data: DataType; type: "png" | "jpg"; } interface PageBreakOptions { id: number; min?: number; max?: number; manual?: boolean; pivot?: boolean; } interface SelectionOptions { pane?: "bottomRight" | "topRight" | "bottomLeft" | "topLeft"; activeCell?: string; activeCellId?: number; sqref?: string; } interface CustomSheetViewOptions { guid: string; scale?: number; showPageBreaks?: boolean; showFormulas?: boolean; showGridLines?: boolean; showRowColHeaders?: boolean; outlineSymbols?: boolean; zeroValues?: boolean; fitToPage?: boolean; printArea?: boolean; filter?: boolean; showAutoFilter?: boolean; hiddenRows?: boolean; hiddenColumns?: boolean; state?: "visible" | "hidden" | "veryHidden"; filterUnique?: boolean; view?: "normal" | "pageBreakPreview" | "pageLayout"; } interface CellWatchOptions { r: string; } interface DataConsolidateOptions { function?: "average" | "count" | "countNums" | "max" | "min" | "product" | "stdDev" | "stdDevp" | "sum" | "var" | "varp"; topLabels?: boolean; leftLabels?: boolean; startLabels?: boolean; link?: boolean; refs?: string[]; } interface DrawingHfOptions { rId: string; lho?: number; lhe?: number; lhf?: number; cho?: number; che?: number; chf?: number; rho?: number; rhe?: number; rhf?: number; lfo?: number; lfe?: number; lff?: number; cfo?: number; cfe?: number; cff?: number; rfo?: number; rfe?: number; rff?: number; } interface WorksheetOptions { name?: string; rows?: RowOptions[]; columns?: ColumnOptions[]; mergeCells?: MergeCellOptions[]; freezePanes?: FreezePaneOptions; protection?: SheetProtectionOptions; protectedRanges?: ProtectedRangeOptions[]; scenarios?: ScenarioOptions; autoFilter?: string | AutoFilterOptions; images?: WorksheetImageOptions[]; charts?: WorksheetChartOptions[]; dataValidations?: DataValidationOptions[]; dataValidationsDisablePrompts?: boolean; conditionalFormats?: ConditionalFormatOptions[]; hyperlinks?: HyperlinkOptions[]; comments?: CommentOptions[]; headerFooter?: HeaderFooterOptions; pageSetup?: PageSetupOptions; tabColor?: TabColorOptions; sheetView?: SheetViewOptions; pivotTables?: PivotTableOptions[]; tables?: TableOptions[]; ignoredErrors?: IgnoredErrorOptions[]; phoneticPr?: PhoneticPropertiesOptions; backgroundImage?: SheetBackgroundImageOptions; printOptions?: PrintOptions; sheetFormatPr?: SheetFormatPropertiesOptions; sheetPr?: SheetPropertiesOptions; rowBreaks?: PageBreakOptions[]; colBreaks?: PageBreakOptions[]; customSheetViews?: CustomSheetViewOptions[]; cellWatches?: CellWatchOptions[]; dataConsolidate?: DataConsolidateOptions; oleSize?: string; drawingHF?: DrawingHfOptions; legacyDrawingHF?: string; selection?: SelectionOptions; sheetCalcPr?: SheetCalculationPropertiesOptions; ext?: string; controls?: ControlOptions[]; customProperties?: CustomPropertyOptions$1[]; oleObjects?: OleObjectOptions[]; webPublishItems?: WebPublishItemOptions[]; } interface SheetCalculationPropertiesOptions { fullCalcOnLoad?: boolean; } interface ControlOptions { shapeId: number; rId: string; name?: string; locked?: boolean; uiObject?: boolean; recalcAlways?: boolean; linkedCell?: string; listFillRange?: string; cf?: string; } interface CustomPropertyOptions$1 { name: string; rId: string; } interface OleObjectOptions { progId?: string; dvAspect?: "DVASPECT_CONTENT" | "DVASPECT_ICON"; link?: string; oleUpdate?: "OLEUPDATE_ALWAYS" | "OLEUPDATE_ONCALL"; autoLoad?: boolean; shapeId: number; rId?: string; objectPr?: OleObjectPropertiesOptions; } interface OleObjectPropertiesOptions { locked?: boolean; defaultSize?: boolean; print?: boolean; disabled?: boolean; uiObject?: boolean; autoFill?: boolean; autoLine?: boolean; autoPict?: boolean; macro?: string; altText?: string; dde?: boolean; rId?: string; } interface WebPublishItemOptions { id: number; divId: string; sourceType: "sheet" | "printArea" | "autoFilter" | "range" | "chart" | "pivotTable" | "query" | "label"; sourceRef?: string; sourceObject?: string; destinationFile: string; title?: string; autoRepublish?: boolean; } interface WorksheetContext { sharedStrings?: SharedStrings; styles?: Styles; } declare const worksheetDesc: CustomDescriptor; declare function stringifyWorksheet(opts: WorksheetOptions, ctx: WorksheetContext): string; //#endregion export { DxfOptions as $, TableColumnOptions as A, PivotAreaOptions as B, SheetBackgroundImageOptions as C, WorksheetOptions as D, WorksheetContext as E, tableDesc as F, PivotSourceData as G, PivotDataField as H, SharedStrings as I, BorderOptions as J, PivotTableOptions as K, SharedStringsDocOptions as L, TableStyleInfoOptions as M, TableType as N, stringifyWorksheet as O, TotalsRowFunction as P, CustomTableStyleOptions as Q, sharedStringsDesc as R, ScenarioOptions as S, WorksheetChartOptions as T, PivotFilterOptions as U, PivotCacheDefinitionOptions as V, PivotFilterType as W, ColorsOptions as X, BorderSideOptions as Y, CustomCellStyleOptions as Z, PhoneticPropertiesOptions as _, ColumnOptions as a, StylesDocOptions as at, ScenarioCellOptions as b, ConditionalFormatRule as c, FormulaOptions as d, FillOptions as et, FreezePaneOptions as f, MergeCellOptions as g, IgnoredErrorOptions as h, ColorScaleOptions as i, Styles as it, TableOptions as j, worksheetDesc as k, DataBarOptions as l, IconSetType as m, CfvoOptions as n, StyleExtensionOptions as nt, CommentOptions as o, StylesParseResult as ot, IconSetOptions as p, AlignmentOptions as q, CfvoType as r, StyleOptions as rt, ConditionalFormatOptions as s, stylesDesc as st, CellOptions as t, FontOptions as tt, DataValidationOptions as u, ProtectedRangeOptions as v, SheetProtectionOptions as w, ScenarioDefinition as x, RowOptions as y, ConsolidateFunction as z }; //# sourceMappingURL=worksheet-C9CP2B97.d.mts.map