Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: DISP_E_TYPEMISMATCH while interop.excel
Subject: DISP_E_TYPEMISMATCH interop.excel
Hi: I need help in read excel sheet from C# using Interop.Excel.Application (Excel Data Library 10) and find & replace a word from a range in a sheet. I have following code which gives an error "DISP_E_TYPEMISMATCH". =============== m_objExcel = new Microsoft.Office.Interop.Excel.Application(); // open the workbook object by opening the excel file. m_objBook = m_objExcel.Workbooks.Open(filePath, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", true, false, 0, true, 1, 0); //m_objBook = (Microsoft.Office.Interop.Excel._Workbook)(m_objBo oks.get_Item(1)); m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)m_objBook.W orksheets; foreach (Microsoft.Office.Interop.Excel._Worksheet m_objSheet in m_objSheets) { m_objRange = m_objSheet.Cells; //m_objSheet.get_Range("A1", "AZ20"); } ==================== Any help would be appreciated. Thanks you in davance. SuneelP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: DISP_E_TYPEMISMATCH while interop.excel
On Jul 7, 12:04*am, SuneelP wrote:
Subject: DISP_E_TYPEMISMATCH interop.excel Hi: I need help in read excel sheet from C# using Interop.Excel.Application (Excel Data Library 10) and find & replace a word from a range in a sheet. I have following code which gives an error "DISP_E_TYPEMISMATCH". =============== m_objExcel = new Microsoft.Office.Interop.Excel.Application(); // open the workbook object by opening the excel file. m_objBook = m_objExcel.Workbooks.Open(filePath, * * * * * * * * * * * * * * * * * * * 0, * * * * * * * * * * * * * * * * * * * false, * * * * * * * * * * * * * * * * * * * 5, * * * * * * * * * * * * * * * * * * * "", * * * * * * * * * * * * * * * * * * * "", * * * * * * * * * * * * * * * * * * * true, * * * * * * * * * * * * * * * * * * * XlPlatform.xlWindows, * * * * * * * * * * * * * * * * * * * "\t", * * * * * * * * * * * * * * * * * * * true, * * * * * * * * * * * * * * * * * * * false, * * * * * * * * * * * * * * * * * * * 0, * * * * * * * * * * * * * * * * * * * true, * * * * * * * * * * * * * * * * * * * 1, * * * * * * * * * * * * * * * * * * * 0); //m_objBook = (Microsoft.Office.Interop.Excel._Workbook)(m_objBo oks.get_Item(1)); m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)m_objBook.W orksheets; foreach (Microsoft.Office.Interop.Excel._Worksheet m_objSheet in m_objSheets) { * * * * * * m_objRange = m_objSheet.Cells; //m_objSheet.get_Range("A1", "AZ20");} ==================== Any help would be appreciated. Thanks you in davance. SuneelP Which line throws the exception? I don't know if it works for you, but if you have small workbooks you can use our GemBox.Spreadsheet Free (http://www.gemboxsoftware.com/ GBSpreadsheetFree.htm) Excel component for XLS/CSV/XLSX reading/ writing/reporting. Automation causes many problems: http://www.gemboxsoftware.com/GBSpre...htm#Automation --Zeljko |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interop Excel | Excel Programming | |||
Interop Chart Series Error | Excel Programming | |||
Excel interop from c# | Excel Programming | |||
Microsoft.Office.Interop.Excel SaveAs error when clicking no or ca | Excel Programming | |||
Excel interop versions | Excel Programming |