private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
//<snippet1>
Microsoft.Office.Interop.Excel.Worksheet nativeWorksheet =
Globals.ThisAddIn.Application.ActiveSheet;
if (nativeWorksheet != null)
{
Microsoft.Office.Tools.Excel.Worksheet vstoSheet =
Globals.Factory.GetVstoObject(nativeWorksheet);
}
//</snippet1>
//<snippet2>
Microsoft.Office.Interop.Excel.Workbook nativeWorkbook =
Globals.ThisAddIn.Application.ActiveWorkbook;
if (nativeWorkbook != null)
{
Microsoft.Office.Tools.Excel.Workbook vstoWorkbook =
Globals.Factory.GetVstoObject(nativeWorkbook);
}
//</snippet2>
//<snippet3>
Microsoft.Office.Interop.Excel.Worksheet sheet =
Globals.ThisAddIn.Application.ActiveSheet;
if (sheet.ListObjects.Count > 0)
{
Excel.ListObject listObject =
sheet.ListObjects[1];
Microsoft.Office.Tools.Excel.ListObject vstoListObject =
Globals.Factory.GetVstoObject(listObject);
}
//</snippet3>
}
// </Snippet1>
private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
// <Snippet2>
this.addressTableAdapter = new AdventureWorksLTDataSetTableAdapters.AddressTableAdapter();
this.adventureWorksDataSet = new AdventureWorksLTDataSet();
this.addressTableAdapter.Fill(this.adventureWorksDataSet.Address);
this.addressBindingSource = new System.Windows.Forms.BindingSource();
// </Snippet2>
// <Snippet3>
Excel.Worksheet worksheet = (Excel.Worksheet) this.Application.ActiveWorkbook.Worksheets[1];
// Create a workhseet host item.
Worksheet extendedWorksheet = Globals.Factory.GetVstoObject(worksheet);
// </Snippet3>
// <Snippet4>
Excel.Range cell = extendedWorksheet.Range["$A$1:$G$5"];
this.addressListObject = extendedWorksheet.Controls.AddListObject(cell, "list1");
// </Snippet4>
// <Snippet5>
this.addressBindingSource.DataSource = this.adventureWorksDataSet.Address;
this.addressListObject.AutoSetDataBoundColumnHeaders = true;
this.addressListObject.SetDataBinding(
this.addressBindingSource, "", "AddressID", "AddressLine1",
"AddressLine2", "City", "StateProvince", "CountryRegion", "PostalCode");
// </Snippet5>
}
//</snippet1>
private void CreateVstoListObjectForNativeListObject()
{
//<Snippet2>
Microsoft.Office.Tools.Excel.ListObject vstoListObject = null;
if (Globals.Sheet1.ListObjects.Count > 0)
{
Excel.ListObject nativeListObject = Globals.Sheet1.ListObjects[1];
vstoListObject = Globals.Sheet1.Controls.AddListObject(nativeListObject);
}
//</Snippet2>
}
private void Sheet1_Startup(object sender, System.EventArgs e)
{
Excel.ListObject nativeListObject = null;
try
{
nativeListObject = this.ListObjects.get_Item("MyListObject");
}
catch (System.Runtime.InteropServices.COMException ex)
{
// "MyListObject" does not exist.
if (ex.ErrorCode != DISP_E_BADINDEX)
{
throw;
}
}
if (nativeListObject != null)
{
vstoListObject = this.Controls.AddListObject(nativeListObject);
}
}
//</Snippet8>
//---------------------------------------------------------------------
private void Test2()
{
//<Snippet6>
Microsoft.Office.Tools.Excel.ListObject list1 =
this.Controls.AddListObject(this.Range["A1", "B3"], "list1");
//</Snippet6>
//<Snippet7>
list1.Resize(this.Range["A1", "C5"]);
//</Snippet7>
//<Snippet4>
Microsoft.Office.Tools.Excel.NamedRange NamedRange1 =
this.Controls.AddNamedRange(this.Range["A1"], "NamedRange1");
//</Snippet4>
//<Snippet5>
NamedRange1.RefersTo = "=Sheet1!$A$1:$B$1";
//</Snippet5>
//<Snippet3>
Microsoft.Office.Tools.Excel.NamedRange textInCell;
textInCell = this.Controls.AddNamedRange(this.get_Range("A1"), "cellText");
textInCell.Value2 = "Hello world!";
//</Snippet3>
//<Snippet2>
Microsoft.Office.Tools.Excel.ListObject employeeData;
employeeData = this.Controls.AddListObject(this.get_Range("$A$1:$D$4"), "employees");
//</Snippet2>
}
