C # Operations Excel style example-Generate Excel Audit table

C # Operations Excel style example-Generate Excel Audit table

 #region Generate audit table public static void Generateaccountgrid (String fileName, String tableName, St            Ring 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, "audited by unit name:", CompanyName, "compilation person:" + owner, "", "Date:" + DateTime.Now.ToShortDateString (), ""); Addnewrow (ref DT, 6, "fiscal period or due Date:" + EndLine, "", "Copy person:" + Copyman, "", "index number:" + "yizk-" + DateTime.Now.Millisecon                D.tostring ());                Addnewrow (ref DT, 6, "", "", "", "", "page: 1", ""); Addnewrow (ref DT, 6, "project name", "Final unaudited number", "Summary"," Adjustment of Accounts "," reclassification Adjustment "," Final approval number "); Addnewrow (ref DT, 6, Ent. Proname, Ent. Unfinishnum, Ent. Finishnum, Ent. Summary, "0", "0", Ent.                Finishnum);                Addnewrow (ref DT, 6, "Audit conclusion:", "", "", "", "", "");                Excelhelper.exporttoexcel (DT, fileName, tableName); if (file.exists (FileName)) {Microsoft.Office.Interop.Excel.Application Xlsapp = new Mic Rosoft.                    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;          Heading Style ((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;                    Add a border for all cells 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;                    The last row of cells merges 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] = "Audit conclusion:";                    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

The above is the C # operation Excel Style example-build the content of Excel audit table, more related content please pay attention to topic.alibabacloud.com (www.php.cn)!

