Bulk Report Generation in DOT Format via C#
Generate reports in DOT format using data source & a template.
How to Generate DOT based Reports Using C#
In order to create DOT reports, we’ll use
API which is a feature-rich, powerful and easy to use report generation API for C# platform. Open
package manager, search for Aspose.Words and install. You may also use the following command from the Package Manager Console.
Package Manager Console Command
PM> Install-Package Aspose.Words
Steps to Assemble DOT via C#
- Load template in an instance of Document class
- Create an object of ReportingEngine
- Set engine options
- Call ReportingEngine.BuildReport method
- Pass the template, data source as perameters
- Save the result with Doucment.Save method
System Requirements
Before integrating the code, make sure that you have the following prerequisites.
- Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Windows Azure, Mono or Xamarin Platforms
- Development environment like Microsoft Visual Studio
- Aspose.Words for .NET referenced in your project
Generate DOT Reports using C# example code
// build data source
var xml = JsonConvert.DeserializeXmlNode(File.ReadAllText("filenameDocx"), "RootElement");
var dataSet = new DataSet("datasourceName");
dataSet.ReadXml(new MemoryStream(Encoding.UTF8.GetBytes(xml.InnerXml)));
var dataTable = dataSet.Tables["datasourceName"];
// load template for report
var doc = new Document("template.dot");
// create ReportingEngine
var engine = new Reporting.ReportingEngine
{
// set appropriate options
Options = Reporting.ReportBuildOptions.AllowMissingMembers
};
// build report using template & data source
engine.BuildReport(doc, dataTable, "datasourceName");
// save the report
doc.Save("output.dot", SaveFormat.Doc);
Free App to Assemble DOT
Check our live demos to create DOT files with following benefits.
DOT What is DOT File Format
Files with .DOT extension are template files created by Microsoft Word to have pre-formatted settings for generation of further DOC or DOCX files. A template file is created in order to have specific user settings that should be applied to subsequent files created from these. These settings include page margins, borders, headers, footers, and other page settings. Such templates are used in official documents such as company letterheads and standardized forms. The DOT file format is specific to Microsoft Word 2003 and earlier, but is supported by higher versions as well. Microsoft Word by default opens every new document based on normal.dot file. If modified, all the new files created will result in same settings as from the template file. In Microsoft Word 2007, the DOT file format has been replaced with Office OpenXML based DOTX file format.
Read MoreOther Supported Report Generation Formats
Using C#, one can easily generate reports of multiple formats including.