Insert new record into Excel file using ExcelLibrary

RemontyYi

New Member
In my Asp.net application i have to create a Excel file. So i have used Excel Library to do this by following code my Excel file is created with some data.\[code\] ExcelLibrary.DataSetHelper.CreateWorkbook("C:\\dummy9.xls", ds);\[/code\]where \[code\]ds\[/code\] is my \[code\]Dataset\[/code\].Now i have to read this file and insert new record.\[code\]// open xls fileWorkbook book = Workbook.Load(file);Worksheet sheet = book.Worksheets[0];\[/code\]I dont know how i can add new row, also the Excel Library documention is not good enough
 
Back
Top