Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
How do i clear rows in Excel using EPPLus library ?
Nepethya Rana
6y
328
1
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.
}
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