I am also getting the same exception and i am also stuck on it.

i'm having the same issue, did you end up figuring it out?

value2 returs all values from a specific cell, regardless if it's null (returns as empty string), if you want to grab everything from a sheet one of the later tutorials shows how to do it, I think it's No5, you also have in the comment how to grab only used cells

File -> New -> Project -> Windows Forms Project (or Windows Forms App depending on the version). That also answers your question about lines 1-12, auto generated code.

the problem has been solved

Do post a solution please, just in case someone else manages to stumble at the same problem.

I was just entering a wrong Path, once I get it corrected, it's been solved.

If I had a dollar every time that happened to me... I wouldn't need a job any more :D

not needed, there's nothing conflicted.

Excel file goes in Documents folder if you're not changing the path. As for the error ether create a Forms project that auto generates main in Program.cs or put the code for Load method inside Console projects main method. Can't mix and match console and form projects.

_Application is an object within Interop.Excel library, just make sure you have all using statements. If it still persists you can do _Excel.Application excel = new _Excel.Application();

@@TheBospear Interesting, I had my Excel class named something other than "Excel" so that's why it caused errors. I named it "Excel_Stuff.cs" because it was just a learning exercise. Is there a reason this class has to be named so definitively?

@@coyotemoon722 It shouldn't, I guess it came to some naming polymorphism between interop library and the class. I'll check it out one of these days to see what's up.

I have the some error. It might have something to do with the VS version. Mine is VS2013

Never tried, honestly I only work with data. I guess you imported data that make that chart, so you can use that data to make a chart in the form. msdn.microsoft.com/en-us/library/dd489237.aspx

Objects don't have to be declared as new, they can be assigned straight from the initialization. Let's say you have a string that you want to have the value of "text". You can do String temp = new String(); temp = "text"; or you can do it straight away: string temp = "text"; You have created the object of type string temp with the "string temp" and now you only have to assign a value to it.

@@TheBospearI clearly understand now, thank you so much!

I wonder why it sees it as object, older library maybe. In any case just cast it: ws = (Worksheet)wb.Worksheets[Sheet]; or: ws = wb.Worksheets[Sheet] as Worksheet;

@@TheBospear " ws = (Worksheet)wb.Worksheets[Sheet];" fixed the problem

@@luisurenaalex2183 thx dude it's worked

@@TheBospear Thanks!

Blank path leads to Documents, you can just enter @"C:\Your Path\Test.xlsx" and target where ever you want.

​@@TheBospear I have tried @"C:\path\to\my\excel.xlsx" but it just doesn't work. VS says it can't find the specific file. .NET Core 3.1 WPF

@@TheBospear I'm using Office 16. It seems like the package only applies to Office 15.

@@user-lz4rj5se7z Add open file dialog then www.c-sharpcorner.com/UploadFile/mahesh/openfiledialog-in-C-Sharp/ and take it's path as the target file to avoid any confusion.

Yes.

