Kopieren und Verschieben von Arbeitsblättern in Jython
Contents
[
Hide
]
Aspose.Cells - Kopieren und Verschieben von Arbeitsblättern
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
from com.aspose.cells import SaveFormat
class CopyingAndMovingWorksheets:
def __init__(self):
# Copy Worksheets within a Workbook
self.copy_worksheet()
# Move Worksheets within Workbook
self.move_worksheet()
def copy_worksheet(dataDir):
dataDir = Settings.dataDir + 'WorkingWithWorksheets/CopyingAndMovingWorksheets/'
# Instantiating a Workbook object by excel file path
workbook = Workbook(dataDir + "Book1.xls")
# Create a Worksheets object with reference to the sheets of the Workbook.
sheets = workbook.getWorksheets()
# Copy data to a new sheet from an existing sheet within the Workbook.
sheets.addCopy("Sheet1")
# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(dataDir + "Copy Worksheet.xls")
print "Copy worksheet, please check the output file."
def move_worksheet(dataDir):
dataDir = Settings.dataDir + 'WorkingWithWorksheets/CopyingAndMovingWorksheets/'
# Instantiating a Workbook object by excel file path
workbook = Workbook(dataDir + "Book1.xls")
# Get the first worksheet in the book.
sheet = workbook.getWorksheets().get(0)
# Move the first sheet to the third position in the workbook.
sheet.moveTo(2)
# Saving the modified Excel file in default (that is Excel 2003) format
workbook.save(dataDir + "Move Worksheet.xls")
print "Move worksheet, please check the output file."
if __name__ == '__main__':
CopyingAndMovingWorksheets()
Laufenden Code herunterladen
Laden Sie Append-Dokumente (Aspose.Cells) von einer der unten genannten Social-Coding-Websites herunter: