Free Spire.XLS for Python

Free Python API to Process Excel Worksheets

  • Overview

Free Python API to Process Excel Worksheets

Over 1,000,000 Developers Are Already Using Our Libraries
To Create Their Amazing Applications.

Free Spire.XLS for Python is a professional Excel development component that can be used to create, read, write and convert Excel files on any Python platform. Free Spire.XLS for Python offers object model Excel API for speeding up Excel programming in Python platform - create new Excel documents from template, edit existing Excel documents and convert Excel files.


Free Spire.XLS for Python offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. It features fast and reliably compared with developing your own spreadsheet manipulation solution or using Microsoft Automation.


Friendly Reminder:
Free version is limited to 5 sheets per workbook and 200 rows per sheet. This limitation is enforced during reading or writing XLS files. There is not any limitation when loading and saving .xlsx file format. When converting Excel files to PDF files, you can only get the first 3 pages of PDF file. Upgrade to Commercial Edition of Spire.XLS for Python. We don't provide technical or any other support to the users of the free versions.

  • Convert

  • Export

  • Validate

  • Formula

  • Format

  • Chart

  • Pivot Table

  • Group

  • Merge

  • Highlight

Convert Excel to PDF

Whenever you need to share an important Excel report with a partner, it's best to convert the file to PDF to ensure it looks the same as it does on your device.

Export Data from Database to Excel

When data is exported from a database to Excel, it can be analyzed and visualized, as well as viewed and processed by users who are not database users.

Apply Data Validation

Data validation in Excel controls what kind of data can be entered into a certain cell, which ensures that all data entries are accurate and consistent.

Insert Formulas and Functions

Formula is an expression that calculates values in a cell or in a range of cells, while function is a predefined formula already available in Excel. Both formulas and functions are very useful when you need to calculate numbers or solve math problems in Excel.

Apply Conditional Formatting

Conditional formatting is a helpful feature that allows applying special formats to cells meeting specific criteria. It is often used to emphasize or differentiate data stored in worksheets.

Create a Chart

Chart is a fantastic tool to visually group and analyze data. It provides the reader with the structure of the data set and displays the data in a graphical representation, making it easier for most users to see the data.

Create a Pivot Table

Pivot table is a kind of interactive table that allow users to quickly categorize, calculate, summarize and analyze large amounts of data in a concise tabular format.

Group Rows or Columns

For worksheets with large amounts of data, grouping rows or columns that contain similar information can make the worksheet more compact and understandable.

Merge Excel Files

Merging Excel files with associated content can help us work with worksheet data more easily and also make it easier to share and read the contents of our workbooks.

Find and Highlight

You can find all cells containing a specific value and highlight them with the same background color to make the value outstanding and more easily to be found out.

PYTHON

Standalone Python API

100% independent Python Excel class library which doesn't require Microsoft Office to be installed on system.

VERSION

  • Excel 97-2003
  • Excel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016
  • Excel 2019
  • OpenOffice

OPERATION

Read More Operation

Powerful Toolset, Multichannel Support

  • Import and Export Data

  • Manage Comments

  • Work with Pivot Table

  • Work with Excel Charts

  • Images and Shapes

  • Find Replace Highlight

  • Manage Hyperlinks

  • Header and Footer

  • Text and Image watermark

  • Conditional Formatting

  • Excel Formula

  • Set Auto-filters & Page Breaks

  • Merge Split Cells and files

  • Protect, Encrypt, Decrypt

CONVERSION

Read More Conversion

Convert File Documents with High Quality

  • TEXT

  • XPS

  • SVG

  • PDF

  • XML

  • Image

XLsx,XLSM,XLSB,ODS

  • CSV

  • HTML

  • PNG

  • BMP

  • JPEG

  • EMF

  • TIFF

  1. Chart

Excel

MAIN FUNCTION

100% Standalone, Python API,
No Microsoft Office Automation

Free Spire.XLS for Python is a 100% standalone Excel Python API that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. In addition, Free Spire.XLS for Python is a better alternative to Office Automation in terms of security, stability, scalability, speed, price and features.

Powerful & High-Quality Excel File Conversion

Free Spire.XLS for Python supports converting files from Excel to PDF, Excel to HTML, HTML to Excel, Excel to CSV, Excel to Text, Excel to Image, Excel to XML, Excel to SVG, Excel to UOS, Excel to OFD, Excel to PostScript and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back.

Create Excel Report from Comprehensive Workbook Designer

Generate Excel workbook from scratch, or load a workbook from either folder or file stream. Developers can also save it to file, file stream or web response. Free Spire.XLS for Python offers a wide range of security features including Excel encryption/decryption, digital signature, tracking changes, cell hide/unhide, worksheet lock/unlock.

Freely Operate Worksheet

Free Spire.XLS for Python enables developers to create, add, delete, rename, edit and move worksheet in either Python. Developers can also copy, transpose, and consolidate across worksheets with full contents. This professional Excel Python class library also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers etc.

Easily Manipulate cells & Excel Calculation Engine at run time

Developers can easily manipulate Excel cells and Evaluate formula value in Python at runtime. Superfast, scalable excel calculation engine is compatible with the 97-2003/2007/2010/2013/2016/2019 Excel. Cell Styles are supported by this Excel Python API, such as cell merging/unmerging, text wrapping/unwrapping, text alignment, rotation, interior, borders, lock/unlock etc. Font formats, like setting font type, size, color, bold, italic, strikeout and underlining etc. is also fully supported. Conditional formatting, text search and replace, filter and data validation can be applied to cells as easily as you expect.

Chart, Data and Other Elements

Free Spire.XLS for Python provides a wide range of Chart: Pie Chart, Bar Chart, Column Chart, Line Chart, Radar Chart etc. This Excel Python API also supports data transportation between database and Excel in Python. Hyperlinks and templates are also supported by Free Spire.XLS for Python.

GET STARTED

Free Trials for All Advanced Solutions

Products
Products
Purchase
Partnership
Support
Corporation
Copyright © 2024 E-ICEBLUE. All Rights Reserved.