Zeilenhöhe und Spaltenbreite in Jython anpassen
Contents
[
Hide
]
Aspose.Cells - Zeilenhöhe und Spaltenbreite anpassen
Zum Anfügen von Dokumenten mit Aspose.Cells Java für Jython. Hier sehen Sie Beispielscode.
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 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()
Laufenden Code herunterladen
Laden Sie Dokumente anfügen (Aspose.Cells) von einer der unten genannten Plattformen für soziale Codierung herunter: