HRESULT: 0x800A03EC on Worksheet.range

by

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 try to get a range larger than that number of rows it will create an error

More Related Contents:

  1. Excel Interop – Efficiency and performance
  2. Fastest method to remove Empty rows and Columns From Excel Files using Interop
  3. Export the dataGridView to Excel with all the cells format
  4. Closing Excel Application Process in C# after Data Access
  5. Cannot close Excel.exe after Interop process
  6. Fastest way to interface between live (unsaved) Excel data and C# objects
  7. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  8. How to open an Excel file in C#?
  9. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  10. How to reference Microsoft.Office.Interop.Excel dll?
  11. How do I create a real-time Excel automation add-in in C# using RtdServer?
  12. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  13. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  14. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  15. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  16. extract image from word file
  17. Comboboxes are linked for some reason
  18. Please explain why I am able to instantiate the “Application” interface in Excel VSTO
  19. Optimal way to Read an Excel file (.xls/.xlsx)
  20. How to know if a cell has an error in the formula in C#
  21. Excel CustomTaskPane with WebBrowser control – keyboard/focus issues
  22. How to send a mail using Microsoft.Office.Interop.Outlook.MailItem by specifying the From Address
  23. How do I auto size columns through the Excel interop objects?
  24. How do I get an Excel range using row and column numbers in VSTO / C#?
  25. Detecting a password-protected document
  26. Moq & Interop Types: works in VS2012, fails in VS2010?
  27. Accessing an open Excel Workbook in C#
  28. Best practice to return errors in ASP.NET Web API
  29. process.start() arguments
  30. Client is unauthorized to retrieve access tokens using this method Gmail API C#

Leave a Comment