Excel Work Book Open Issue

Hi All,

When I am open Excel through work book I got the below error

Exception from HRESULT: 0x800A03EC

I am posting my code Below

Dim xlApp As New xl.Application
        Dim oldCulture As System.Globalization.CultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture
        'Initialize Excel
        System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-us")
        Try
            'Open and unlock the Excel document
            '' xlApp.Workbooks.Open(path) // Here I got the error
            Dim wb As xl.Workbook
            Dim ws As xl.Worksheet
            xlApp.Workbooks.Open(path)
            wb = xlApp.Workbooks(1)
            ws = DirectCast(wb.Worksheets(1), xl.Worksheet)
            ws.Unprotect()
            xlApp.Visible = True
        Catch ex As Exception
            Dim innerException As String = String.Empty
            If Not ex.InnerException Is Nothing Then innerException = ex.InnerException.Message
            MessageBox.Show(BCConstants.ERROR_HEADER_DEFAULT + " " + ex.Message + vbCrLf + innerException + vbCrLf + BCConstants.ERROR_MESSAGE_GENERAL, "PCCT", MessageBoxButtons.OK, MessageBoxIcon.Error)
            If Not xlApp Is Nothing Then
                If xlApp.Workbooks.Count > 0 Then xlApp.Workbooks(1).Saved = True 'Avoid questions when quitting excel
                xlApp.Quit()
                xlApp = Nothing
                GC.Collect()
            End If
        Finally

Thanks in Advance.

Regards,

Naresh.Pydi

Re: Excel Work Book Open Issue

what is the path?

And please try

Dim xlApp As xl.Application

set xlApp = new xl.Application

Does the set line throws same error?

Re: Excel Work Book Open Issue

Thanks for Your reply..

I am trying with your suggestion but its still showing the same error and the path is below...

Friend Sub ExportToExcel()
        Dim path As String
        Dim LOGON32_LOGON_INTERACTIVE As Integer = 2
        Dim LOGON32_PROVIDER_DEFAULT As Integer = 0
        path = GetUniqueFileName()
        Utils.CheckAndCreateFolders(path)
        UnhideColumns()
        'ClearAllFilters()
        Dim officeVersion As String = Utils.GetOfficeVersion()
        If officeVersion = BCConstants.OFFICE_VERSION_2010_14 Then
            costEstimateFpSpread.SaveExcel(path, FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat Or FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders)
        Else
            costEstimateFpSpread.SaveExcel(path, FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly)

        End If
        HideColumns()
        OpenAndUnlockExcel(path)

End Sub

Regrads,

Naresh.Pydi

Re: Excel Work Book Open Issue

the same error in the same line or in another line ( the

set

line

)

ANd what's

path = GetUniqueFileName()

It's an api or code in your project? Where does creates...?

Re: Excel Work Book Open Issue

Same Line and the Path is My Local Folder .........

Re: Excel Work Book Open Issue

suresh.pydi
Path is My Local Folder .........

FOr asp.net it does not exists "my local folder". Please make a folder in the website, put read/write attributes and make there your work

Re: Excel Work Book Open Issue

Hi,

I did n't get you My local path means

C:\Documents and Settings\v0c1524\Local Settings\Temp\PCCT

and I am using VB.net not Asp.net

Regards,

Naresh.Pydi

Re: Excel Work Book Open Issue

suresh.pydi
and I am using VB.net not Asp.net

What kind of application do you have? WCF ? Windows Forms? WebForms? MVC ? Other?

Re: Excel Work Book Open Issue

Hi ,

Thank you so much for your Replies

and I am using Winforms... and the problem it comes when I am doing some Filters in spreadsheet at that time I am Importing the Data into Excel File

Regards,

Naresh.Pydi

Re: Excel Work Book Open Issue

http://www.made4dotnet.com/Default.aspx?tabid=141&aid=15

Re: Excel Work Book Open Issue

HI,

I already tried with this Link but its not helpful for me...

Regards,

Naresh.Pydi

Re: Excel Work Book Open Issue

Hi,

Anyone have any Idea about Disable the filters in Excel In VB.Net I need disable the filters before Open the Excel File

Regards,

Naresh.Pydi

Re: Excel Work Book Open Issue

Hi,

You can refer to the below link about the question. The same question you have posted again.

http://forums.asp.net/p/1744514/4711570.aspx/1?p=True&t=634583881501574410