how to solve :Exception from HRESULT: 0x800A03EC

Question

I am creating an application in which user has to upload the excel file, using below code i am validating the file whether it is valid or corrupted. For this i am using mircrosoft.Office.interop.excel dll. In below code, I am getting exception " Exception from HRESULT: 0x800A03EC"

static void openfile()
        {
            try
            {
                string mySheet = @"E:\7.xlsx";
                var excelApp = new Excel.Application();
                excelApp.Visible = true;
                Excel.Workbooks books = excelApp.Workbooks;
                Excel.Workbook sheet = books.Open(mySheet);
            }

            catch (Exception ex)
            {

                Console.WriteLine(ex.Message);
            }



        }


        static void Main(string[] args)
        {
            openfile();
        }

What is the issue? Could you please help on this issue?

Possible duplicates: [1](http://stackoverflow.com/q/7099770/119527), [2](http://stackoverflow.com/q/12714626/119527) Found by simply Googling for `0x800A03EC` — Jonathon Reinhart, Mar 16 '15 at 05:59

Vojtěch Dohnal · Answer 1 · 2015-03-16T12:26:00.060

0

Try to use this instead:

string mySheet = @"E:\7.xlsx";
var excelApp = new Excel.Application();
excelApp.Visible = true;
Excel.Workbook sheet = excelApp.Workbooks.Open(mySheet,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, true);

I guess your file E:\7.xlsx is somewhat corrupt. Also you can try to open it normally and see what happens.

But if you just want to know, whether the file is corrupt or not, this exception gives you the information: yes, the file is corrupt.

edited Mar 16 '15 at 12:26

answered Mar 16 '15 at 07:45

Vojtěch Dohnal

7,867
3
43
105

what is this books how can i merge this with my code – Bheeshamteche Mar 16 '15 at 11:56
@Bheeshamteche `books` is a local variable that you have declared in your code.... Updated answer. – Vojtěch Dohnal Mar 16 '15 at 12:25

Nalaka · Answer 2 · 2015-03-16T12:52:16.617

0

open console project and Try this... This is working properly.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Globalization;
using Microsoft.Office.Interop.Excel;

namespace ConsoleApplication1
{
class Program
{
    static void Main(string[] args)
    {

        try
        {
            string mySheet = @"E:\7.xlsx";
            Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
            excelApp.Visible = true;
            Workbook wb = excelApp.Workbooks.Open(mySheet);
        }
        catch (Exception ex)
        {

            Console.WriteLine(ex.Message);
        }

        Console.ReadLine();
    }
 }
 }

edited Mar 16 '15 at 12:52

answered Mar 16 '15 at 08:05

Nalaka

1,165
7
12

Try again. this is full code. create test console project and replace this code. – Nalaka Mar 16 '15 at 12:53
Cannot see any substantial difference between OP and this answer. – Vojtěch Dohnal Mar 16 '15 at 13:15

how to solve :Exception from HRESULT: 0x800A03EC

2 Answers2