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
ie: A1+D4 or SUM(A1:A10)

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
ie: A1+D4 or SUM(A1:A10)

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)

Created with the Personal Edition of HelpNDoc: Free Kindle producer