请问这代码什么意思?
- C# code
public void printAll(System.Data.DataTable dt, string SheetName) { //手动设置 int startrow = 2;//开始写数据的行数,写Datatable数据 int iRows = 0; int iCols = 0; int iTrueCols = 0; Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Add(System.Reflection.Missing.Value); Microsoft.Office.Interop.Excel.Worksheet ws = null; if (wb.Worksheets.Count > 0) { ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets.get_Item(1); } else { wb.Worksheets.Add(System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value); ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets.get_Item(1); } if (ws != null) { if (SheetName.Trim() != "") { ws.Name = SheetName; } iRows = dt.Rows.Count; iTrueCols = dt.Columns.Count; //包含隐藏的列,一共有多少列 iCols = dt.Columns.Count; string[,] dimArray = new string[iRows + 1, iCols]; for (int j = 0, k = 0; j < iTrueCols; j++) { dimArray[0, k] = dt.Columns[j].Caption ; k++; } for (int i = 0; i < iRows; i++) { for (int j = 0, k = 0; j < iTrueCols; j++) { dimArray[i + 1, k] = dt.Rows[i][j].ToString(); k++; } } ws.get_Range(ws.Cells[startrow, 1], ws.Cells[iRows + startrow, iCols]).Value2 = dimArray; ws.get_Range(ws.Cells[startrow, 1], ws.Cells[startrow, iCols]).Font.Bold = true; ws.get_Range(ws.Cells[startrow, 1], ws.Cells[iRows + startrow, iCols]).Font.Size = 10.0; ws.get_Range(ws.Cells[startrow, 1], ws.Cells[iRows + startrow, iCols]).RowHeight = 14.25; ws.Columns.ColumnWidth =20; app.Cells[1, 2] = "库存报表"; //app.Cells[1, 5] = "日期: " + when.ToShortDateString(); ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 3]).Font.Size = 20.0; ws.get_Range(ws.Cells[1, 1], ws.Cells[1, 3]).Font.Color = ColorTranslator.ToOle(Color.Red); } //设置禁止弹出保存和覆盖的询问提示框 app.DisplayAlerts = true; app.AlertBeforeOverwriting = false; app.Visible = true; //app.Save("aaaa"); }
调用此方法时,应该怎么写?新手一个
[解决办法]
这方法是将一个DataTable里的数据导入到一个excel表格中,调用的话就是,一个是Datatable,一个是你的Excel的路径了,至于你想保存到一个固定的excel(这种直接写路径就OK了)。还是你想新建一个excel保存(这个可以使用一个控件savefiledialog)
[解决办法]
SheetName 不是路径
第一个参数就是数据源,第二个就是Excel内指定Sheet的名字(表页名),可以为空。。。