有谁做过将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);
			}
		}