C# 操作EXCEL樣式 樣本 --產生EXCEL審計表

C# 操作EXCEL樣式 樣本 --產生EXCEL審計表

 #region 產生審計表        public static void GenerateAccountGrid(        string fileName,         string tableName,         string companyName,         string owner,         DateTime endline,         string copyMan, AnalysisEnt ent)        {            try            {                DataTable dt = new DataTable();                dt.Columns.Add(tableName);                dt.Columns.Add("");                dt.Columns.Add("");                dt.Columns.Add("");                dt.Columns.Add("");                dt.Columns.Add("");                //AddNewRow(ref dt, 6, "", "", "", tableName, "", "");                AddNewRow(ref dt, 6, "被審計單位名稱:", companyName, "編製人：" + owner, "", "日期: " + DateTime.Now.ToShortDateString(), "");                AddNewRow(ref dt,  6, "會計週期或到期日：" + endline, "", "複製人：" + copyMan, "", "索引號：" + "YIZK-" + DateTime.Now.Millisecond.ToString());                AddNewRow(ref dt, 6, " ", " ", " ", " ", "頁次: 1", "");                AddNewRow(ref dt, 6, "項目名稱", "期末未審計數", "摘要", "賬項調整", "重分類調整", "期末審定數");                AddNewRow(ref dt, 6, ent.ProName, ent.UnFinishNum, ent.FinishNum, ent.Summary, "0", "0", ent.FinishNum);                AddNewRow(ref dt, 6, "審計結論:", " ", " ", " ", " ", " ");                ExcelHelper.ExportToExcel(dt, fileName, tableName);                if (File.Exists(fileName))                {                    Microsoft.Office.Interop.Excel.Application xlsApp = new Microsoft.Office.Interop.Excel.Application();                    Microsoft.Office.Interop.Excel.Workbook workbook = xlsApp.Workbooks.Open(fileName, Type.Missing,                     Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,                     Type.Missing, Type.Missing, Type.Missing, Type.Missing);                    Microsoft.Office.Interop.Excel.Worksheet mySheet = workbook.Sheets[tableName] as Microsoft.Office.Interop.Excel.Worksheet;                    xlsApp.Visible = true;                    ////標題樣式                    ((Microsoft.Office.Interop.Excel.Range)mySheet.Columns["A:F", System.Type.Missing]).ColumnWidth = 20;                    Microsoft.Office.Interop.Excel.Range titleRange = mySheet.get_Range("A1", "F1");                    titleRange.ClearContents();                    titleRange.Merge(0);                    titleRange = mySheet.get_Range("A1", "A1");                    titleRange.Cells[1, 1] = tableName;                    titleRange.Font.Size = 30;                    titleRange.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;                    titleRange.Borders.get_Item(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeBottom).                    Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium;                    ////為所有儲存格添加邊框                    Microsoft.Office.Interop.Excel.Range allRange = mySheet.get_Range("A1", "F7");                    allRange.Borders.LineStyle = 1;                    allRange.Borders.get_Item(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeTop).                    LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;                    ////最後一行儲存格合并                    Microsoft.Office.Interop.Excel.Range contentRange = mySheet.get_Range("A7", "F7");                    contentRange.ClearContents();                    contentRange.Merge(0);                    contentRange = mySheet.get_Range("A7", "F7");                    contentRange[1, 1] = "審計結論:";                    contentRange.RowHeight = 30;                    contentRange.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignTop;                }            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }        }        public static void AddNewRow(ref DataTable dt, int columnCount, params string[] cells)        {            if (cells == null || cells.Length > columnCount)            {                return;            }            DataRow dr = dt.NewRow();            for (int i = 0; i < cells.Length; i++)            {                dr[i] = cells[i];            }            dt.Rows.Add(dr);        }        #endregion

以上就是C# 操作EXCEL樣式 樣本 --產生EXCEL審計表的內容，更多相關內容請關注topic.alibabacloud.com（www.php.cn）！

