Hey i am having confusion in scaling values for cells.
I have made the following zoom function
/****************************************
*
* Function Name : setScalingWorkbook()
* Description : This function is used to set the zoom factor of the workbook
* according to the PrintParams object attribute Scaling
*
*************************************************************************/
private static Workbook setScalingWorkbook(Workbook wb, String szoom)
{
if (!szoom.equals(""))
{
int zoom = Integer.parseInt(szoom);
// Accessing all the worksheets of the workbook
for (int i = 0 ; i < wb.getWorksheets().getCount() ; i++)
{
Worksheet worksheet = wb.getWorksheets().get(i);
// Change the zoom factor
worksheet.getPageSetup().setZoom(zoom);
}
}
return wb;
}
Is there any documentation of the setzoom() values of worksheet which can give an idea of the value to transform maintaining the original look and etc. Some documentation?
Hi Hafsa,
Please check the detailed article on setting the zoom factor for Worksheet instance. If you still have any question then please feel free to write back.
Please note, we have split your existing thread to create a new one on your behalf because it is appropriate to create a new thread for every distinct inquiry. This way we can efficiently keep track of your requests.