How to remove Blank Rows using EPPlus Excel Package Plus

0 votes
I want to transform my Excel sheet into a datatable using EPPlus 4.1.0.0. The final few rows of the excel file are empty. I am therefore adding the empty rows to the datatable when I convert it. Prior to converting it to a datatable, how can I get rid of the empty rows?
Oct 3, 2022 in Others by Kithuzzz
• 38,010 points
2,831 views

1 answer to this question.

0 votes

Check this answer here: https://stackoverflow.com/a/49232456/1114531

It is checking the last row if it is empty and if yes it deletes it and does this until finds a non-empty row. (non-empty means here: all columns in this row have some value).

answered Oct 3, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

How to remove borders from cells in a range in Excel using VB.net?

range.Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeRight).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeBottom).LineStyle ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,720 points
1,426 views
0 votes
1 answer

How to hide blank rows in an excel form if they are blank

If an empty row should be defined ...READ MORE

answered Feb 13, 2023 in Others by narikkadan
• 63,720 points
588 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
877 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
1,215 views
0 votes
1 answer
0 votes
2 answers

Is there a .NET equivalent to Apache Hadoop?

Hadoop is a Java-based platform. So, to ...READ MORE

answered Jul 16, 2020 in Big Data Hadoop by Suhana
• 340 points
1,541 views
0 votes
1 answer

Validate String against USPS State Abbreviations

Try something like this: private static String states ...READ MORE

answered Sep 20, 2018 in IoT (Internet of Things) by Annie97
• 2,160 points
777 views
0 votes
1 answer

How to automatically nest rows of an Excel spreadsheet using level values?

More grouping levels have been added to ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 63,720 points
554 views
0 votes
1 answer

Excel How to Remove Duplicate Rows in multiple of 3 Same Value

Put the following formula into a helper ...READ MORE

answered Dec 28, 2022 in Others by narikkadan
• 63,720 points
423 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP