The excel zoom factor could help us to display the data on Excel worksheet clearly or completely. This article will demonstrate how to set the zoom factor on Excel work sheet in Java application by Spire.XLS for Java.
import com.spire.xls.*;
public class ZoomFactor{
public static void main(String[] args) {
//Create a workbook and load a file
Workbook workbook = new Workbook();
workbook.loadFromFile("Sample.xlsx");
//Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);
//Set the zoom factor of the sheet to 150
sheet.setZoom(150);
//Save the Excel file
workbook.saveToFile("Zoomfactor.xlsx", ExcelVersion.Version2010);
}
}
Effective screenshot after setting the zoom factor of the sheet to 150.
