# SpreadsheetLib

| Functions                                            |                                   |
| ---------------------------------------------------- | --------------------------------- |
| destory(tabid)                                       |                                   |
| hideUI(tabid)                                        |                                   |
| hideGridLines(tabid)                                 |                                   |
| clear(sheet) ⇒ `void`                                |                                   |
| setTagValue(sheet, tagID, value) ⇒ `void`            |                                   |
| findTag(sheet, tagID) ⇒ `*`                          |                                   |
| showAsPDF(source, target) ⇒ `Type.Promise`           |                                   |
| captureAsPdf(sheet, \[pdfOptions]) ⇒ `*`             |                                   |
| send(source, email) ⇒ `Type.Promise`                 |                                   |
| create(parameters) ⇒ `Type.Promise`                  | Create a new new sheet.           |
| remove(target) ⇒ `void`                              | Remove a sheet.                   |
| getReference(target) ⇒ `Type.Spreadsheet`            | Get a reference to a spreadsheet. |
| loadSheetFromDataArray(target, name, sheet) ⇒ `void` |                                   |
| convertDataArrayToSheetRows(dataRows) ⇒ `*`          |                                   |
| createColumnFormats(dataRows) ⇒ `Array.<any>`        |                                   |
| xyToA1(row, col) ⇒ `string`                          |                                   |
| a1ToXy(ref) ⇒ `*`                                    |                                   |

## destory(tabid)

**Params**

* tabid `string`

## hideUI(tabid)

**Params**

* tabid `string`

## hideGridLines(tabid)

**Params**

* tabid `string`

## clear(sheet) ⇒ `void`

**Params**

* sheet `any`

## setTagValue(sheet, tagID, value) ⇒ `void`

**Params**

* sheet `kendo.spreadsheet.Sheet`
* tagID `any`
* value `any`

## findTag(sheet, tagID) ⇒ `*`

**Params**

* sheet `kendo.spreadsheet.Sheet`
* tagID `any`

## showAsPDF(source, target) ⇒ `Type.Promise`

**Params**

* source `string` | `object` - Element id (as string) or sheet object.
* target `string` - Destination element id for the pdf.

## captureAsPdf(sheet, \[pdfOptions]) ⇒ `*`

**Params**

* sheet `kendo.spreadsheet.Sheet`
* \[pdfOptions] `Type.PdfOptions`

## send(source, email) ⇒ `Type.Promise`

**Params**

* source `string` | `object` - source Source element or sheet object.
* email `Type.EmailParameters`

## create(parameters) ⇒ `Type.Promise`

Create a new new sheet.

**Params**

* parameters `Type.Options`

## remove(target) ⇒ `void`

Remove a sheet.

**Params**

* target `string`

## getReference(target) ⇒ `Type.Spreadsheet`

Get a reference to a spreadsheet.

**Params**

* target `string`

## loadSheetFromDataArray(target, name, sheet) ⇒ `void`

**Params**

* target `string`
* name `any`
* sheet `any`

## convertDataArrayToSheetRows(dataRows) ⇒ `*`

**Params**

* dataRows `Array.<any>`

## createColumnFormats(dataRows) ⇒ `Array.<any>`

**Params**

* dataRows `any`

## xyToA1(row, col) ⇒ `string`

**Params**

* row `any`
* col `any`

## a1ToXy(ref) ⇒ `*`

**Params**

* ref `string`