This article demonstrates how to delete blank rows and columns in an Excel document using Spire.XLS for Java.
Sample Document
import com.spire.xls.ExcelVersion; import com.spire.xls.Workbook; import com.spire.xls.Worksheet; public class DeleteBlankRowsAndColumns { public static void main(String[] args) { //Load the sample document Workbook wb = new Workbook(); wb.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.xlsx "); //Get the first worksheet Worksheet sheet = wb.getWorksheets().get(0); //Loop through the rows for (int i = sheet.getLastRow(); i >= 1; i--) { //Detect if a row is blank if (sheet.getRows()[i-1].isBlank()) { //Remove blank row sheet.deleteRow(i); } } //Loop through the columns for (int j = sheet.getLastColumn(); j >= 1; j--) { //Detect if a column is blank if (sheet.getColumns()[j-1].isBlank()) { //Remove blank column sheet.deleteColumn(j); } } //Save the document wb.saveToFile("DeleteBlankRowsAndColumns.xlsx", ExcelVersion.Version2016); } }
Output