writing values to an excel sheet

Question

Hi , I want to write the textbox values to an excel sheet using c#. How do i do that?.. Pls help me.. Regards Emm..

Pero · Answer

Hi, you can do it easily with this Excel .NET library. See code snippet: ExcelFile ef = new ExcelFile(); // Adds new worksheet to excelFile. ExcelWorksheet ws = ef.Worksheets.Add("New worksheet"); // Sets the value of the cell "A1". ws.Cells["A1"].Value = "Hello world!"; // Saves the excel file. ef.SaveXls("excelFile.xls");

PJ Martins · Answer

You can use the Office interop libraries: References - Add Reference - Microsoft.Office.Interop.Excel Now you can do something like this: using Excel = Microsoft.Office.Interop.Excel; . . . object missing = Type .Missing; Excel. Application app = new Microsoft.Office.Interop.Excel. Application (); app.Visible = false ; Excel. Workbook wb = app.Workbooks.Add(missing); Excel. Worksheet sheet = (Excel. Worksheet )wb.Worksheets[1]; sheet.Cells[1, 1] = textBox1.Text; // display application app.Visible = true ; // save workbook //wb.SaveAs(@"c:	emp	emp.xlsx", missing, missing, missing, missing, missing, // Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, missing, missing, missing, missing, missing); //wb.Close(); //app.Quit();

writing values to an excel sheet

Answers (2)