def __init__(self): dataDir = Settings.dataDir + 'WorkingWithFiles/WorksheetToImage/' imageFormat = ImageFormat #Instantiate a workbook with path to an Excel file book = Workbook(dataDir + "Book1.xls") #Create an object for ImageOptions imgOptions = ImageOrPrintOptions() #Set the image type imgOptions.setImageFormat(imageFormat.getPng()) #Get the first worksheet. sheet = book.getWorksheets().get(0) #Create a SheetRender object for the target sheet sr = SheetRender(sheet, imgOptions) for i in range(sr.getPageCount()): #Generate an image for the worksheet sr.toImage(i, dataDir + "mysheetimg" + ".png") # Print message print "Images generated 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/WorksheetToImage/" imageFormat = ImageFormat # Instantiate a workbook with path to an Excel file book = Workbook(dataDir + "Book1.xls") # Create an object for ImageOptions imgOptions = ImageOrPrintOptions() # Set the image type imgOptions.setImageFormat(imageFormat.getPng()) # Get the first worksheet. sheet = book.getWorksheets().get(0) # Create a SheetRender object for the target sheet sr = SheetRender(sheet, imgOptions) for i in range(sr.getPageCount()): # Generate an image for the worksheet sr.toImage(i, dataDir + "mysheetimg" + ".png") # Print message print "Images generated successfully."