Skip to end of metadata
Go to start of metadata
Icon

Each ExcelWriter code sample includes basic code that covers a specific scenario, along with necessary input files and a sample output file for comparison. These are intended to be quick examples of how to use the product. To learn how to use ExcelWriter, please see our Tutorials.

ExcelTemplate Samples

  • Arrays and Collections as Data Sources — Use a variety of .NET data types to populate ExcelTemplate including string[], ArrayList, and Hashtable.
  • Chart Report — Any chart that references a range with data markers will have its data source updated when ExcelTemplate imports rows of data. Make changes to a template without making any changes to code.
  • Data Binding Properties — The DataBindProperties object provides the means to change how data is imported using ExcelTemplate.
  • Data Marker Options — Data markers have multiple switches and options that are available for use in ExcelTemplate workbooks.
  • Loan Calculator Spreadsheet — By using Excel's existing internal calculator, ExcelWriter allows you to make calculations in your report.
  • Sample Expense Report — This sample uses ExcelTemplate to populate a generic expense report template.
  • String Data Source — Very simple sample that demonstrates how to use strings of data for an Excel report.
  • Template Grouping and Nesting — Data markers have multiple switches and options that are available for use in ExcelTemplate workbooks.
  • XML Data Import — Parse an XML file and put the data into arrays for use in an ExcelTemplate report.

ExcelApplication Samples

  • Basic Steps — This sample covers a wide range of basic ExcelApplication functionality. Excellent for getting started or brushing up on basic skills.
  • Basic Steps R1C1 — Same as Basic Steps except all the formulas and references are in R1C1 notation.
  • Application to Template Sample — Create a template file for ExcelTemplate using ExcelApplication to write in data markers.
  • Template to Application Sample — Populate a template with ExcelTemplate and then programmatically manipulate or 'post process' the workbook with ExcelApplication.
  • Multiple Chart Report — Import data to an existing template with multiple charts. Manipulate existing charts with ExcelApplication.
  • Scatter Chart Report — See how to create Scatter Charts with ExcelApplication.
  • Two Axis Chart Sample — Create a chart with ExcelApplication that has two axes: primary axis and secondary axis.
  • Grouping and Subtotals — Add Excel's grouping and outlining functionality to a workbook with ExcelWriter to display nested data.
  • Data Validation — Define and apply data validation rules to cells with ExcelApplication.
  • Excel to DataTable Sample — Extract Excel data into a DataTable
  • Sales Commission Report — An example of a report created with ExcelWriter that compares previous year and year-to-date sales data for a sales team.

 

 

 

 

 

  • No labels