> ## Documentation Index
> Fetch the complete documentation index at: https://docs.graphy.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# XLSX

Parse XLSX spreadsheet files into the `{ columns, rows }` [Data structure](/sdk/core/data-structure) used by Graphy agents and chart configs.

## fromXLSX

```typescript theme={null}
import { fromXLSX } from '@graphysdk/data-import-utils/xlsx';

const buffer = await file.arrayBuffer();
const data = await fromXLSX(buffer);
```

### Signature

```typescript theme={null}
function fromXLSX(
  input: ArrayBuffer,
  options?: SpreadsheetParseOptions
): Promise<Data>
```

## Options

<ParamField path="sheet" type="string | number" default="0">
  Sheet to parse. Pass a sheet name (`string`) or a 0-based index (`number`).
  Defaults to the first sheet.
</ParamField>

<ParamField path="locale" type="VizLocale" default="EN_US">
  Locale for number parsing. Determines thousand/decimal separator conventions.
</ParamField>

<ParamField path="maxFileSize" type="number" default="5">
  Maximum allowed input size in megabytes. Throws an error if the input exceeds this limit.
</ParamField>

<ParamField path="maxRows" type="number" default="100000">
  Maximum number of data rows to process. Throws an error if the sheet contains more rows.
</ParamField>

<ParamField path="maxCells" type="number" default="5000000">
  Maximum total cells (rows x columns) to process. Throws an error if the limit is exceeded.
</ParamField>

## Examples

### Select Sheet by Name

```typescript theme={null}
const data = await fromXLSX(buffer, { sheet: 'Revenue' });
```

### Select Sheet by Index

```typescript theme={null}
const data = await fromXLSX(buffer, { sheet: 2 }); // Third sheet (0-indexed)
```

## 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` |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.