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();