Buffer

Parse a binary buffer (XLSX, XLS, or ODS) into the Data structure expected by @graphysdk/core.

fromBuffer

import { fromBuffer } from '@graphysdk/data-import-utils/buffer';

const data = await fromBuffer(xlsxBuffer, 'xlsx');
const data = await fromBuffer(odsBuffer, 'ods', { sheet: 'Revenue' });

Signature

function fromBuffer(
  input: ArrayBuffer,
  format: 'xlsx' | 'xls' | 'ods',
  options?: SpreadsheetParseOptions
): Promise<Data>

Options

format

BinaryFileFormat

required

The binary format: 'xlsx', 'xls', or 'ods'.

options.sheet

string | number

default:"0"

Sheet to parse — name (string) or 0-based index (number).

options.locale

VizLocale

default:"EN_US"

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

options.maxFileSize

number

default:"5"

Maximum allowed input size in megabytes.

options.maxRows

number

default:"100000"

Maximum number of data rows to process.

options.maxCells

number

default:"5000000"

Maximum total cells to process.

Examples

Parse an uploaded spreadsheet

import { fromBuffer } from '@graphysdk/data-import-utils/buffer';

const file: File = input.files[0];
const buffer = await file.arrayBuffer();
const data = await fromBuffer(buffer, 'xlsx');

Select a specific sheet

import { fromBuffer } from '@graphysdk/data-import-utils/buffer';

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

Get Started

Sources

Formats

fromBuffer

Signature

Options

Examples

Parse an uploaded spreadsheet

Select a specific sheet

​fromBuffer

​Signature

​Options

​Examples

​Parse an uploaded spreadsheet

​Select a specific sheet

fromBuffer

Signature

Options

Examples

Parse an uploaded spreadsheet

Select a specific sheet