how to write data into existing excel template using c#

Question

Hi all, can anyone please tell me how to write data into existing excel tempate here i have explained my tempate s.no Stdname Rollno above format is my template need to write data into that template

Tina Tang · Answer

Hi, there is a free API(https://www.nuget.org/packages/FreeSpire.XLS/) which supports creating an Excel file in C# with several rows of codes. Below is code snippet for your reference. using System.Drawing; using Spire.Xls; namespace Create_Excel_File { class Program { static void Main( string [] args) { //Initialize a new Workboook object Workbook workbook = new Workbook(); //Get the first worksheet Worksheet sheet = workbook.Worksheets[0]; //Write string values in a cell sheet.Range[ "A3" ].Text = "This Excel Document is Created by Spire.XLS for .NET" ; //Save workbook to disk workbook.SaveToFile( "Sample.xls" ,ExcelVersion.Version97to2003); try { System.Diagnostics.Process.Start(workbook.FileName); } catch { } } } }

Laxmidhar Sahoo · Answer

Hi Here two url may help you https://www.codeproject.com/Articles/33850/Generate-Excel-files-without-using-Microsoft-Excel Below is the api https://wiki.openoffice.org/wiki/API Thanks and regars

Jignesh Kumar · Answer

Hi siva Nathan, Please find below link which will help you, https://www.c-sharpcorner.com/article/create-update-delete-and-reading-the-excel-file-in-c-sharp/ Below code will give you number of existing rows. Excel.Range xlRange = xlWorkSheet.UsedRange; int rowNumber = xlRange.Rows.Count + 1;

how to write data into existing excel template using c#

Answers (3)