Category
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.
Create Word Documents from Templates with Python
2024-01-05 07:29:41
Templates provide a ready-made structure and layout, saving you time and effort in creating documents from scratch. Instead of designing the document layout, formatting styles, and section organization, you can simply choose a template that meets your requirements and start adding your content. This is particularly useful when you need to create multiple documents with a consistent look and feel. In this blog, we will explore how to create Word documents from templates using Python.