def HtmlWorksheetMenu(workbook, current): links = [] for sheet in workbook._worksheets: if sheet.name == current: links.append(currentWorksheetMenuLink % (Uri.EscapeUriString( sheet.name), SecurityElement.Escape(sheet.name))) else: links.append(worksheetMenuLink % (Uri.EscapeUriString( sheet.name), SecurityElement.Escape(sheet.name))) return worksheetMenuTable % (len(links), ''.join(links))
def HtmlFromImageSheet(sheet, outputDirectory): image = sheet.Image imageName = Uri.EscapeUriString(sheet.name) + '.jpg' fullPath = Path.Combine(outputDirectory, sheet.name + '.jpg') image.Save(fullPath, ImageFormat.Jpeg) return imageWorksheet % (imageName, imageName, image.Width, image.Height)