当前位置: 代码迷 >> ASP.NET >> 如何用excel.application.workbooks.open读取EXCEL模板
  详细解决方案

如何用excel.application.workbooks.open读取EXCEL模板

热度:8631   发布时间:2013-02-25 00:00:00.0
怎么用excel.application.workbooks.open读取EXCEL模板
VB.NET code
    '读取路径    Public readPath As String    Public app As Excel.Application    Public wbs As Excel.Workbooks    Public wb As Excel.Workbook    Public wss As Excel.Worksheets    Public ws As Excel.Worksheet    ''' <summary>    ''' 打开一个Excel文件    ''' </summary>    ''' <param name="FileName">文件名</param>    ''' <remarks></remarks>    Public Sub Open(ByVal FileName As String)        Try            app = New Excel.Application()            wbs = app.Workbooks            [color=#FF0000]wb = wbs.Open(readPath & FileName, Type.Missing, False, Type.Missing,Type.Missing,                 _Type.Missing, Type.Missing, Excel.XlPlatform.xlWindows, Type.Missing, Type.Missing,                 _Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing)[/color]            Me.mFilename = FileName        Catch ex As Exception        End Try    End Sub

读一个模板,在红色那一段,就会卡住,等N长时间也不往下走,也不出错,求教我这样写对吗?

------解决方案--------------------------------------------------------
http://blog.csdn.net/fangxinggood/article/details/655313
  相关解决方案