...
Code Block |
---|
using SoftArtisans.OfficeWriter.ExcelWriter; ... //Instantiate the template object ExcelTemplate XLT = new ExcelTemplate(); //Open the file XLT.Open(Page.MapPath("//templates//Part1_Financial_Template.xlsx")); //Create data binding properties DataBindingProperties bindingProps = XLT.CreateDataBindingProperties(); //Get the data from the CSVs. More info about the generic parser is available //in the project and in the tutorial above. DataTable dtAssets = GetCSVData("//data//Assets.csv"); DataTable dtLosses = GetCSVData("//data//Losses.csv"); DataTable dtOther = GetCSVData("//data//Other.csv"); //Declare the row data. This tutorial uses a single item array to demonstrate the //optional modifier string[] headerValues = { "2011" }; string[] headerNames = { "FiscalYear" }; //Bind each datatable XLT.BindData(dtAssets, "Assets", bindingProps); XLT.BindData(dtLosses, "Losses", bindingProps); XLT.BindData(dtOther, "Other", bindingProps); //Bind the single row data XLT.BindRowData(headerValues, headerNames, "Header", bindingProps); //Call process to import data to file XLT.Process(); /*This next section handles the post-processing*/ //Instantiate ExcelApplication ExcelApplication XLA = new ExcelApplication(); //Open the XLT object as a new workbook Workbook wb = XLA.Open(XLT); //Get the first worksheet Worksheet ws = wb.Worksheets[0]; //Set the autofit width and height ws.PopulatedCells.AutoFitWidth(); ws.PopulatedCells.AutoFitHeight(); //Save the file XLA.Save(wb, Page.Response, "temp.xlsx", false); |
Downloads
TBA
You can download the code for the Financial Report here.