C# to Open Existing Excel Workbook

Question

How would I open an existing Excel Workbook using C#? I have tried several guides I have seen on the internet, but none of them work succesfully for me :(

umer ali · Answer

using excel = Microsoft.Office.Interop.Excel; using System.Runtime.InteropServices.ComTypes; using System.Runtime.InteropServices; //add these assembly refrences ; try { excel.Application ex = new excel.Application(); ex.DisplayAlerts = true; ex.ShowStartupDialog = true; ex.Visible = true; excel.Workbook newwork = ex.Workbooks.Add();// create a new excel file OR string workbookPath = "Path.xls"; excel.Workbook excelWorkbook = ex.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); excel.Sheets excelSheets = excelWorkbook.Worksheets; excel.Worksheet excelWorksheet = (excel.Worksheet)excelSheets.get_Item("Sheet1"); excel.Range excelCell = (excel.Range)excelWorksheet.get_Range("A1", "A10"); } catch{} you can open an existing exelfile or you can add new excel workbook; please reply if this was helpful

CSharp Noob · Answer

Same issue running your code. It shouldn't be a permission issue...it is a file saved locally on my desktop. I am running Win 7 and Excel 2007.

Javeed M Shaikh · Answer

did you check if this is a permission issue when opening the file? are you running this on local machine or server? what is the OS and office version? I have this working at my end (Windows XP with office 2007): using System.Windows.Forms; using Excel = Microsoft.Office.Interop.Excel; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Excel.Application xlApp ; Excel.Workbook xlWorkBook ; Excel.Worksheet xlWorkSheet ; object misValue = System.Reflection.Missing.Value; xlApp = new Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Open("mytestfile.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "	", false, false, 0, true, 1, 0); } } }

CSharp Noob · Answer

All the codes I try give me a System.Runtime.InteropServices.COMException error. Here is one code that I try to use string mySheet = @"(F:\Workspace\Reports\Excel\Dailymenu.xls)"; var excelApp = new Excel.Application(); excelApp.Visible = true; Excel.Workbooks books = excelApp.Workbooks; Excel.Workbook sheet = books.Open(mySheet);

Javeed M Shaikh · Answer

can you provide the code that you have written which is not working, also take a look at MSDN: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.workbooks.open(v=office.11).aspx

C# to Open Existing Excel Workbook

Answers (5)