Ajustar la Altura de la Fila y el Ancho de la Columna en Jython
Contents
[
Hide
]
Aspose.Cells - Ajustar altura de fila y ancho de columna
Para agregar documentos usando Aspose.Cells Java for Jython. Aquí puedes ver código de ejemplo.
Código Jython
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 by 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 default (that is 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 by 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 default (that is Excel 2003) format
workbook.save(dataDir + "Set Column Width.xls")
print "Set Column Width Successfully."
if __name__ == '__main__':
RowsAndColumns()
Descargar Código en Ejecución
Descargar Agregar documentos (Aspose.Cells) desde cualquiera de los sitios de codificación social mencionados a continuación: