Page History

private ExcelTemplatevoid BindTemplateData(string filename)
{
}

ExcelApplication XLA = new ExcelApplication();

Workbook wbTowb = XLA.Open(XLTToXLT);

Worksheet wsTows = wbTowb.Worksheets[0];

XLA.Save(wbTowb, Page.Response, "temp.xlsx", false);

using SoftArtisans.OfficeWriter.ExcelWriter;
...
//Declare Templateglobals
objects globalyMemoryStream ExcelTemplate XLTTostream;
 ExcelApplication XLA;
 ExcelTemplate XLTFromXLT;

protected void RunReport()
{
	          //GetJoin the populatedtwo filesreports fromusing BindTemplateDataCopySheet
        XLTTo = BindTemplateData("//templates//Part1_Financial_Template.xlsx"    JoinReports();
 
      XLTFrom = BindTemplateData("//templates//Part2_Financial_Template.xlsx");

	//Join the two reports using CopySheet
	JoinReports      //bind the data for the newly modified file
          BindTemplateData();

          //Finally postprocess to set the auto fit values
          PostprocessTemplate();
}

protected ExcelTemplatevoid BindTemplateData(string filename)
{
	ExcelTemplate XLT = new ExcelTemplate();


	//Open the template file
	XLT.Open(Page.MapPath(filenamestream));

	//Create data binding properties for ExcelTemplate
	DataBindingProperties bindingProps = XLT.CreateDataBindingProperties(); 

	//Get the datatables to be bound into the template.
	//This example uses CSV data, but the data can come from
	//anywhere
	DataTable dtAssets = GetCSVData("//data//Assets.csv");
	DataTable dtLosses = GetCSVData("//data//Losses.csv");
	DataTable dtOther = GetCSVData("//data//Other.csv");

	//Bind the datatables
	XLT.BindData(dtAssets, "Assets", bindingProps);
	XLT.BindData(dtLosses, "Losses", bindingProps);
	XLT.BindData(dtOther, "Other", bindingProps);

	/*This section only applies to the first template. It will be ignored by the 
	second template, since there are no markers to bind to.*/

	//Create the array of header values. This example only binds a single item
	string[] headerValues = { "2011" };

	//Create the array of header names.
	string[] headerNames = { "FiscalYear" };

	//Bind the header row data
	XLT.BindRowData(headerValues, headerNames, "Header", bindingProps);

	//end

	//Process to import the data to the file
	XLT.Process();

	//Return the populated file
	return XLT;
}

protected void JoinReports()
{
	//Instantiate ExcelApplication
for	XLA the= workbook being copied to
	ExcelApplication XLATo = new ExcelApplication()new ExcelApplication();

	//Open the first template
	Workbook wbTo = XLA.Open(Page.MapPath("//templates//Part1_Financial_Template.xlsx"));

	//Open the populatedsecond template
	Workbook wbTowbFrom = XLAToXLA.Open(XLTTo)Page.MapPath("//templates//Part2_Financial_Template.xlsx"));

	//Open the first worksheet, with the table
	Worksheet wsTowsFrom = wbTo.WorksheetswbFrom[0];
	//Open the second worksheet, with the data
	Worksheet wsFromData = wbFrom[1];

	//Call AutoFit CopySheet, making sure to setcopy the heightdata andsheet widthfirst
	wsTowbTo.PopulatedCellsWorksheets.AutoFitWidth(CopySheet(wsFromData, 1, "Data");
	wsTowbTo.PopulatedCellsWorksheets.AutoFitHeight(CopySheet(wsFrom, 1, "Percent by Quarter");

	//Instantiate ExcelApplicationthe for the workbook being copied from
	ExcelApplication XLAFrom stream to save to
        stream = new MemoryStream();

        //Save the stream
        XLA.Save(wbTo, stream);
}

protected void PostprocessTemplate()
{
         //Instantiate ExcelApplication
         XLA = new ExcelApplication();

	         //Open the newly populated template
	XLT
         Workbook wbFromwb = XLAFromXLA.Open(XLTFromXLT);

	         //OpenGet the first worksheet,
with the table
	       Worksheet wsFromws = wbFromwb.Worksheets[0];
	
         //OpenSet autofit for the secondwidth worksheet,and withheight
the data 	Worksheet wsFromData = wbFrom[1];  	  //CallThis CopySheet,sets makingall surecells to copy the data sheet first
	wbTo.Worksheets.CopySheet(wsFromData, 1, "Data");
	wbTo.Worksheets.CopySheet(wsFrom, 1, "Percent by Quarter");

	//Save the file
	XLATo.Save(wbTothe highest or widest
         //value present in the area
         ws.PopulatedCells.AutoFitWidth();
         ws.PopulatedCells.AutoFitHeight();

         //Open the processed file in your browser
         XLA.Save(wb, Page.Response, "Part3_Output.xlsx", false);
}