Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
How do i clear rows in Excel using EPPLus library ?
Nepethya Rana
Oct 18 2017 4:30 PM
314
Reply
How do i clear rows in Excel using EPPLus library ?
Right now I am providing hard code value as I know the number of rows in excel that has data in it.
I would like my program knows how to clear the excel and import new data everytime in excel sheet.
How do i acheieve this ?
My code :
using (ExcelPackage xlPackage = new ExcelPackage(new System.IO.FileInfo(sourcefile + fileName)))
{
ExcelWorksheet ws = xlPackage.Workbook.Worksheets[myWS];
ws.DeleteRow(2, 300);
// Other codes to import data.
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
how to convert uri response of text/html chartset:iso-8859-1
[Discussion] - Best class to CRUED