Adjusting Row Height and Column Width in Jython

Aspose.Cells - Adjusting Row Height and Column Width

To adjust rows and columns using Aspose.Cells Java for Jython. Here you can see example code.

Jython Code

 from aspose-cells import Settings

from com.aspose.cells import Workbook

class RowsAndColumns:

    def __init__(self):

        dataDir = Settings.dataDir + 'WorkingWithRowsAndColumns/RowsAndColumns'

        # Setting the Row Height
        self.set_row_height()
        # Setting the Width of a Column
        self.set_column_width()    

    def set_row_height(dataDir):

        dataDir = Settings.dataDir + 'WorkingWithRowsAndColumns/RowsAndColumns/'    
        # Instantiating a Workbook object using an Excel file path
        workbook = Workbook(dataDir + 'Book1.xls')
        # Accessing the first worksheet in the Excel file
        worksheet = workbook.getWorksheets().get(0)
        cells = worksheet.getCells()
        # Setting the height of the second row to 13
        cells.setRowHeight(1, 13)
        # Saving the modified Excel file in the default (i.e., Excel 2003) format
        workbook.save(dataDir + "Set Row Height.xls")
        print "Set Row Height Successfully." 

    def set_column_width(dataDir):

        dataDir = Settings.dataDir + 'WorkingWithRowsAndColumns/RowsAndColumns/'    
        # Instantiating a Workbook object using an Excel file path
        workbook = Workbook(dataDir + 'Book1.xls')
        # Accessing the first worksheet in the Excel file
        worksheet = workbook.getWorksheets().get(0)
        cells = worksheet.getCells()
        # Setting the width of the second column to 17.5
        cells.setColumnWidth(1, 17.5)
        # Saving the modified Excel file in the default (i.e., Excel 2003) format
        workbook.save(dataDir + "Set Column Width.xls")
        print "Set Column Width Successfully." 

if __name__ == '__main__':        
    RowsAndColumns()

Download Running Code

Download Append Documents (Aspose.Cells) from any of the social coding sites listed below:

• GitHub