public void ExportExcel() { if (ds == null) { return; } Microsoft.office.Interop.Excel.Application xlApp = new Microsoft.office.Interop.Excel.Application(); if (xlApp == null) { MessageBox.Show("无法创建Excel对象,可能您的电脑未安装Excel", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Microsoft.office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks; Microsoft.office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); Microsoft.office.Interop.Excel.Worksheet worksheet = (Microsoft.office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得Sheet1 Microsoft.office.Interop.Excel.Range range; long totalCount = ds.Tables[0].Rows.Count; long rowRead = 0; float percent = 0; //worksheet.Cells[1, 1] = "报表标题"; //写入字段 for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { worksheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName; range = (Microsoft.office.Interop.Excel.Range)worksheet.Cells[1, i + 1]; range.Interior.ColorIndex = 15; range.Font.Bold = true; } //写入数值 for (int r = 0; r < ds.Tables[0].Rows.Count; r++) { for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { worksheet.Cells[r + 2, i + 1] = "'" + ds.Tables[0].Rows[r][i]; } rowRead++; percent = ((float)(100 * rowRead)) / totalCount; } xlApp.Visible = true; }