Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

creating simple excel sheet in c# with strings as input

Tags:

I am working on creating EXcel sheet in C#.

No Of columns:4 Name of columns: SNO, Name, ID, Address 

There is no constarint on number of rows.

         SNO   Name      ID   Address           1     A         1122  XXXX           2     B         2211  YYYY            --- ---        ----    --- 

I have strings as input

       string sno, string name, string Id, string address 

I am actually new to C# background.

Can any one share their view on it like dlls needed etc.

Thank you

like image 935
Patan Avatar asked Apr 11 '12 06:04

Patan


1 Answers

If you include a reference to Excel Interop you can do whatever you please having Office installed on your system.

A little example:

using Excel = Microsoft.Office.Interop.Excel;  Excel.Application excel = new Excel.Application(); excel.Visible = true; Excel.Workbook wb = excel.Workbooks.Open(excel_filename); Excel.Worksheet sh = wb.Sheets.Add(); sh.Name = "TestSheet"; sh.Cells[1, "A"].Value2 = "SNO"; sh.Cells[2, "B"].Value2 = "A"; sh.Cells[2, "C"].Value2 = "1122"; wb.Close(true); excel.Quit();             
like image 96
Marco Avatar answered Oct 30 '22 11:10

Marco