Skip to main content
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' });