将 Excel 转换为 Pdf、图像及其他格式
将 Excel 工作簿转换为 PDF
PDF文件被广泛用于组织、政府部门和个人之间交换文档。它是一种标准文档格式,软件开发人员经常被要求找到一种方法将Microsoft Excel文件转换为PDF文档。
Aspose.Cells for Python via .NET 支持将 Excel 文件转换为 PDF,并在转换中保持高视觉保真度。
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Instantiate the Workbook object | |
# Open an Excel file | |
workbook = Workbook("Book1.xlsx") | |
# Save the document in PDF format | |
workbook.save("output.pdf") |
将 Excel 工作簿转换为 JPG
Aspose.Cells for Python via .NET 支持将 Excel 文件转换为 JPG。 以下代码示例显示了如何将工作簿保存为JPG格式。
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Open a template excel file | |
book = Workbook("Book1.xlsx") | |
# Convert workbook to JPG image. | |
book.save("Image1.jpg") |
将Excel工作簿转换为图像
Aspose.Cells for Python via .NET支持将Excel文件转换为图像。 以下代码示例显示了如何将工作簿保存为图像。
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Open a template excel file | |
book = Workbook("Book1.xlsx") | |
# Convert workbook to BMP image. | |
book.save("Image1.bmp") | |
# Convert workbook to JPG image. | |
book.save("Image1.jpg") | |
# Convert workbook to Png image. | |
book.save("Image1.png") | |
# Convert workbook to EMF image. | |
book.save("Image1.emf") | |
# Convert workbook to GIF image. | |
book.save("Image1.gif") |
将Excel工作簿转换为XPS
XPS文档格式由结构化的XML标记组成,用于定义文档的布局和每个页面的视觉外观,同时还包括用于分发、归档、渲染、处理和打印文档的渲染规则。
XPS的标记语言是XAML的子集,允许在文档中包含矢量图形元素,使用XAML来标记Windows Presentation Foundation(WPF)的基元。所使用的元素是根据路径和其他几何原语来描述的。
实际上,XPS文件是一个使用开放打包约定的Unicode ZIP存档,包含构成文档的文件。这些文件包括每个页面的XML标记文件、文本、嵌入字体、光栅图像、2D矢量图形,以及数字版权管理信息。可以通过在支持ZIP文件的应用程序中打开XPS文件来查看其内容。
from aspose.cells import Workbook, XpsSaveOptions | |
# Open an Excel file | |
workbook = Workbook("Book1.xls") | |
options = XpsSaveOptions() | |
# Export the whole workbook to XPS | |
workbook.save("out.xps", options) |
转换Excel为Ods、Sxc和Fods(OpenOffice / LibreOffice Calc)
Aspose.Cells for Python via .NET支持将Excel文件转换为Ods、Sxc和Fods文件。下面的代码示例显示了如何将【模板】(book1.xlsx)转换为Ods、Sxc和Fods文件。
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Load your source workbook | |
workbook = Workbook("book1.xlsx") | |
# Save as ods file | |
workbook.save("Out.ods") | |
# Save as sxc file | |
workbook.save("Out.sxc") | |
# Save as fods file | |
workbook.save("Out.fods") |
将Excel工作簿转换为MHTML文件
MHTML结合了普通HTML以及外部资源(通常是链接的内容,如图像、动画、音频等)到一个文件中。它们通常用于以.mht文件扩展名的电子邮件。
Aspose.Cells for Python via .NET支持读取和写入MHTML文件。下面的代码示例显示了如何将工作簿保存为MHTML文件。
下面的代码示例显示了如何将工作簿保存为MHTML文件。
from aspose.cells import HtmlSaveOptions, SaveFormat, Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# The path to the documents directory. | |
dataDir = RunExamples.GetDataDir(".") | |
# Specify the file path | |
filePath = dataDir + "Book1.xlsx" | |
# Specify the HTML Saving Options | |
sv = HtmlSaveOptions(SaveFormat.M_HTML) | |
# Instantiate a workbook and open the template XLSX file | |
wb = Workbook(filePath) | |
# Save the MHT file | |
wb.save(filePath + ".out.mht", sv) |
将Excel工作簿转换为HTML
Aspose.Cells for Python via .NET API支持将电子表格导出为HTML格式。为此,Aspose.Cells for Python via .NET使用HtmlSaveOptions类,提供灵活性来控制输出HTML的几个方面。
下面的代码示例显示了如何将工作簿保存为HTML文件。
from aspose.cells import SaveFormat, Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# The path to the documents directory. | |
dataDir = RunExamples.GetDataDir(".") | |
# Specify the file path | |
filePath = dataDir + "sample.xlsx" | |
# Load your sample excel file in a workbook object | |
wb = Workbook(filePath) | |
# Save it in HTML format | |
wb.save(dataDir + "ConvertingToHTMLFiles_out.html", SaveFormat.HTML) |
为HTML设置图像首选项
Aspose.Cells for Python via .NET已为HtmlSaveOptions 类公开了image_options,允许开发人员在将电子表格保存为HTML格式时指定图像首选项。
以下是可以应用的一些图像设置的详细信息。
- ImageType:指定图像类型。请注意,所有形状,包括图表,在输出HTML中呈现为图像。
- smoothing_mode:指定线条,曲线和填充区域边缘的抗锯齿。
- text_rendering_hint:指定文本呈现的质量。
- quality:在指定Jpeg时,指定图像质量为0到100之间的值。
- vertical_resolution:获取或设置图像的垂直分辨率(每英寸点数)。
- horizontal_resolution:获取或设置图像的水平分辨率(每英寸点数)。
- tiff_compression:在指定Tiff时,获取或设置图像的压缩类型。
- transparent:指示当ImageFormat指定为Png时,图像的背景是否应该是透明的。
下面的代码示例演示了如何使用HtmlSaveOptions.image_options 指定不同的首选项。
from aspose.cells import HtmlSaveOptions, SaveFormat, Workbook | |
from aspose.cells.drawing import ImageType | |
from aspose.pydrawing.drawing2d import SmoothingMode | |
from aspose.pydrawing.text import TextRenderingHint | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# The path to the documents directory. | |
dataDir = RunExamples.GetDataDir(".") | |
# Specify the file path | |
filePath = dataDir + "Book1.xlsx" | |
# Load a spreadsheet to be converted | |
book = Workbook(filePath) | |
# Create an instance of HtmlSaveOptions | |
saveOptions = HtmlSaveOptions(SaveFormat.HTML) | |
# Set the ImageFormat to PNG | |
saveOptions.image_options.image_type = ImageType.PNG | |
# Set SmoothingMode to AntiAlias | |
saveOptions.image_options.smoothing_mode = SmoothingMode.ANTI_ALIAS | |
# Set TextRenderingHint to AntiAlias | |
saveOptions.image_options.text_rendering_hint = TextRenderingHint.ANTI_ALIAS | |
# Save spreadsheet to HTML while passing object of HtmlSaveOptions | |
book.save(dataDir + "output.html", saveOptions) |
将Excel工作簿转换为Markdown
Aspose.Cells for Python via .NET API支持将电子表格导出为Markdown格式。要将活动工作表导出为Markdown,请将SaveFormat.Markdown作为Workbook.Save方法的第二个参数传递。您还可以使用MarkdownSaveOptions类来指定导出工作表到Markdown的其他设置。
以下代码示例演示了如何通过使用SaveFormat.MARKDOWN枚举成员将活动工作表导出为Markdown。请参考由该代码生成的输出Markdown文件。
from aspose.cells import SaveFormat, Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Open the template file | |
workbook = Workbook(sourceDir + "Book1.xlsx") | |
# Save as Markdown | |
workbook.save(outputDir + "Book1.md", SaveFormat.MARKDOWN) |
将Excel工作簿转换为JSON
Aspose.Cells for Python via .NET支持将工作簿转换为Json(JavaScript Object Notation)文件。
下面的代码示例演示了通过使用SaveFormat.JSON枚举成员将活动工作表导出为Json。请参考用于将源文件转换为输出Json文件的代码。
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Load your source workbook | |
workbook = Workbook("Book1.xlsx") | |
# convert the workbook to json file. | |
workbook.save(dir + "book1.json") |
将Excel转换为XML
Aspose.Cells for Python via .NET支持将工作簿转换为Excel 2003电子表格XML和普通XML数据。
from aspose.cells import Workbook, XmlSaveOptions | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Load your source workbook | |
workbook = Workbook("Book1.xlsx") | |
# Save as Excel 2003 Spreadsheet XML | |
workbook.save("Spreadsheet.xml") | |
# Save as plain XML data | |
xmlSaveOptions = XmlSaveOptions() | |
workbook.save("data.xml", xmlSaveOptions) |
将Excel工作簿转换为TIFF
Aspose.Cells for Python via .NET支持将工作簿转换为TIFF文件。
下面的代码片段显示了如何将Excel转换为TIFF:
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Open a template excel file | |
book = Workbook("Book1.xlsx") | |
# save file to tiff | |
book.save("out.tiff") |
将Excel工作簿转换为DOCX
Aspose.Cells for Python via .NET API支持将电子表格转换为DOCX格式。要将工作簿导出为DOCX,请将SaveFormat.DOCX作为Workbook.save方法的第二个参数。您还可以使用DocxSaveOptions类来指定导出工作表到DOCX的附加设置。
下面的代码示例演示了通过使用SaveFormat.DOCX枚举成员将活动工作表导出为DOCX。请参考代码生成的DOCX文件。
from aspose.cells import SaveFormat, Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Open the template file | |
workbook = Workbook(sourceDir + "Book1.xlsx") | |
# Save as Markdown | |
workbook.save(outputDir + "Book1.docx", SaveFormat.DOCX) |
将Excel工作簿转换为PPTX
Aspose.Cells for Python via .NET API提供了将电子表格转换为PPTX格式的支持。要将工作簿导出为PPTX,请将SaveFormat.PPTX作为Workbook.save方法的第二个参数传递。您还可以使用PptxSaveOptions类来指定导出工作表到PPTX的其他设置。
以下代码示例演示了使用SaveFormat.PPTX枚举成员将活动工作表导出到PPTX。请查看代码生成的输出PPTX文件作为参考。
from aspose.cells import SaveFormat, Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Open the template file | |
workbook = Workbook(sourceDir + "Book1.xlsx") | |
# Save as pptx | |
workbook.save(outputDir + "Book1.pptx", SaveFormat.PPTX) |