MyException - 我的异常网
当前位置:我的异常网» C# » 有哪位高手做过将Word,Excel中的数据导入到Gridvie

有哪位高手做过将Word,Excel中的数据导入到Gridview中

www.MyException.Cn  网友分享于:2013-12-26  浏览:16次
有谁做过将Word,Excel中的数据导入到Gridview中?
如题!不是导出哦!

------解决方案--------------------
你就把EXCEL当作处理数据来处理
 string file = this.File1.PostedFile.FileName;//EXCEL的连接地址
string conn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ="+file+";Extended Properties=Excel 8.0";
//OleDbConnection MyConn = new OleDbConnection(conn);
////取出数据
DataSet ds = new DataSet();
string Sql = "select * from [Sheet1$]";
MyConn.Open();
OleDbDataAdapter MyDataAdapter = new OleDbDataAdapter(Sql, MyConn);
////把取出的数据放入DATASET中,以防有多个表

MyDataAdapter.Fill(ds,"table1");
GridView1.DataSource = ds.Tables["table1"];
GridView1.DataBind();
MyConn.Close();

WORD没有处理过
------解决方案--------------------
private void button1_Click(object sender, System.EventArgs e)
{//保存为WORD文件
if(this.richTextBox1.Text=="")
return;
if(this.saveFileDialog1.ShowDialog()==DialogResult.Cancel)
return;
string FileName=this.saveFileDialog1.FileName;
if(FileName.Length<1)
return;
FileName+=".doc";
try
{
Word.ApplicationClass MyWord=new Word.ApplicationClass(); 
Word.Document MyDoc;
Object Nothing=System.Reflection.Missing.Value; 
MyDoc=MyWord.Documents.Add(ref Nothing,ref Nothing,ref Nothing,ref Nothing); 
MyDoc.Paragraphs.Last.Range.Text=this.richTextBox1.Text; 
object MyFileName=FileName;
//将WordDoc文档对象的内容保存为DOC文档 
MyDoc.SaveAs(ref MyFileName,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing,ref Nothing); 
//关闭WordDoc文档对象 
MyDoc.Close(ref Nothing, ref Nothing, ref Nothing); 
//关闭WordApp组件对象 
MyWord.Quit(ref Nothing, ref Nothing, ref Nothing);
MessageBox.Show("WORD文件保存成功","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch(Exception Err)
{
MessageBox.Show("WORD文件保存操作失败!"+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}

文章评论

软件开发程序错误异常ExceptionCopyright © 2009-2015 MyException 版权所有