# XlsxOpenOptions

## Content

# Type Alias: XlsxOpenOptions

```ts
type XlsxOpenOptions = object;
```

Options to open the XLSX file.

## Properties

### keepColumnGroups?

```ts
optional keepColumnGroups?: boolean;
```

Optional. Whether to show the column groups when loading a XLSX file. The default value is true.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepColumnGroups: false});
```

***

### keepRowGroups?

```ts
optional keepRowGroups?: boolean;
```

Optional. Whether to show the row groups when loading a XLSX file. The default value is true.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepRowGroups: false});
```

***

### password?

```ts
optional password?: string;
```

Optional. For decrypting password-protected XLSX file.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {password: "123"});
```

***

### showFilters?

```ts
optional showFilters?: boolean;
```

Optional. Whether to show the filters in XLSX file. The default value is true.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showFilters: false});
```

***

### showHiddenColumns?

```ts
optional showHiddenColumns?: boolean;
```

Optional. Whether to show the hidden columns in XLSX file. The default value is false.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenColumns: true});
```

***

### showHiddenRows?

```ts
optional showHiddenRows?: boolean;
```

Optional. Whether to show the hidden rows in XLSX file. The default value is false.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenRows: true});
```

***

### showHiddenSheets?

```ts
optional showHiddenSheets?: boolean;
```

Optional. Whether to show the hidden and very hidden sheets in XLSX file. The default value is false.

#### Example

```javascript
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenSheets: true});
```