I created a website project and I want in that website to be make a button, which will export some data in an excel file. This is the code that I have:
Expand|Select|Wrap|Line Numbers
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using Excel = Microsoft.Office.Interop.Excel;
- namespace TU_Sofia_PublicationSystem
- {
- public partial class Default : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void ExportToExcel(object sender, EventArgs e)
- {
- Excel.Application excelApp = new Excel.Application();
- excelApp.Workbooks.Add();
- Excel._Worksheet workSheet = excelApp.ActiveSheet;
- workSheet.Cells[1, "A"] = "Make";
- workSheet.Cells[1, "B"] = "Colorqqqqqqqqq";
- workSheet.Cells[1, "C"] = "Pet Namesdvbpofsdajnvbdajbi";
- workSheet.SaveAs(@"C:\Inventory.xlsx", Excel.XlFileFormat.xlWorkbookDefault, Excel.XlSaveAsAccessMode.xlNoChange);
- excelApp.Workbooks.Close();
- excelApp.Quit();
- excelApp = null;
- }
- }
Microsoft Excel cannot access the file 'C:\094B4000'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
I suppose that this is tottaly not the way that I have to do it; however I was unable to find some valuable information using Google and a lots of books that I have(from Apress).
Any help like code, or like in which book can I find information is highly appreciated.