Axional development libraries
Server side javascript
AX Library
ms
MS Excel
MS Excel
Preview
Content
11
Media
37
Back to parent
Excel library
Introduction
First example
Limitations
Common mistakes
Workbook
WorkBook
Creating a Workbook
Loading a Workbook
Iterate through sheets
Get a sheet
Create a sheet
Clone a sheet
Getting cells by name
Creating fonts
Creating styles
Embedded objects
Comparing Excel workBooks
Working with Sheets
Columns
Rows
Cells
Ranges
Tables
Pivot tables
Splits and freeze panes
Autofilters
Data validation
Conditional formatting
Sheet configuration
Loading data
Convert a sheet into ResultSet
Cells
Seting cell value
Getting cell value
Getting cell properties
Naming cells
Setting comments
Setting cell style
Setting hyperlinks
Formulas
Working with formulas
Debugging
Examples
Charts
Charts from data
DBExport
Using dbexport
Naming cells
Data types
Export examples
Export an SQL statement
DBImport
Using dbimport
dbimport example
Error results
Fixing errors
Generating a dbimport template
SQL predicates
Named cells
Form Layout vs Table Layout
Update predicate
Select predicate
Delete predicate
Templates
Projectile motion solver
Loan amortization calculator
Gantt Chart (I)
Gantt Chart (II)
Deprecation Inventory Table
Data transformation
XBRL reporting
PGC 2007
Image
Name
Size (kB)
DataValidation-Date.png
15440.46
DataValidation-Decimal.png
15440.46
DataValidation-DropDown.png
15440.46
DataValidation-Integer.png
15440.46
DataValidation-Length.png
15440.46
dbspaces-chart.png
15440.46
Excel-dbexport-append.png
15440.46
Excel-dbexport-cfg1.png
15440.46
Excel-dbexport-sql1.png
15440.46
Excel-dbexport.png
15440.46
Excel-dbimport-err1.png
15440.46
Excel-dbimport-err2.png
15440.46
Excel-dbimport-tables.png
15440.46
Excel-dbimport.png
15440.46
Excel-Gantt-Template-1.png
15440.46
Excel-Gantt-Template-2-1.png
15440.46
Excel-Gantt-Template-2-2.png
15440.46
Excel-Gantt-Template-2.png
15440.46
Excel-Loan-Template-1.png
15440.46
Excel-Loan-Template-2.png
15440.46
Excel-Merge-Cells.png
15440.46
Excel-Pivot-Table1.png
15440.46
Excel-ProjectileMotionSolver1.png
15440.46
Excel-ProjectileMotionSolver2.png
15440.46
Excel-ProjectileMotionSolver3.png
15440.46
Excel-setAutoFilters.png
15440.46
Excel-Table-0.png
15440.46
Excel-Table-1.png
15440.46
Excel-Table-2.png
15440.46
Excel-Table-3.png
15440.46
Excel-Table-Styles.png
15440.46
excel_countries_out.png
15440.46
excel_countries_run.png
15440.46
excel_from_json_array_out1.png
15440.46
excel_from_json_array_out2.png
15440.46
excel_from_json_array_run.png
15440.46
excel_multiplication.png
15440.46
DataValidation-Date.png
DataValidation-Decimal.png
DataValidation-DropDown.png
DataValidation-Integer.png
DataValidation-Length.png
dbspaces-chart.png
Excel-dbexport-append.png
Excel-dbexport-cfg1.png
Excel-dbexport-sql1.png
Excel-dbexport.png
Excel-dbimport-err1.png
Excel-dbimport-err2.png
Excel-dbimport-tables.png
Excel-dbimport.png
Excel-Gantt-Template-1.png
Excel-Gantt-Template-2-1.png
Excel-Gantt-Template-2-2.png
Excel-Gantt-Template-2.png
Excel-Loan-Template-1.png
Excel-Loan-Template-2.png
Excel-Merge-Cells.png
Excel-Pivot-Table1.png
Excel-ProjectileMotionSolver1.png
Excel-ProjectileMotionSolver2.png
Excel-ProjectileMotionSolver3.png
Excel-setAutoFilters.png
Excel-Table-0.png
Excel-Table-1.png
Excel-Table-2.png
Excel-Table-3.png
Excel-Table-Styles.png
excel_countries_out.png
excel_countries_run.png
excel_from_json_array_out1.png
excel_from_json_array_out2.png
excel_from_json_array_run.png
excel_multiplication.png
×