TemplateUseCS

using System;
 
using GemBox.Spreadsheet;
 
namespace Samples
{
	/// <summary>
	/// TemplateUse sample.
	/// </summary>
	class TemplateUseCS
	{
		[STAThread]
		static void Main(string[] args)
		{
                        // TODO: If using GemBox.Spreadsheet Professional, put your serial key below.
                        // Otherwise, if you are using GemBox.Spreadsheet Free, comment out the 
                        // following line (Free version doesn't have SetLicense method). 
                        // SpreadsheetInfo.SetLicense("YOUR-SERIAL-KEY-HERE");
 
                        ExcelFile ef = new ExcelFile();
 
			ef.LoadXls("..\\..\\InvoiceTemplate.xls");
 
			FillInvoiceData( ef.Worksheets[0] );
 
			string fileName = "Invoice14.xls";
 
			ef.SaveXls(fileName);
 
			TryToDisplayGeneratedFile(fileName);
		}
 
		static void FillInvoiceData(ExcelWorksheet ws)
		{
			ws.Cells["J5"].Value = 14;
			ws.Cells["J6"].Value = new DateTime(2004,12,20);
			ws.Cells["J6"].Style.NumberFormat = "m/dd/yyyy";
 
			ws.Cells["D12"].Value = "ACME Corp";
			ws.Cells["D13"].Value = "240 Old Country Road, Springfield, IL";
			ws.Cells["D14"].Value = "USA";
			ws.Cells["D15"].Value = "Joe Smith";
 
			ws.Cells["E18"].Value = "6-Dec-04 until 17-Dec-04.";
 
			for(int i=0; i<data.GetLength(0); i++)
			{
				ws.Cells[21+i, 1].Value = data[i,0];
				ws.Cells[21+i, 1].Style.NumberFormat = "dddd, mmmm dd, yyyy";
				ws.Cells[21+i, 4].Value = data[i,1];
			}
 
			ws.Cells["B36"].Value = "Payment via check.";
		}
 
		static object[,] data = new object[,]
		{
			{new DateTime(2004,12,6), 8},
			{new DateTime(2004,12,7), 9},
			{new DateTime(2004,12,8), 8},
			{new DateTime(2004,12,9), 7},
			{new DateTime(2004,12,10), 7},
 
			{new DateTime(2004,12,13), 9},
			{new DateTime(2004,12,14), 8},
			{new DateTime(2004,12,15), 9},
			{new DateTime(2004,12,16), 9},
			{new DateTime(2004,12,17), 6}
		};
 
		static void TryToDisplayGeneratedFile(string fileName)
		{
			try
			{
				System.Diagnostics.Process.Start(fileName);
			}
			catch(Exception)
			{
				Console.WriteLine(fileName + " created in application folder.");
			}
		}
	}
}