:(

I think you can download Microsoft.Office.Interop.Excel NuGet package to get the reference you need.

files-cdn.cnblogs.com/files/fan0136/Microsoft.Office.Interop.Excel.rar you can use this link to download the .dll, add this to the solution as reference and the Interlop namespace will be available

Documents

@"Test.xlsx" is in my documents for the excel interop, not in the root folder. I guess that's the problem. Try with a global path like @"C:\ExcelTestFolder\Test.xlsx"

Thanks for the reply. I now created a folder straight in C:\ called 'excel test folder' and put the 'TEST.xlsx' document in it. In the program i wrote this: 'string path = @"C:\excel test folder\TEST.xlsx";' and it doesnt work. I also tried typing two backslashes (\\) instead of one but I always end up with the same error... Im almost losing it... In any case, thanks for the video and the reply in the first place.

Always. Are you sure it's xlsx and not xls or xlsm?

@@billmaragos2812 It worked for me by avoiding space in folder name. I hope, it would work for you too.

@@jorgateme thanks for the reply !

Because when you have a class named Excel and a method named Excel that method is a constructor of the class and doesn't require a return type. If you want to rename ether of those just add void before your method name.

honestly not even trying to sooth. but just to the point no jargon.

Nvm, i saw the problem xD

he has return type in the method that was created as string with two returns in the body probably doesn't need the else part but that a different story.... for the constructor which is the public Excel , it is called in the main method with an initialization using new So in the static void Main{string [ ] , args) { Excel excel = new Excel("pathOfFile", 1);} //that is in the program.cs file, I would first make sure you're not trying to call the Excel object like a method in the program file, then check that you wrote the constructor correctly.

Done nothing to the design, you can run the same code on console or dll (which is kind of a plan at the end of the series), but the path shown in the video is targeting Documents, so check if you have a correct path for the file you have.

Hey man thanks for the maintenance you do on here. I realized a piece of code was misplaced, had to move it and it was good to go. Your explanation for document root path is great, thank you.

You're very welcome.

Sadly it does. As far as I can see Excel Object Library is not supported on Mac and by Microsoft OSX is not suitable environment for interchanging COM objects. Sorry.

Microsoft at one point decided that we have to be protected from our own conversion..... so just do return (String)ws.Cells[i,j].Value2 or return ws.Cells[i,j].Value2 as String.

Remove using Microsoft.Office.Interop.Excel from the main class. Problem is you are calling custom class Excel and it's confusing it with dll Excel class.

@@TheBospear I got this same problem but ı cant solved

try doing for loop?

Yep, already

You got to loop for it, row by row, cell by cell. Treat it like a matrix. Only problem you can have with it is date and time writing and reading. I'll do a video soon on it and post the whole class to github.

wo muss die Testdatei abgespeichert werden?

You might want to go with english since google translate isn't all that good. Default path is Documents or My Document on older windows versions. Otherwize you can make a custom path to any location.

Separate classes based on their logical wholes. Program.cs is a default class that any c# project uses, Excel.cs is made to handle just Excel calls. But you shoot look in to tutorial about Object oriented programming a bit more in depth before continuing, it will do you more good.

@@TheBospear Thank you .Then I will .

Did you ever find a solution for this? I'm having the exact same problem

I just didn't type .Value2 and it worked for me

​@@zanekross9649 Sorry for the late response. This was a very old project I was in and I don't really remember. I hope you find ​ @Adomas B 's respnse convenient

There is a publisher interop library, but I haven't used publisher before so no idea how to use the library.

yes i know but i dont know how to use it. is there any alternative way for me to print the data from database coz i need to print after searching it, TIA

Here's a couple of links that might help: Opening and exporting a file. csharp.hotexamples.com/examples/Microsoft.Office.Interop.Publisher/Application/Open/php-application-open-method-examples.html Reading and manipulating text. www.vbforums.com/showthread.php?554733-Find-and-replace-text-in-MS-Publisher-file Last one is in VB, but interop works the same so you can rewrite it in c# in few minutes.

If I can remember correctly this was C# 7.0

@@TheBospear hiii bospear! can you give me your email? im working on a specific App that deals with excel values and i have no idea from where to start,,, i really apreciate your help thanks

for(int i = 0; i < 10; i++) { excel.ReadCell(i, 0); } You can also select a specific range and read all cells from it, but I will make tutorial on it later, sometime january if nothing else happens. In the meantime here's a stackoverflow link for it: stackoverflow.com/questions/2627343/read-all-the-cell-values-from-an-excel-range-in-c-sharp

Install excel, lib comes with it. Or you can get it from nuget www.nuget.org/packages/Microsoft.Office.Interop.Excel

I'm going to need more info than that. Where does it break, what's the error message and your code snippet from the method where it breaks

It does. In fact I think the videos were recorded on 365, and the OG project I did before deciding to make these videos was on 365

stackoverflow.com/questions/19888326/cannot-implicitly-convert-type-object-to-microsoft-office-interop-excel-works

type ws = (Worksheet)wb.Worksheets[sheet];

Good question. You're not instantiating an interface, you're instantiating an abstract class inheriting it (or at least I think it's an abstract class, been a while since I looked it up) and VS is just reporting it as interface

Sory, concrete class, not abstract class.

No, when you use forms in C# you generally don't do anything with Main function, unless you need to pass outside arguments. What are you getting as a result?

I can get nothing from the program, I think it directly runs the empty Main(). Firstly I created Console application which is the program.cs, then I added a class(Excel.cs) and Form with the "Load" event handler, but I can get nothing. Thank you so much sir!

Yea, that will happen if you make a console application and add form later. So just add the main form at the start. Write in Main() this: Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); new Form1 is the name of the start Form you made.

Thanks! Will try later!

Sir, do you have any idea on this error happens in the code "wb = excel.Workbooks.Open(path);" : "Cannot convert COM object 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application" (p.s. The message is not directly copied from visual studio as I am not using English language pack, I tried to translate the error message into English) Thank you so much!

Framework only and yes you can open other sheets, both by their name and their number.

Thanks for the confirmation and video 😁💪💪

@@Cmerk10 Excel ex = new Excel("excel.xlsx", 2); number is the sheet number

@@TheBospear Yes, excatly, my mistake!. Because i am working with two excel files. The second worksheet was added in only one of them. In my program i was calling the other file. Anyway thank you again !

post the line of code that's giving you the error

my main method in prgoram.cs looks like this: static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); } Form1 looks like this: public partial class Form1 : Form { public Form1() { InitializeComponent(); } public void Form1_Load(object sender, EventArgs e) { OpenFile(); } public void OpenFile() { Excel excel = new Excel(@"emails.xlsx", 1); MessageBox.Show(excel.ReadCell(0, 0)); } }

@@frankringwald4315 Breakpoint on OpenFile method, start stepping through and see where it breaks.

Easiest way would be int i = 0; while(true) { if(string.IsNullOrEmpty(excel.readcell(i, 0)) break; i++; }

@@TheBospear Thank you so much ! :)

Search through solution for that type name, you have declarations named the same thing in another class, or skip VS2013 and go to VS2017. Also check docs.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/partial-classes-and-methods just so that you have full documentation on it.

Thank you so much

What you can do is instead of MessageBox.Show(excel.readCell(0,0)) do string temp = excel.readCell(0,0); MessageBox.Show(temp); Breakpoint on messagebox line and see if temp has a value (hover over it with a mouse) of the excel cell. Depending on that we can see what's going on. (Just a heads up, path for file is C:\Users\"Current User"\Documents\TEST.xlsx")

Access to interop objects in WPF is the same as Forms, I guess that office version, and interop lib with it, is different. I suggest you read following two: learn.microsoft.com/en-us/dotnet/csharp/advanced-topics/interop/how-to-access-office-interop-objects stackoverflow.com/questions/68981380/load-the-excel-file-which-i-open-using-dialog-box-in-wpf-into-datagrid-when-i-cl

Documents.

same way you do a string, only replace it with int. So it's int value = (int)ws.ReadCell(0,0);

Worked with 14 when I started making excel automaton. Don't know about older than 14 but newer will work. Also there should be NuGet packs for 14, 15 and 16 which should be a free download.

think you can download Microsoft.Office.Interop.Excel NuGet package to get the reference you need

The only way for it to work is in build.... did you mean release? In which case yes, release is just a few flags and not building debug files.

Like I said, Rusty...I was missing code in the initializecomponent from the form1.designer.cs. I just used the events window to make sure it loaded (lazy lol).

@@pop2mcar Piece of advice when working with forms, don't stacktrace from Program.cs, it's there only to start the form class as a single thread apartment. Constructor is usually there only to set constants and initialize controls/events. In this case start from Form_Load event, it triggers when all controls in the form are loaded. Actually always start to trace from an event rather than a constructor when working with a form, be it Load, or Click etc.

Yea, my bad. In later videos I made the close statement but that one is bad as well. Just put a new method in the Excel class public void Close() { wb.Close(0); } and than call it after the read from the form. As for file you opened right now just kill excel.exe processes from task manager and that will clear it up.

Thank you so much! I just spent the last 2 hours trying to figure it out on my own.

2 hours is a lot :)

