Intro

Data markers have multiple switches and options that are available for use in ExcelTemplate workbooks.

ExcelTemplate Grouping and Nesting allows users to bind flat data to a specially formatted spreadsheet with the data being displayed in a grouped or nested format. To learn how to create a template for Grouping and Nesting, see our in-depth tutorai Using Grouping and Nesting with ExcelTemplate.

Requirements

This sample requires OfficeWriter Enterprise Edition to be installed because the OfficeWriter Grouping and Nesting is only available in the Enterprise Edition of the product.

Code

public class GroupingAndNesting
    {
        /// <summary>
        /// Build the report with ExcelTemplate
        /// </summary>
        public void GenerateReport()
        {
            //--- Create a new ExcelTemplate object and open a template file
 
            ExcelTemplate xlt = new ExcelTemplate();
            //Open the template
            xlt.Open(@"..\..\ExcelTemplateFiles\GroupingAndNestingTemplate.xlsx");
 
            //--- Fill the dataset with the data from the CSV file
            DataSet ds = GetCSVData(@"..\..\ExcelData\GroupingandNestingData.CSV");
 
 
            //--- Bind the data to the template file and save it.
            xlt.BindData(ds, "Data", xlt.CreateDataBindingProperties());
            xlt.Process();
            xlt.Save(@"..\..\ExcelOutputFiles\GroupingandNesting_output.xlsx");
        }
 
        //Parse the data from the CSV file
        System.Data.DataSet GetCSVData(string csvFileName)
        {
            DataSet ds;
            using (GenericParserAdapter parser = new GenericParserAdapter(csvFileName))
            {
                parser.ColumnDelimiter = ',';
                parser.FirstRowHasHeader = true;
 
                ds = parser.GetDataSet();
            }
            return ds;
        }
    }

Downloads

Template: GroupingandNestingTemplate.xlsx
Output: GroupingandNesting_output.xlsx

Space Shortcuts

Page tree

Intro

Code

Downloads