def __init__(self):
dataDir = Settings.dataDir + 'WorkingWithFiles/ConvertingToXPS/'
saveFormat = SaveFormat
workbook = Workbook(dataDir + "Book1.xls")
#Get the first worksheet.
sheet = workbook.getWorksheets().get(0)
#Apply different Image and Print options
options = ImageOrPrintOptions()
#Set the Format
options.setSaveFormat(saveFormat.XPS)
# Render the sheet with respect to specified printing options
sr = SheetRender(sheet, options)
sr.toImage(0, dataDir + "out_printingxps.xps")
#Save the complete Workbook in XPS format
workbook.save(dataDir + "out_whole_printingxps", saveFormat.XPS)
# Print message
print "Excel to XPS conversion performed successfully."
def __init__(self):
dataDir = Settings.dataDir + 'WorkingWithFiles/ConvertingToXPS/'
saveFormat = SaveFormat
workbook = Workbook(dataDir + "Book1.xls")
#Get the first worksheet.
sheet = workbook.getWorksheets().get(0)
#Apply different Image and Print options
options = ImageOrPrintOptions()
#Set the Format
options.setSaveFormat(saveFormat.XPS)
# Render the sheet with respect to specified printing options
sr = SheetRender(sheet, options)
sr.toImage(0, dataDir + "out_printingxps.xps")
#Save the complete Workbook in XPS format
workbook.save(dataDir + "out_whole_printingxps", saveFormat.XPS)
# Print message
print "Excel to XPS conversion performed successfully."
def __init__(self):
dataDir = Settings.dataDir + 'WorkingWithFiles/ConvertingWorksheetToSVG/'
saveFormat = SaveFormat
workbook = Workbook(dataDir + "Book1.xls")
#Convert each worksheet into svg format in a single page.
imgOptions = ImageOrPrintOptions()
imgOptions.setSaveFormat(saveFormat.SVG)
imgOptions.setOnePagePerSheet(True)
#Convert each worksheet into svg format
sheetCount = workbook.getWorksheets().getCount()
#for(i=0; i<sheetCount; i++)
for i in range(sheetCount):
sheet = workbook.getWorksheets().get(i)
sr = SheetRender(sheet, imgOptions)
pageCount = sr.getPageCount()
#for (k = 0 k < pageCount k++)
for k in range(pageCount):
#Output the worksheet into Svg image format
sr.toImage(k, dataDir + sheet.getName() + ".out.svg")
# Print message
print "Excel to SVG conversion completed successfully."
def __init__(self):
dataDir = Settings.dataDir + 'WorkingWithFiles/ConvertingWorksheetToSVG/'
saveFormat = SaveFormat
workbook = Workbook(dataDir + "Book1.xls")
#Convert each worksheet into svg format in a single page.
imgOptions = ImageOrPrintOptions()
imgOptions.setSaveFormat(saveFormat.SVG)
imgOptions.setOnePagePerSheet(True)
#Convert each worksheet into svg format
sheetCount = workbook.getWorksheets().getCount()
#for(i=0; i<sheetCount; i++)
for i in range(sheetCount):
sheet = workbook.getWorksheets().get(i)
sr = SheetRender(sheet, imgOptions)
pageCount = sr.getPageCount()
#for (k = 0 k < pageCount k++)
for k in range(pageCount):
#Output the worksheet into Svg image format
sr.toImage(k, dataDir + sheet.getName() + ".out.svg")
# Print message
print "Excel to SVG conversion completed successfully."