@@TheBospear I placed above code in the Excel class without any errors. But I added below in the Form1.cs and "Close()" does not appear to recognized as the Excel class and Close method but instead just closes the form. private void button2_Click(object sender, EventArgs e) { Close(); }

@@slazper Object oriented programming, you need to call a method in the object (instance of class) you want. Close in Form is upon Form object, Excel excel = new Excel(...); excel.Close(); works upon Excel object. I suggest you look in to C# and Object oriented programming tutorials if you want to make a c# app with this first. It's a really big gap in knowledge you need to fill if comments here are to be effective.

Functionally nothing, but this is lighter weight for using just a library and not a whole add on.

Check References for Microsoft.CSharp reference, if it's there remove it then add it back if it's not just add it. That error is always tied to Microsoft.CSharp.dll as far as I've seen.

thank u but it's not working.when I added again ,errors were gone. after debugging again, Error appears :(

Strange. Are you using any dynamic calls?

Doubt it, more likely it's the library version, Microsoft really did a number on interop libraries (hence the need for these videos). What are the errors and what version interop dll are you using?

15.0 library. try with ((Excel.Range)wb.cells[i,j]).Value2

check this code here is the problem solved: ---- using System; using Microsoft.Office.Interop.Excel; using _Excel = Microsoft.Office.Interop.Excel; namespace mysheet { class Excel { string path = ""; _Application excel = new _Excel.Application(); Workbook wb; Worksheet ws; static void Main(string[] args) { Excel excel = new Excel("C:\\Temp\\baldo.xlsx",1); Console.WriteLine(excel.readCell(0,0)); // Excel(@"C:\Temp\baldo.xls", 1); //Excel("C:\\Temp\\baldo.xls", 1); } public Excel(String path, int Sheet) { this.path = path; wb = excel.Workbooks.Open(path); ws = wb.Worksheets[Sheet]; Console.WriteLine("Hello World!"); } public string readCell(int i, int j) { i++; j++; if (((_Excel.Range)ws.Cells[i, j]).Value2 != null) return ((_Excel.Range)ws.Cells[i, j]).Value2; else return ""; } public void writeToCell(int i, int j, string s) { } } }

Hm, there are few possibilities, can you paste the error here so that I can take a look?

I got it to work. I think there was an issue with linking to the class itself. I was trying to write a standalone class so I can move this to separate projects. I went back and made the class inside the original project and it worked. So I slowly worked forward and got the functionality that you had and then moved it to a stand alone class and linked to it and it worked. So. Magic.

Yeey. At some point when I get time to continue this tutorial I'll do all necessary things and then make a library out of the class and post it, because I also used original of this class for a bunch of projects.

It's 365, however a lot of versions are on the same standard, so this gives you a place to start, now google excel 2019 interop and find the parallels

@@TheBospear I can see that you have first another window that is not "Form1" and after you close this, it shows you "Form1". I only had the "Form1" window that does not show us nothing, do you follow me?... I tried at visual studio 2016 is the same thing...

@@eladiogonzalezruiz2112 That's a message box window. It's the Messagebox.Show line of code that makes that appear.

@@TheBospear Yes I get it, I have this "Messagebox.Show" but still does not appear me when I run it, what problem I have if this happens?

@@eladiogonzalezruiz2112 One of about a million. Check if the window exists, if not post the code here so I can take a look.

Form1_Load gets called when Form UI is generated. So if you started a console rather than a Form app Form1_Load will not be called. Also, Form1_Load is an event listener, you make the even by double clicking Form UI in the UI tab or by adding the event in form properties (or you can make event by your self but why would you do that manually)

@@TheBospear thk for the help. When I create the project I used the Form app. I am new to Visual Studio so I did not catch your suggestion. Could you be more specific? Thk

@@roccoguarino9136 It doesn't get any more specific than that unless I picture guide you. So this might be better kzfaq.info/get/bejne/jrFgq7uC2d_Yj4k.html

@@TheBospear thk you so much

I have the same problem. After i close the app a window appears which opens the excel file. I tried the wb variable public and close like you said, but i got this error as exception : System.Runtime.InteroopServices.COMException: '0x800401A8'. I tried also other functions for release the object like System.Runtime.InteroopServices.Marshal.ReleaseObject(wb) but i got stuck. I found a function which closes all excel files ( //using System.Diagnostics; Process[ ] excelProcs = Process.GetProcessByName("EXCEL"); foreach(Process proc in excelProcs) { proc.Kill(); } ) but it is not recommended

@@andreeanita9135 Share your code i might be able to figure out the issue.

I don't remember making an application() method

No I am asking you I have written code like Application obj= new application(); And I have use namespace is Microsoft.Office.interop.excel. When my cursor coming to application () method it is throwing exception please reply

@@rajeshkale7849 Ok, first of, namespace should be name of the project, or name of a part of the project, you cannot use a library name as a namespace. Second, I can't know what problem you have in a code I haven't written or seen. Ether follow the tutorial or post your custom code.

You're missing a dependency, install Excel it self.

@@TheBospear Thanks a lot for a quick reply. Didnt expect a reply from you. I figured out what the issue was. I was creating a new project with Console App(.NET CORE), I was supposed to do it with .NET Framework. I just finished with all your videos. It was short and really helpful. Thanks

Make a Forms project to follow this step by step, not Class Library or Console application. Alternatively I suggest looking in to basic C# tutorials

Think you're missing initialize in the Form constructor, which is strange since it's a default call when you make a form. As for location it's in Documents.

So did you find out what was missing? Have the same problem and your work-around just helped, but what is missing?

@@JasonACharles Form_Load method was missing, double click the form and it will be added automatically.

@@TheBospear thx, that did the trick

What version of interop are you using and also can you paste your excel class code here so I can take a look?

AppDomain.CurrentDomain.BaseDirectory

Thank you! Another question: can I find out the count of non-empty cells in a column? I need to take a random cell in a column: int Rand = R.Next(1, ???);

@@qlBlitzlp just go through the column and test for string.IsNullOrEmpty

Thanks! I thought there was a special function for this.

This is kind of a specific tutorial, made to show people how to use interop at the time when microsoft didn't have proper documentation for it. If you want to count rows/columns as per new microsoft documentation TargetWorksheet1.UsedRange.Rows.Count - 1; same for columns. As for the database part that's a gigantic question, and I suggest you look up C# integration for the specific database you need.

By looping through the data you get from this code, making new rows on datagridview equal to number of rows of data, and then writing cell by cell

Dis u got a solution? I am also facing same issue at value2...

Event handler for Form Load event. Do not attempt to just copy the code without basic C# knowledge, you will just give your self a headache. Do a basic C# tutorials first, it shouldn't take more than a week or two, then start making stuff.

There could be a number of things, different library, com bug, wrong object lookup etc. post your code here and let me take a look to eliminate most of the possibilities

@@TheBospear I ended up being able to access it but I had to use the worksheet as a range

@@AlexPitsi Could be a newer or older library, or a com bug... it happens more often than it doesn't

@@TheBospear How do u use it as a range?

@@garrfildcsgomore4609 ((_Excel.Range)ws.Cells[i,j]).Value2

Value, Text etc.

@@TheBospear Couldn't find any way. Finally NuGet LinqToExcel did the job

Add the location of the network drive and path to the file in the path variable. So it's exactly the same way you would do on local. If your network drive requires admin rights access run the app or VS as admin.

thank you very much for this i have another question pls: i did create a simple form with a button, i need this button to open a folder and this folder exist in one of our servers do you have this code pls many thanks

@@microsecure2612 If you want to choose a file from that folder to load the path do the open file dialog with network location as the default (microsoft has example in documentation, can't write it out on a phone). If you just want to open in explorer I think System.Diagnostics.Process.Start targeting the folder would do the trick.

@@TheBospear Thank u very much for ur info: Is it possible to have ur email address then i can email u back my simple code to check it pls ? Thx

@@microsecure2612 pastebin it here, however I'm not sure when I'll have the time to review it. Could take few days

If you're calling it from Main (I'm guessing you did a console app) you need to ether make an object first or make the method you're calling a static method.