在c#如何将DataGridview中的内容打印出来? 一般用专门的报表设计器,水晶报表、activeReport什么的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public void ExportExcel(DataSet ds) //以DataSet- 导出Excel文件 { 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; }取得datagridview的dataset打印,我上面是打印代码 你上面说的导入EXCEL 我早运用过了,我就想 要 直接打印的功能代码。希望 各位兄弟帮帮忙了啊 按你的要求就用printdocument控件,然后在它的printpage事件里面写自己的打印代码,弄不好会死人的。 给我邮箱,我有datagridview打印的相关代码。 http://user.qzone.qq.com/250411907/infocenter?ptlang=2052 zedGraph双y轴 将1到n^2共n^2个数等概率地填入n*n的方格中。 C#智能项目生成exe文件读取sqlCE 问题 异常处理问题 关于dataGridView取值和修改的问题??? C#的winform中那难看的滚动条怎么重画? 关于oo大家来看看 高手请进,高分求解 QQ音乐歌词锁屏怎么实现 rtf文件如何加密? 关于richtextbox中图文混编的问题 求教:c#中能否调用perl语言编写的api
public void ExportExcel(DataSet ds) //以DataSet- 导出Excel文件
{
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;
}取得datagridview的dataset打印,我上面是打印代码
希望 各位兄弟帮帮忙了啊