• vsto to fill data use listobject fill


            public void btnFormatTables(Office.IRibbonControl control)
            {
                var sheet = (InteropExcel.Worksheet)Globals.ThisAddIn.Application.ActiveSheet;
                var vstoSheet = Globals.Factory.GetVstoObject(sheet);
                var vstoListObject = vstoSheet.Controls.AddListObject(vstoSheet.Range["A1", "B3"], "list1");
    
                var table = new System.Data.DataTable("Employees");
                table.Columns.Add("FirstName", typeof(string));
                table.Columns.Add("LastName", typeof(string));
                table.Columns.Add("Title", typeof(string));
    
                table.Rows.Add("Nancy", "Anderson", "Sales Representative");
                table.Rows.Add("Robert", "Brown", "Sales Representative");
    
                vstoListObject.AutoSetDataBoundColumnHeaders = true;
                vstoListObject.SetDataBinding(table, "", "Title", "LastName", "FirstName");
                vstoListObject.Disconnect();
    
            }
    ----------------------------------- http://www.cnblogs.com/rock_chen/
  • 相关阅读:
    Vim命令合集
    感知机算法
    【项目】搜索广告CTR预估(二)
    【项目】搜索广告CTR预估(一)
    Kernel Logestic Regression
    SVM3 Soft Margin SVM
    Bias and Variance
    SVM2---核函数的引入
    贪心题目汇总
    Divergent series
  • 原文地址:https://www.cnblogs.com/rock_chen/p/2956623.html
Copyright © 2020-2023  润新知