XLS

Parse XLS spreadsheet files into the { columns, rows } Data structure used by Graphy agents and chart configs.

fromXLS

import { fromXLS } from '@graphysdk/data-import-utils/xls';

const buffer = await file.arrayBuffer();
const data = await fromXLS(buffer);

Signature

function fromXLS(
  input: ArrayBuffer,
  options?: SpreadsheetParseOptions
): Promise<Data>

Options

string | number

default:"0"

Sheet to parse. Pass a sheet name (string) or a 0-based index (number). Defaults to the first sheet.

VizLocale

default:"EN_US"

Locale for number parsing. Determines thousand/decimal separator conventions.

number

default:"5"

Maximum allowed input size in megabytes. Throws an error if the input exceeds this limit.

number

default:"100000"

Maximum number of data rows to process. Throws an error if the sheet contains more rows.

number

default:"5000000"

Maximum total cells (rows x columns) to process. Throws an error if the limit is exceeded.

Examples

Select Sheet by Name

const data = await fromXLS(buffer, { sheet: 'Revenue' });

Cell Value Handling

Cell type	Result
Number	`number`
String	`string`
Boolean	`1` or `0`
Date	ISO 8601 string
Formula	Computed result
Rich text	Plain text
Empty	`null`

fromXLS uses the same XLSX-based parser under the hood. It works with modern .xls files that are actually in XLSX format (common in Excel 2007+). Genuine legacy binary XLS (BIFF) format is not supported.

Get Started

Sources

Formats

fromXLS

Signature

Options

Examples

Select Sheet by Name

Cell Value Handling

​fromXLS

​Signature

​Options

​Examples

​Select Sheet by Name

​Cell Value Handling

fromXLS

Signature

Options

Examples

Select Sheet by Name

Cell Value Handling