关于VB.NET调用excel的问题
											用建了个窗体,并将窗体上一些文本框内的数据存储在excel,这一步我能解决。但是要怎么调用之前保存的excel并将其内部的数据重新赋给窗体上其他文本框内?  求真相!!										
					
	 2011-01-12 16:28
	    2011-01-12 16:28
   2011-01-13 10:24
	    2011-01-13 10:24
   模拟存储于读取.rar
				(75.05 KB)
模拟存储于读取.rar
				(75.05 KB)
				
				
			 2011-01-13 16:35
	    2011-01-13 16:35
   程序代码:
程序代码:   Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim fileName As String
        '打开文件
        OpenFileDialog1.InitialDirectory = Application.StartupPath
        OpenFileDialog1.ShowDialog()
        fileName = OpenFileDialog1.FileName()
        '调用excel
        xlWorkBook = xlApp.Workbooks.Open(fileName)
        xlWorkSheet = xlWorkBook.Sheets("sheet1")
        With xlWorkSheet
            Dim a(.UsedRange.Rows.Count - 1, .UsedRange.Columns.Count - 1) As String'定义一个数组存储单元格的值
            For i As Integer = 1 To .UsedRange.Rows.Count - 1
                For j As Integer = 1 To .UsedRange.Columns.Count - 1
                    a(i, j) = .Cells(i, j).Value'将单元格的值赋值给数组
                    Console.Write(a(i, j))'在立即窗口输出读取的值
                Next
            Next
        End With
        '关闭文件
        'xlWorkBook.Close()
        xlApp.Quit()
        '排错
        'releaseObject(xlApp)
        'releaseObject(xlWorkBook)
        'releaseObject(xlWorkSheet)
    End Sub										
					
	
 2011-01-13 19:55
	    2011-01-13 19:55
  xlWorkBook= xlApp.Workbooks.Open(fileName) '这一句运行出错啊,错误提示是未处理InvalidComObjectException 。com对象与其基础RCW分开后不能使用。 要怎么解决啊???
 2011-01-14 08:11
	    2011-01-14 08:11
   2011-01-14 08:24
	    2011-01-14 08:24
   2011-01-14 09:06
	    2011-01-14 09:06