Intro
Data markers have multiple switches and options that are available for use in ExcelTemplate workbooks.The Data Marker Options used in this example are:
- Fieldname, which imports the name of the field
- Uppercase, which forces characters to uppercase
- Lowercase, which forces characters to lowercase
- Preserve, which forces number strings to be treated as text
- Optional, this will cause the data marker's place to be left empty if it is unbound
Code
public class DataMarkerOptions { /// <summary> /// Build the report with ExcelTemplate /// </summary> public void GenerateReport() { // This 2D Object[][] array will hold the values to be imported object [,] values = { //employee ID {1, 2, 3, 4}, //Last Name { "Davolio" , "Fuller" , "Leverling" , "Peacock" }, //First Name { "Nancy" , "Andrew" , "Janet" , "Margaret" }, //Title { "Sales Rep" , "VP of Sales" , "Sales Rep" , "Sales Rep" }, //Zip { "02139" , "02144" , "23451" , "00213" } }; // These are the field names string [] colnames = { "EmployeeID" , "LastName" , "FirstName" , "Title" , "Zip" }; // Create an instance of ExcelTemplate ExcelTemplate xlt = new ExcelTemplate(); // Open the template workbook string templatePath = @"..\..\ExcelTemplateFiles\DataMarkerOptionsTemplate.xlsx" ; xlt.Open(templatePath); // Pass colnames and values arrays to BindData() DataBindingProperties bindingProperties = xlt.CreateDataBindingProperties(); bindingProperties.MaxRows = ExcelTemplate.ALL_ROWS; bindingProperties.Transpose = true ; xlt.BindData(values, colnames, "dSource" , bindingProperties); // Call the process() method to populate the template with the data source values xlt.Process(); // Save the report xlt.Save( @"..\..\ExcelOutputFiles\DataMarkerOptions_output.xlsx" ); } } |
Downloads
- Template: DataMarkerOptionsTemplate.xlsx
- Output: DataMarkerOptions_output.xlsx