c#操作 word excel
来源:互联网 发布:信息的编程加工 编辑:程序博客网 时间:2024/05/06 10:46
导出成EXCEL:
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = true;
for (int i = 0; i < this.dataGridView1.ColumnCount; i++)
{
excel.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText;
}
for (int i = 0; i < this.dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
{
excel.Cells[i + 2, j + 1] = this.dataGridView1[j, i].Value.ToString();
}
}
导出成WORD:
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = true;
for (int i = 0; i < this.dataGridView1.ColumnCount; i++)
{
excel.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText;
}
for (int i = 0; i < this.dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
{
excel.Cells[i + 2, j + 1] = this.dataGridView1[j, i].Value.ToString();
}
}
导出成WORD:
Word.Document mydoc = new Word.Document();
Word.Table mytable;
Word.Selection mysel;
Object myobj;
//建立Word对象
Word.Application word = new Word.Application();
myobj = System.Reflection.Missing.Value;
mydoc = word.Documents.Add(ref myobj, ref myobj, ref myobj, ref myobj);
word.Visible = true;
mydoc.Select();
mysel = word.Selection;
//将数据生成Word表格文件
mytable = mydoc.Tables.Add(mysel.Range, this.dataGridView1.RowCount, this.dataGridView1.ColumnCount, ref myobj, ref myobj);
//设置列宽
mytable.Columns.SetWidth(30, Word.WdRulerStyle.wdAdjustNone);
//输出列标题数据
for (int i = 0; i < this.dataGridView1.ColumnCount; i++)
{
mytable.Cell(1, i + 1).Range.InsertAfter(this.dataGridView1.Columns[i].HeaderText);
}
//输出控件中的记录
for (int i = 0; i < this.dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
{
mytable.Cell(i + 2, j + 1).Range.InsertAfter(this.dataGridView1[j, i].Value.ToString());
}
}
Word.Table mytable;
Word.Selection mysel;
Object myobj;
//建立Word对象
Word.Application word = new Word.Application();
myobj = System.Reflection.Missing.Value;
mydoc = word.Documents.Add(ref myobj, ref myobj, ref myobj, ref myobj);
word.Visible = true;
mydoc.Select();
mysel = word.Selection;
//将数据生成Word表格文件
mytable = mydoc.Tables.Add(mysel.Range, this.dataGridView1.RowCount, this.dataGridView1.ColumnCount, ref myobj, ref myobj);
//设置列宽
mytable.Columns.SetWidth(30, Word.WdRulerStyle.wdAdjustNone);
//输出列标题数据
for (int i = 0; i < this.dataGridView1.ColumnCount; i++)
{
mytable.Cell(1, i + 1).Range.InsertAfter(this.dataGridView1.Columns[i].HeaderText);
}
//输出控件中的记录
for (int i = 0; i < this.dataGridView1.RowCount - 1; i++)
{
for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
{
mytable.Cell(i + 2, j + 1).Range.InsertAfter(this.dataGridView1[j, i].Value.ToString());
}
}
- c#操作 word excel
- C# 操作Word ,Excel
- C# OFFICE WORD EXCEL操作
- C#操作MS Word 和 MS Excel
- C#的office操作[word&Excel]
- C#操作MS Word 和 MS Excel
- C#的office操作[word&Excel]
- C#的office操作[word&Excel]
- C#的office操作[word&Excel]
- C# Word/Excel 相关操作类库
- C#操作Word和Excel笔记
- C# 操作word,excel网文大全
- C#操作office方面的总结 Excel和Word
- C#操作office方面的总结 Excel和Word
- C#操作office方面的总结 Excel和Word
- C#操作office方面的总结 Excel和Word
- c# gridview操作:绑定特定列、导出Excel、导出WORD
- C# 操作office(word、excel)com异常问题
- JAVA Calendar详解
- 手机成移动互联网入口必争之地
- C#数据绑定之INotifyPropertyChanged
- mybatis3 spring cxf
- Linux C 串口编程
- c#操作 word excel
- overriding && overloading
- 硕士论文答辩
- 指令周期的基本概念
- iOS: Singleton模式
- (一)初试Matlab Gui之数组引用
- java 对称加密——基于口令的加密与解密
- Extjs学习笔记3-多功能编辑框
- Android 解屏幕锁与点亮屏幕