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) |