node-xlsx

const _default: {
    parse: <T = any[]>(
        mixed: unknown,
        options?: Sheet2JSONOpts & ParsingOptions
    ) => { name: string; data: T[] }[];
    parseMetadata: (
        mixed: unknown,
        options?: ParsingOptions
    ) => { name: string; data: Range | null }[];
    build: (
        worksheets: WorkSheet<unknown>[],
        { parseOptions, writeOptions, sheetOptions, ...otherOptions }?: BuildOptions
    ) => Buffer;
};

build: (
    worksheets: WorkSheet[],
    { parseOptions, writeOptions, sheetOptions, ...otherOptions }?: BuildOptions
) => Buffer;

parse: <T = any[]>(
    mixed: unknown,
    options?: Sheet2JSONOpts & ParsingOptions
) => { name: string; data: T[] }[];

parseMetadata: (
    mixed: unknown,
    options?: ParsingOptions
) => { name: string; data: Range | null }[];

type BuildOptions = WorkSheetOptions & {
    parseOptions?: AOA2SheetOpts;
    writeOptions?: WritingOptions;
    sheetOptions?: WorkSheetOptions;
};

type WorkSheet<T = unknown> = {
    name: string;
    data: T[][];
    options: WorkSheetOptions;
};

type WorkSheetOptions = {
    /** Column Info */
    '!cols'?: ColInfo[];
    /** Row Info */
    '!rows'?: RowInfo[];
    /** Merge Ranges */
    '!merges'?: Range[];
    /** Worksheet Protection info */
    '!protect'?: ProtectInfo;
    /** AutoFilter info */
    '!autofilter'?: AutoFilterInfo;
};