C# to Open Existing Excel Workbook

CSharp Noob

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 :(

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

umer ali11y ago
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 Noob13y ago
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 Shaikh13y ago
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, "\t", false, false, 0, true, 1, 0);
}
}
}
CSharp Noob13y ago
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 Shaikh13y ago
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