/// <reference types="node" />
/// <reference types="node" />
import { Transform, TransformCallback } from "stream";
import { Worksheet, stream, Column, Workbook, Style } from "exceljs";
export interface ExcelStreamOptions {
    stream?: import('stream').Stream;
    useSharedStrings?: boolean;
    useStyles?: boolean;
}
export interface ExcelWorkSheetInfo {
    name: string;
    columns: Column[];
}
export interface ExcelWorkBookOptions {
    category?: string;
    company?: string;
    creator?: string;
    description?: string;
    keywords?: string;
    lastModifiedBy?: string;
    created?: Date;
    manager?: string;
    modified?: Date;
    lastPrinted?: Date;
    subject?: string;
    title?: string;
}
export interface ExcelDataInfo {
    sheetName: string;
    row: any;
}
export interface ExcelParseInfo {
    colName: string;
    targetIndex: number | Array<number>;
    convertFunction?: Function;
}
export interface ExcelParseSheetInfo {
    rowStartIdx?: number;
    colStartIdx?: number;
    rowEndIdx?: number;
    colEndIdx?: number;
    parseInfo?: Array<ExcelParseInfo>;
}
export declare class ExcelExport {
    fileName: string;
    workbookOptions: ExcelWorkBookOptions;
    sheetInfos: any[];
    defaultWorksheetOption: any;
    workbook: Workbook;
    worksheetArr: Map<string, Worksheet>;
    constructor(fileName: string, workbookOptions: ExcelWorkBookOptions, sheetInfos: any[], defaultWorksheetOption: any);
    private getDefaultCellStyle;
    addRow(data: ExcelDataInfo): void;
    addRows(datas: ExcelDataInfo[]): void;
    export(res: any): Promise<void>;
}
export interface ExcelExportMerge {
    cellStart?: string;
    cellEnd?: string;
    rowStart?: number;
    colStart?: number;
    rowEnd?: number;
    colEnd?: number;
}
export interface ExcelHeaderValue {
    index: number;
    value: string;
}
export interface ExcelHeaderStyleInfo {
    index: number;
    style: Partial<Style>;
}
export interface ExcelExportHeaderInfo {
    value?: Array<Partial<ExcelHeaderValue>> | string;
    merge?: ExcelExportMerge;
    style?: Partial<Style> | Array<Partial<ExcelHeaderStyleInfo>>;
}
export interface ExcelExportInfo {
    name?: string;
    headers?: Array<Partial<ExcelExportHeaderInfo> | string>;
    columns?: Array<Partial<Column>>;
    dataFunction?: Function;
}
export declare class ExcelExportTransform extends Transform {
    fileName: string;
    transformOption: ExcelStreamOptions;
    sheetInfo: ExcelExportInfo;
    workbook?: stream.xlsx.WorkbookWriter;
    worksheet?: Worksheet;
    constructor(fileName: string, res: any, transformOption: ExcelStreamOptions, sheetInfo: ExcelExportInfo);
    private getDefaultCellStyle;
    _transform(data: any, encoding: BufferEncoding, callback: TransformCallback): void;
    _flush(done: TransformCallback): void;
}
export declare class ExcelImport {
    workbook: Workbook;
    target?: Express.Multer.File | string;
    constructor(target?: Express.Multer.File | string);
    private parseRow;
    parse(parseInfo?: Array<ExcelParseSheetInfo>, sheetIdxArr?: Array<number>): Promise<Array<string | number> | Array<object>>;
}
//# sourceMappingURL=ExcelUtils.d.ts.map