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
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();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With