Exception when I try to open an Excel file

Question

When I try to open an excel file to count her sheet number, I get a System.DllNotFoundException. The dll in question is the ole32.dll. Online I read that this dll is relative of windows, but I work with Visual Studio Comunity for MacOS. How I can resolve this problem?

This is the code:

using System;
using System.IO;
using Microsoft.Office.Interop.Excel;
using Excel = Microsoft.Office.Interop.Excel;

namespace Itec
{
    class MainClass
    {
        public static int countSheet(string file){

            int numSheet = 1;

            Application excelApp = new Application();
            Workbook workBook = excelApp.Workbooks.Open("d:/Book1.xls");

            numSheet = workBook.Sheets.Count;

            return numSheet;
        }

        public static void Main(string[] args)
        {
            string user, fileName, pathFile, ext;

            do
            {
                user = System.Security.Principal.WindowsIdentity.GetCurrent().Name;

                Console.WriteLine("Inserire il nome del file (se è in una cartella scrivere nel seguente formato \"nomeCartella/nomeFile.pdf\"): ");
                fileName = Console.ReadLine();
                pathFile = "/Users/" + user + "/Desktop/" + fileName;
                ext      = Path.GetExtension(pathFile);

                if (String.Equals(ext, ".xlsx"))
                {
                    if (File.Exists(pathFile))
                    {
                        countSheet(pathFile);
                    }
                    else
                    {
                        Console.WriteLine("Il file inserito non esiste");
                        Console.WriteLine("Premere invio per riprovare");
                        Console.ReadKey();
                    }
                }
                else
                {
                    Console.WriteLine("Estensione non corretta");
                    Console.WriteLine("Premere invio per riprovare");
                    Console.ReadKey();
                }

            }
            while (!String.Equals(ext, ".xlsx") && !File.Exists(pathFile)); 
        }
    }
}

To resolve, use Windows instead of Mac OS X. Alternatively use a platform-agnostic Excel library. Maybe EPPlus ist one. — Uwe Keim
– Uwe Keim, Commented Sep 29, 2017 at 9:26
first of all use try {} catch (Excetpion){} to avoid errors in your appliation. — Felix D.
– Felix D., Commented Sep 29, 2017 at 9:36
@FelixD. I use try {} catch (Excetpion){} but it does not solve the problem as it jumps the instruction — th3g3ntl3man
– th3g3ntl3man, Commented Sep 29, 2017 at 11:34

Chawin · Accepted Answer · 2017-09-29 12:41:25Z

1

Unfortunately Microsoft.Office.Interop.Excel won't work on Mac or Linux, as stated in this Github issue:

We have no plans to make Office COM APIs work on Mac or Linux. If the Office team produces docs on how to do this, we'd be happy to take a look. Closing as a result.

As an alternative I would recommened using EPPlus.

answered Sep 29, 2017 at 12:41

Chawin

1,4661 gold badge22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exception when I try to open an Excel file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related