Type Alias ReadExcelOptions

ReadExcelOptions: IoLoadOptions & {
    header?: number | boolean;
    names?: string[];
    nRows?: number;
    nullValues?: string | string[];
    sheet?: string | number;
    sheetName?: string | number;
    skipRows?: number;
    usecols?: (string | number)[];
}

Type Declaration

Optionalheader?: number | boolean

Header row (default 0). false = no header.
Optionalnames?: string[]
OptionalnRows?: number
OptionalnullValues?: string | string[]
Optionalsheet?: string | number

Sheet by name or 0-based index (default 0).
OptionalsheetName?: string | number

Alias of sheet.
OptionalskipRows?: number
Optionalusecols?: (string | number)[]

Column names or indices to keep.

Type Alias ReadExcelOptions

Type Declaration

`Optional`header?: number | boolean

`Optional`names?: string[]

`Optional`nRows?: number

`Optional`nullValues?: string | string[]

`Optional`sheet?: string | number

`Optional`sheetName?: string | number

`Optional`skipRows?: number

`Optional`usecols?: (string | number)[]

Settings

Type Alias ReadExcelOptions

Type Declaration

Optionalheader?: number | boolean

Optionalnames?: string[]

OptionalnRows?: number

OptionalnullValues?: string | string[]

Optionalsheet?: string | number

OptionalsheetName?: string | number

OptionalskipRows?: number

Optionalusecols?: (string | number)[]

Settings

`Optional`header?: number | boolean

`Optional`names?: string[]

`Optional`nRows?: number

`Optional`nullValues?: string | string[]

`Optional`sheet?: string | number

`Optional`sheetName?: string | number

`Optional`skipRows?: number

`Optional`usecols?: (string | number)[]