Category
Python-Conversion Between Excel and CSV
2024-01-15 03:25:15
Excel is one of the standard file formats used by Microsoft Excel, which can store spreadsheets containing multiple worksheets, charts, formulas and data. CSV, on the other hand, is a simple text file format that is widely used for data exchange and storage. It has no complex formatting specifications and usually contains only plain text data. Sometimes conversion between these two formats allows for more flexible handling of data across different platforms and applications. This post covers how to convert Excel to CSV in Python with sample code. And you can also convert CSV back to Excel via Python if necessary.
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.
Read Excel Files in Python: Data, Formulas, Images & Charts
2023-12-22 09:39:55
Excel files (spreadsheets) are used by people worldwide for organizing, analyzing, and storing tabular data. Due to their popularity, developers frequently encounter situations where they need to extract data from Excel or create reports in Excel format. Being able to read Excel files with Python opens up a wide range of possibilities for data processing and automation.
Java: Create, Read, or Update Excel Documents
2023-12-06 03:15:56
The Excel spreadsheet is a popular file format that allows users to arrange, analyze, and display data in tables. The ability to programmatically interact with Excel files is valuable for automating and integrating its features into software. This is especially beneficial when dealing with extensive datasets, complex calculations, or dynamically generating/updating data. In this article, you will learn how to create, read, or update Excel document in Java using Spire.XLS for Java.