neoExcel
Create Excel files on the fly.
Based on:
https://github.com/jiteshkumawat/oxml.js
Sample App:
https://visualneo.com/tutorials/neoexcel
Description
The neoExcel plugin for VisualNEO Web enables developers to create and save Excel spreadsheets directly within web applications. Based on the OXML.js library, this plugin provides versatile spreadsheet management, making it suitable for applications that require data storage, reporting, or data manipulation. Here are its main features:
- Excel File Creation and Management:
- neoExcelCreate: Initializes a new Excel document, ready to store data and formulas across multiple sheets.
- neoExcelAddSheet: Adds a new sheet to an Excel document, allowing multi-sheet file organization.
- Cell Content and Formatting:
- neoExcelSetCellText and neoExcelSetCellValue: Enable setting text or numeric values in specific cells, allowing for structured data input.
- neoExcelSetCellFormat: Defines the format for individual cells, including font style, alignment, color, and fill options, providing flexibility in data presentation.
- neoExcelSetCellFormula and neoExcelSharedFormula: Set mathematical formulas within cells, supporting complex calculations directly in the spreadsheet.
- Data Import and Export:
- neoExcelArrayToRow and neoExcelArrayToCol: Populate rows or columns with data from an array, making it easy to import data into the spreadsheet.
- neoExcelSave: Exports and downloads the created Excel file, giving users a downloadable .xlsx file that can be shared or used externally.
- Cell and Row Styling:
- neoExcelSetRowStyle and neoExcelSetCellBorder: Define styling for rows or cell borders, adding visual structure to data for easier interpretation.
- Data Retrieval:
- neoExcelGetCell: Retrieves cell data in JSON format, making it easy to access and manipulate stored data programmatically.
The neoExcel plugin is ideal for applications requiring interactive spreadsheets, such as data-driven reports, inventory management systems, and business data analytics.
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) |
Created with the Personal Edition of HelpNDoc: Free Kindle producer