excel-interop – Tarik Billa

How to close-without-save an Excel /xlsm workbook, w/ a custom function, from C#

January 3, 2024 by Tarik

When you use the Excel objects, be sure to close the workbook like this: Excel.Application xlApp ; Excel.Workbook xlWorkBook ; Excel.Worksheet xlWorkSheet ; object misValue = System.Reflection.Missing.Value; xlApp = new Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Add(“Yourworkbook”); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); ….do your stuff xlWorkBook.Close(false, misValue, misValue); xlApp.Quit(); The false in the close method indicates don’t save changes.

HRESULT: 0x800A03EC on Worksheet.range

December 30, 2023 by Tarik

This problem occurs if you are using a backwards compatible sheet (a .xls) instead of a .xlsx To allow sheets to be opened in pre office 2007 version it can’t contain more than 65k rows. You can check the number of rows in your sheet by using ctrl+arrowdown till you hit the bottom. If you … Read more

Class not registered error when creating Excel workbook in C#

August 30, 2023 by Tarik

I had this exact same problem. Here’s how I fixed it: Go to HKEY_CLASSES_ROOT\TypeLib\ and search for Office.Interop.Excel. I found HKEY_CLASSES_ROOT\TypeLib\(guid)\1.8 but its child nodes were empty! I deleted it because Office 15 wasn’t installed on that machine, and hey presto – it worked. Either our VSTO project installer, or our own custom installer must … Read more

System.Runtime.InteropServices.COMException (0x800A03EC)

August 28, 2023 by Tarik

Found Answer…….!!!!!!! Officially Microsoft Office 2003 Interop is not supported on Windows server 2008 by Microsoft. But after a lot of permutations & combinations with the code and search, we came across one solution which works for our scenario. The solution is to plug the difference between the way Windows 2003 and 2008 maintains its … Read more

Cannot close Excel.exe after Interop process

August 26, 2023 by Tarik

Simple rule: avoid using double-dot-calling expressions, such as this: var workbook = excel.Workbooks.Open(/*params*/) …because in this way you create RCW objects not only for workbook, but for Workbooks, and you should release it too (which is not possible if a reference to the object is not maintained). So, the right way will be: var workbooks … Read more

Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’

July 13, 2023 by Tarik

Try this: Create the directory C:\Windows\SysWOW64\config\systemprofile\Desktop (for the 32-bit version of Excel/Office on a 64-bit Windows computer) or C:\Windows\System32\config\systemprofile\Desktop (for a 32-bit version of Office on a 32-bit Windows computer or a 64-bit version of Office on a 64-bit Windows computer). For the Desktop directory, add Full control permissions for the relevant user (for example … Read more

Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))

May 23, 2023 by Tarik

Using DCOMCNFG.exe. Open it and go to: Component Services -> Computers -> My Computer -> DCOM Config -> Microsoft Excel Application. Open the properties, select Identity tab and select the interactive user.

How to count the number of rows in excel with data?

May 14, 2023 by Tarik

I like this way: ActiveSheet.UsedRange.Rows.Count The same can be done with columns count. For me, always work. But, if you have data in another column, the code above will consider them too, because the code is looking for all cell range in the sheet.

How do I auto size columns through the Excel interop objects?

February 19, 2023 by Tarik

Add this at your TODO point: aRange.Columns.AutoFit();

Optimal way to Read an Excel file (.xls/.xlsx)

January 29, 2023 by Tarik

Take a look at Linq-to-Excel. It’s pretty neat. var book = new LinqToExcel.ExcelQueryFactory(@”File.xlsx”); var query = from row in book.Worksheet(“Stock Entry”) let item = new { Code = row[“Code”].Cast<string>(), Supplier = row[“Supplier”].Cast<string>(), Ref = row[“Ref”].Cast<string>(), } where item.Supplier == “Walmart” select item; It also allows for strongly-typed row access too.