winform中轉Excel檔
来源:互联网 发布:mac 改变安装路径 编辑:程序博客网 时间:2024/04/29 18:40
#region 轉Excel檔
private void button5_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.ApplicationClass MyExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
MyExcel.Visible = true;
if (MyExcel == null)
{
MessageBox.Show("EXCEL无法启动!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int rowcount = 0;
int columncount = 0;
MyExcel.Application.Workbooks.Add(true);
columncount = this.dataGridView1.ColumnCount;
rowcount = this.dataGridView1.RowCount;
for (int m = 1; m < columncount; m++)
{
MyExcel.Cells[1, m] = this.dataGridView1.Columns[m - 1].HeaderText;//去除dataGridView1的编号列
}
for (int i = 0; i < rowcount; i++)
{
for (int j = 1; j < columncount; j++)
{
MyExcel.Cells[i + 2, j] = Convert.ToString(this.dataGridView1[j - 1, i].Value);
}
}
}
#endregion
private void button5_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.ApplicationClass MyExcel = new Microsoft.Office.Interop.Excel.ApplicationClass();
MyExcel.Visible = true;
if (MyExcel == null)
{
MessageBox.Show("EXCEL无法启动!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int rowcount = 0;
int columncount = 0;
MyExcel.Application.Workbooks.Add(true);
columncount = this.dataGridView1.ColumnCount;
rowcount = this.dataGridView1.RowCount;
for (int m = 1; m < columncount; m++)
{
MyExcel.Cells[1, m] = this.dataGridView1.Columns[m - 1].HeaderText;//去除dataGridView1的编号列
}
for (int i = 0; i < rowcount; i++)
{
for (int j = 1; j < columncount; j++)
{
MyExcel.Cells[i + 2, j] = Convert.ToString(this.dataGridView1[j - 1, i].Value);
}
}
}
#endregion
- winform中轉Excel檔
- WinForm中导出Excel
- WinForm中EXCEL模板导出
- winform中导入excel表格
- winform窗体中操作Excel
- winForm中C#实现Excel的导出
- C# winform中导出到excel
- 在WinForm中嵌入Word和Excel
- winform导入excel到access数据库中
- WinForm中DataGridView数据导入Excel
- C# winform 中如何导入Excel
- Winform中导出数据到Excel
- c# winform 中导入Excel 的问题 !
- C# Winform中导出数据到Excel
- winform中DataGridView导出到Excel
- winform导入excel到access数据库中
- C#Winform中从datagridview导出Excel
- C#中Winform中设置Excel单元格格式
- Java常用开源工具概述
- 一个VC读写刷卡器的例子
- 读取 配置文件
- 一个美国老网络工程师,给年轻工程师的忠告
- trac配置(stand-alone server)
- winform中轉Excel檔
- [软件下载]nmap 4.76 windows版本
- 怎么回事?
- 240多个jQuery插件
- 判断EMAIL格式脚本
- jquery常用操作
- JavaScript程序设计——第4章 继承
- [软件下载]gpg for win 1.1.3
- RAR for Linux压缩控件的安装与配置