Category
Convert HTML to PDF in Python and Customize the Conversion
2024-01-11 08:04:54
Generating documents from web pages has become a common demand. Whether it's for archiving web content, sharing web pages offline, or creating printable reports, people often find themselves in need of a reliable method to convert HTML files into the stable and universally accessible PDF format. By bringing in the powerful Python language, we can seamlessly convert HTML to PDF with Python programs for easy PDF generating from web contents.
Python: Hide or Unhide Excel Worksheets
2024-01-11 02:02:02
The Excel workbook is a powerful spreadsheet that enables the creation, manipulation, and analysis of data in a variety of ways. One of the useful features that workbooks offer is the ability to hide or unhide worksheets in a workbook. Hiding worksheets can help protect sensitive or confidential information, reduce clutter, or organize data more efficiently. And when users need to re-display the hidden worksheets, they can also unhide them with simple operations. This article is going to explain how to hide or unhide worksheets in Excel workbooks through Python programs using Sprie.XLS for Python.
Python: Create Column Charts in Excel
2024-01-11 01:36:27
A clustered column chart and a stacked column chart are two variants of column chart. The clustered column chart enables straightforward comparison of values across different categories, while the stacked column chart displays both the total for each category and the proportion of its individual components. In this article, you will learn how to create clustered or stacked column charts in Excel in Python using Spire.XLS for Python.
Python: Convert Excel to PDF
2024-01-10 09:12:01
Converting Excel files to PDF format can be a useful way to share and distribute spreadsheets, especially if you want to ensure that the formatting and layout of the file remains consistent across different devices and software. In addition, PDFs often appear more polished and professional than Excel files, making them a popular choice for official reports, presentations, and other business documents. In this article, you will learn how to convert Excel to PDF in Python using Spire.XLS for Python.
Python: Convert Excel to Open XML or Open XML to Excel
2024-01-10 08:37:44
In the context of Excel, Open XML refers to the underlying file format used by Excel to store spreadsheet data, formatting, formulas, and other related information. It provides a powerful and flexible basis for working with Excel files programmatically.
Python: Add Worksheets to Excel
2024-01-10 08:19:48
A workbook can consist of one or more worksheets, and each worksheet is independent. When dealing with an existing Excel file or creating a new Excel file from scratch, we can add worksheets as needed to better manage and analyze data. In this article, we will show you how to add worksheets to Excel programmatically by using Spire.XLS for Python.
How to Create PDF Using Python: A Comprehensive Guide
2024-01-08 07:26:06
PDF (Portable Document Format) is a popular file format widely used for generating legal documents, contracts, reports, invoices, manuals, eBooks, and more. It provides a versatile and reliable format for sharing, storing and presenting electronic documents in a consistent manner, independent of any software, hardware or operating systems.
Python Merge PDF Files with Simple Code
2024-01-05 08:56:05
Merging PDF is the integration of multiple PDF files into a single PDF file. It allows users to combine the contents of multiple related PDF files into a single PDF file to better categorize, manage, and share files. For example, before sharing a document, similar documents can be merged into one file to simplify the sharing process. This post will show you how to use Python to merge PDF files with simple code.