neoExcel
Create Excel files on the fly.
Based on:
https://github.com/jiteshkumawat/oxml.js
Sample App:
https://visualneo.com/tutorials/neoexcel
neoExcelCreate
|
Purpose: |
Create a new Excel document to start working |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelCreate "docName"
docName Ducument name |
neoExcelAddSheet
|
Purpose: |
Add a new sheet to the document. |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelAddSheet "docName" "sheetName" "sheetTitle"
docName Document name sheetName Sheet name sheetTitle Sheet title |
neoExcelSetCellText
|
Purpose: |
Set cell text |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetCellText "docName" "sheetName" theRow theColumn "theValue"
docName Document name sheetName Sheet name theRow Row number theColumn Column number theValue Cell text |
neoExcelSetCellValue
|
Purpose: |
Set cell numeric value |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetCellValue "docName" "sheetName" theRow theColumn theValue
docName Document name sheetName Sheet name theRow Row number theColumn Column number theValue Numeric value |
neoExcelSetCellFormula
|
Purpose: |
Set cell math formula |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetCellFormula "docName" "sheetName" theRow theColumn "theFormula "theValue"
docName Document name sheetName Sheet name theRow Row number theColumn Column number "theFormula Cell math formula" theValue Value (optional) |
neoExcelSharedFormula
|
Purpose: |
Set cell math formula across a cell range |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSharedFormula "docName" "sheetName" "startCell" "endCell" "theFormula
docName Document name sheetName Sheet name startCell Start cell (ie: A3) endCell End cell (ie: A8) "theFormula First cell formula. Next ones will be populated." |
neoExcelSetCellFormat
|
Purpose: |
Set cell format |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetCellFormat "docName" "sheetName" theRow theColumn theFormat
docName Document name sheetName Sheet name theRow Row number theColumn Column number theFormat Format |
neoExcelMergeCells
|
Purpose: |
Merge sheet cells |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelMergeCells "docName" "sheetName" "fromCell" "toCell"
docName Document name sheetName Sheet name fromCell From cell (ie: A1) toCell To cell (ie: A8) |
neoExcelSetCellStyle
|
Purpose: |
Set cell style |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetCellStyle "docName" "sheetName" theRow theColumn isBold isItalic isUnderline textAlign fontSize "fontColor" "fill"
docName Document name sheetName Sheet name theRow Row number theColumn Column number isBold Bold isItalic Italic isUnderline Underline textAlign Text align fontSize Font size (number) fontColor Font color (ie: #ff0000) fill Fill color (ie: #0000ff) |
neoExcelSetCellBorder
|
Purpose: |
Set cell border style |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetCellBorder "docName" "sheetName" theRow theColumn "borderColor" borderStyle
docName Document name sheetName Sheet name theRow Row number theColumn Column number borderColor Border color (ie: #ff0000) borderStyle Border style |
neoExcelArrayToRow
|
Purpose: |
Copy Array elements to a row from cell which to start filling the values |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelArrayToRow "docName" "sheetName" theRow theColumn theArray
docName Document name sheetName Sheet name theRow Row number theColumn Column number to start theArray Array variable name |
neoExcelArrayToCol
|
Purpose: |
Copy Array elements to a column from cell which to start filling the values |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelArrayToCol "docName" "sheetName" theRow theColumn theArray
docName Document name sheetName Sheet name theRow Row number to start theColumn Column number theArray Array variable name |
neoExcelSetRowStyle
|
Purpose: |
Set row style |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSetRowStyle "docName" "sheetName" theRow theColumn theNumber isBold isItalic isUnderline textAlign fontSize "fontColor" "fill"
docName Document name sheetName Sheet name theRow Row number theColumn First column number to style theNumber Number of cells to style isBold Bold isItalic Italic isUnderline Underline textAlign Text align fontSize Font size (number) fontColor Font color (ie: #ff0000) fill Fill color (ie: #0000ff) |
neoExcelGetCell
|
Purpose: |
Get cell information in JSON format |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelGetCell "docName" "sheetName" theRow theColumn returnVar
docName Document name sheetName Sheet name theRow Row number theColumn Column number returnVar Variable to store result (JSON format) |
neoExcelSave
|
Purpose: |
Save (download) the Excel document. |
|
Category: |
neoExcel |
|
Syntax: |
neoExcelSave "docName" "fileName"
docName Document name fileName File name (ie: myfile.xlsx) |