Examples for XToolset

Useful:

• Official documentation on Siemienik.com
• ❤️ Sponsor me
• Gitter community
• Package XLSX-Renderer - Export data to Ecma-376 .XLSX Excel files based on template,
• Package XLSX-Import - Import data from Workbooks / Worksheets Excel files,
• License: MIT
• Order feature or consulting: [email protected]

Working with:

TypeScript	JavaScript	NodeJS	React	Angular	Vue

Examples:

Xlsx-import for front-end frameworks

• Vue sample - it is a web app created with Vue that displays parsed xlsx file.
• React sample - it is a web app created with React that displays parsed xlsx file.
• Angular sample - it is a web app created with Angular that displays parsed xlsx file.

Xlsx-import for Console / CLI

• NodeJS sample of importing an invoice - it is pure JS example which runs on nodejs.
• NodeJS + TS sample of importing an invoice - it is Typescript example that can be transpiled down to pure JS or run directly with ts-node.
• Command line of xlsx-import examples with prepared scripts based on cli version of xlsx-import.

Xlsx-import for backend

• ExpressJS sample - it is a small service created with ExpressJS can parse xlsx files with concrete structure

Xlsx-export

Each example contains:

• template.xlsx with a Template file created in MS Excel,
• viewModel.json with a ViewModel - data which will put into the template,
• expected.xlsx with the expected result.
• After tests being run: test-output.xlsx with fresh generated file.

These examples are able to run by using the command line tool, read more.

Id	Example	Explanation
0	FinishCell	Testing FinishCell basic behaviour.
1	EndRow	Testing EndRowCell behaviour
2	Variable	Testing displaying value of view model variables by using VariableCell.
3	WsName	Testing if WsNameCell set worksheet name correctly.
4	Hyperlink	Testing creating hyperlinks by HyperlinkCell.
5	ForEach-simple	Checks simple loop.
6	ForEach-Continue-stripped-table	Checks ContinueCell behaviour, creates stripped table.
7	ForEach-Sum	Checks summing of loop part of column.
8	Delete	Testing deleting variables.
9	ForEach-Average	Checks getting of average of generated table.
10	Formula	Checks formulas.
11	DumpCols	Checks horizontally appending columns.
12	ForEach-special	Checks advance for each usages like looping on worksheets.
13	Merged-cells-fill	Checks merged cells behaviour
14	ForEach-merged	Checks merged cells behaviour
15	ForEach-merged-two-tables	Checks merged cells behaviour
16	ForEach-merged-pyramid	Checks merged cells behaviour
17	TemplateFormula	Dynamic formula creation
18	TemplateString	Dynamic content creation following by custom template string (Hello ${name}).