Interface XlsxStreamReaderWorkBook
interface XlsxStreamReaderWorkBook {
abortBook: boolean;
formatCodes: { [key: string]: any };
hasFormatCodes: boolean;
options: OpenXlsxOptions;
parsedSharedStrings: boolean;
ready: Promise<void>;
source: UnpackArchiveResult;
waitingWorkSheets: {
name: string;
path: string;
sheetNo: string;
sheetPath: string;
}[];
workBookInfo: WorkBookInfo;
workBookSharedStrings: any[];
workBookStyles: any[];
xfs: any;
_getSharedString(stringIndex: number): any;
_getSheetName(sheetPath: string): string;
_parseSharedStrings(nodeData: any[]): void;
_parseStyles(nodeData: any[]): void;
_parseWorkBookInfo(nodeData: any[], workBookInfo: WorkBookInfo): void;
_parseWorkBookRels(nodeData: any[], workBookInfo: WorkBookInfo): void;
_parseXML(
entry: UnpackArchiveDirectory | UnpackArchiveFile,
entryHandler: (this: XlsxStreamReaderWorkBook, node: any) => void,
__namedParameters?: { trim: boolean },
): Promise<void>;
abort(): void;
end(): XlsxStreamReaderWorkBook;
getFormat(numFmt: number): any;
getSheets(): { name: string; sheetPath: string }[];
openSheet(sheet: string | number): XlsxStreamReaderWorkSheet;
readyForStreaming(): Promise<void>;
write(): boolean;
}
abortBook: boolean;
formatCodes: { [key: string]: any };
hasFormatCodes: boolean;
options: OpenXlsxOptions;
parsedSharedStrings: boolean;
ready: Promise<void>;
source: UnpackArchiveResult;
waitingWorkSheets: {
name: string;
path: string;
sheetNo: string;
sheetPath: string;
}[];
workBookInfo: WorkBookInfo;
workBookSharedStrings: any[];
workBookStyles: any[];
xfs: any;
_getSharedString(stringIndex: number): any;
_getSheetName(sheetPath: string): string;
_parseSharedStrings(nodeData: any[]): void;
_parseStyles(nodeData: any[]): void;
_parseWorkBookInfo(nodeData: any[], workBookInfo: WorkBookInfo): void;
_parseWorkBookRels(nodeData: any[], workBookInfo: WorkBookInfo): void;
_parseXML(
entry: UnpackArchiveDirectory | UnpackArchiveFile,
entryHandler: (this: XlsxStreamReaderWorkBook, node: any) => void,
__namedParameters?: { trim: boolean },
): Promise<void>;
abort(): void;
end(): XlsxStreamReaderWorkBook;
getFormat(numFmt: number): any;
getSheets(): { name: string; sheetPath: string }[];
openSheet(sheet: string | number): XlsxStreamReaderWorkSheet;
readyForStreaming(): Promise<void>;
write(): boolean;
}
Index
Properties
Methods
Properties
abort
abortBook: boolean
format
formatCodes: { [key: string]: any }
has
hasFormatCodes: boolean
options
parsed
parsedSharedStrings: boolean
ready
ready: Promise<void>
source
waiting
waitingWorkSheets: {
name: string;
path: string;
sheetNo: string;
sheetPath: string;
}[]
name: string;
path: string;
sheetNo: string;
sheetPath: string;
}[]
work
workBookInfo: WorkBookInfo
work
workBookSharedStrings: any[]
work
workBookStyles: any[]
xfs
xfs: any
Methods
_
Parameters
- stringIndex: number
Returns any
_
Parameters
- sheetPath: string
Returns string
_
Parameters
- nodeData: any[]
Returns void
_
Parameters
- nodeData: any[]
Returns void
_
Parameters
- nodeData: any[]
- workBookInfo: WorkBookInfo
Returns void
_
Parameters
- nodeData: any[]
- workBookInfo: WorkBookInfo
Returns void
_
- _parseXML(
entry: UnpackArchiveDirectory | UnpackArchiveFile,
entryHandler: (this: XlsxStreamReaderWorkBook, node: any) => void,
__namedParameters?: { trim: boolean },
): Promise<void>Parameters
- entry: UnpackArchiveDirectory | UnpackArchiveFile
- entryHandler: (this: XlsxStreamReaderWorkBook, node: any) => void
- __namedParameters: { trim: boolean } = ...
Returns Promise<void>
abort
Returns void
end
Returns XlsxStreamReaderWorkBook
get
Parameters
- numFmt: number
Returns any
get
Returns { name: string; sheetPath: string }[]
open
Parameters
- sheet: string | number
Sheet index (0-based) or name
Returns XlsxStreamReaderWorkSheet
- sheet: string | number
ready
Returns Promise<void>
write
Returns boolean
Open a sheet