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,000 points
4,171 views

1 answer to this question.

0 votes
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
• 86,360 points

Related Questions In Others

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
• 86,360 points
922 views
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
• 86,360 points
2,718 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
• 86,360 points
1,117 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,690 points
1,805 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,580 points
2,121 views
0 votes
1 answer