excel-generator.d.ts•3.45 kB
/**
* Excel Generator - Create and manipulate Excel workbooks using ExcelJS
*/
import type { ExcelWorkbookOptions, ExcelFormula, ExcelChart, ExcelPivotTable, ExcelConditionalFormattingRule, ExcelDataValidation, ExcelCellStyle } from '../types.js';
export declare class ExcelGenerator {
createWorkbook(options: ExcelWorkbookOptions): Promise<Buffer>;
addPivotTable(filename: string, sheetName: string, pivotTable: ExcelPivotTable): Promise<Buffer>;
addChart(filename: string, sheetName: string, chart: ExcelChart): Promise<Buffer>;
addFormulas(filename: string, sheetName: string, formulas: ExcelFormula[]): Promise<Buffer>;
addConditionalFormatting(filename: string, sheetName: string, range: string, rules: ExcelConditionalFormattingRule[]): Promise<Buffer>;
addDataValidation(filename: string, sheetName: string, range: string, validation: ExcelDataValidation): Promise<Buffer>;
freezePanes(filename: string, sheetName: string, row?: number, column?: number): Promise<Buffer>;
filterSort(filename: string, sheetName: string, range?: string, sortBy?: {
column: string | number;
descending?: boolean;
}[], autoFilter?: boolean): Promise<Buffer>;
formatCells(filename: string, sheetName: string, range: string, style: ExcelCellStyle): Promise<Buffer>;
addNamedRange(filename: string, name: string, range: string, sheetName?: string): Promise<Buffer>;
protectSheet(filename: string, sheetName: string, password?: string, options?: any): Promise<Buffer>;
mergeWorkbooks(files: string[], outputFilename: string): Promise<Buffer>;
findReplace(filename: string, find: string, replace: string, sheetName?: string, matchCase?: boolean, matchEntireCell?: boolean, searchFormulas?: boolean): Promise<Buffer>;
convertToJSON(excelPath: string, sheetName?: string, header?: boolean): Promise<string>;
convertToCSV(excelPath: string, sheetName?: string): Promise<string>;
private loadWorkbook;
private applyRowStyle;
private normalizeColor;
private columnToNumber;
addSparklines(filename: string, sheetName: string, dataRange: string, location: string, type: 'line' | 'column' | 'winLoss', options?: any): Promise<Buffer>;
addArrayFormulas(filename: string, sheetName: string, formulas: Array<{
cell: string;
formula: string;
}>): Promise<Buffer>;
addSubtotals(filename: string, sheetName: string, range: string, groupBy: number, summaryFunction: 'SUM' | 'COUNT' | 'AVERAGE' | 'MAX' | 'MIN', summaryColumns: number[]): Promise<Buffer>;
addHyperlinks(filename: string, sheetName: string, links: Array<{
cell: string;
url?: string;
sheet?: string;
range?: string;
tooltip?: string;
displayText?: string;
}>): Promise<Buffer>;
addAdvancedChart(filename: string, sheetName: string, chart: {
type: 'waterfall' | 'funnel' | 'treemap' | 'sunburst' | 'histogram' | 'boxWhisker' | 'pareto';
title: string;
dataRange: string;
position?: {
row: number;
col: number;
};
}): Promise<Buffer>;
addSlicers(filename: string, sheetName: string, tableName: string, slicers: Array<{
columnName: string;
caption?: string;
position?: {
row: number;
col: number;
};
}>): Promise<Buffer>;
private numberToColumn;
}
//# sourceMappingURL=excel-generator.d.ts.map