package excel.autofit;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
public class AsposeAutoFit
{
public static void main(String[] args) throws Exception
{
//Instantiating a Workbook object
Workbook workbook = new Workbook("data/workbook.xls");
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
worksheet.autoFitRow(1); //Auto-fitting the 2nd row of the worksheet
worksheet.autoFitColumn(0); //Auto-fitting the 1st column of the worksheet
//Saving the modified Excel file in default (that is Excel 2003) format
workbook.save("data/AutoFit_Aspose.xls");
//Print message
System.out.println("Row and Column auto fit successfully.");
}
}