Esempio n. 1
0
        /// <summary>
        /// 为导入EXcel的表格设置自适应边框
        /// </summary>
        /// <param name="PCIoldFinDT"></param>
        /// <param name="PCi_Sheet"></param>
        /// <param name="begincell"></param>
        public static void Frame(System.Data.DataTable PCIoldFinDT, _Worksheet PCi_Sheet, string begincell)
        {
            int    moveothcn = PCIoldFinDT.Columns.Count - 1;
            string moveoth1  = MYTUW.TUW.Move_excel_active_cell(1, begincell, moveothcn);
            int    moveothro = PCIoldFinDT.Rows.Count;
            string moveoth2  = MYTUW.TUW.Move_excel_active_cell(0, moveoth1, moveothro);

            TU.set_Table_Format(PCi_Sheet, begincell, moveoth2);
        }