private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			workbook.LoadFromFile(@"..\..\..\..\..\..\Data\MarkerDesignerSample.xls");
			DataTable dt = (DataTable)dataGrid1.DataSource;

			Worksheet sheet = workbook.Worksheets[0];

			workbook.MarkerDesigner.AddParameter("Variable1",1234.5678);
			workbook.MarkerDesigner.AddDataTable("Country",dt);
			workbook.MarkerDesigner.Apply();

			sheet.AllocatedRange.AutoFitRows();
			sheet.AllocatedRange.AutoFitColumns();;

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void ExcelDocViewer( string fileName )
		{
			try
			{
				System.Diagnostics.Process.Start(fileName);
			}
			catch{}
		}

		Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
			Dim workbook As Workbook = New Workbook()

			workbook.LoadFromFile("..\..\..\..\..\..\Data\MarkerDesignerSample.xls")
			Dim dt As DataTable = CType(dataGrid1.DataSource, DataTable)

			Dim sheet As Worksheet = workbook.Worksheets(0)

			workbook.MarkerDesigner.AddParameter("Variable1",1234.5678)
			workbook.MarkerDesigner.AddDataTable("Country",dt)
			workbook.MarkerDesigner.Apply()

			sheet.AllocatedRange.AutoFitRows()
			sheet.AllocatedRange.AutoFitColumns()


			workbook.SaveToFile("Sample.xls")
			ExcelDocViewer(workbook.FileName)
		End Sub

		Private Sub ExcelDocViewer(ByVal fileName As String)
			Try
				System.Diagnostics.Process.Start(fileName)
			Catch
			End Try
		End Sub

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();

			Worksheet sheet = workbook.Worksheets[0];
			sheet.Range["C10"].Style.KnownColor = ExcelColors.Gray25Percent;
			sheet.Range["C11"].Style.KnownColor= ExcelColors.Blue;
			sheet.Range["C11"].Style.KnownColor = ExcelColors.Gold;

			workbook.SaveAsXml("sample.xml");

			System.Diagnostics.Process.Start(Path.Combine(Application.StartupPath,"Sample.xml"));
		}

		Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
			Dim workbook As Workbook = New Workbook()

			Dim sheet As Worksheet = workbook.Worksheets(0)
			sheet.Range("C10").Style.KnownColor = ExcelColors.Gray25Percent
			sheet.Range("C11").Style.KnownColor= ExcelColors.Blue
			sheet.Range("C11").Style.KnownColor = ExcelColors.Gold

			workbook.SaveAsXml("sample.xml")

			System.Diagnostics.Process.Start(Path.Combine(Application.StartupPath,"Sample.xml"))
		End Sub

		private void ExcelDocViewer( string fileName )
		{
			try
			{
				System.Diagnostics.Process.Start(fileName);
			}
			catch{}
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			Worksheet sheet = workbook.Worksheets[0];

			sheet.Range["C10"].Text = "The sample demonstrates how to save an excel workbook to stream.";

			//Save an excel workbook to stream
			FileStream fileStream = new FileStream("Sample.xls",FileMode.Create);
			workbook.SaveToStream(fileStream);

			fileStream.Close();

			ExcelDocViewer(Path.Combine(Application.StartupPath,"Sample.xls"));
		}

		Private Sub ExcelDocViewer(ByVal fileName As String)
			Try
				System.Diagnostics.Process.Start(fileName)
			Catch
			End Try
		End Sub

		Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
			Dim workbook As Workbook = New Workbook()
			Dim sheet As Worksheet = workbook.Worksheets(0)

			sheet.Range("C10").Text = "The sample demonstrates how to save an excel workbook to stream."

			'Save an excel workbook to stream
			Dim fileStream As FileStream = New FileStream("Sample.xls",FileMode.Create)
			workbook.SaveToStream(fileStream)

			fileStream.Close()

			ExcelDocViewer(Path.Combine(Application.StartupPath,"Sample.xls"))
		End Sub