A Free Python Excel API to Process Excel Spreadsheets

Product Page | Documentation | Examples | Forum | Customized Demo

Free Spire.XLS for Python is a free Python Excel API that can be used to create, read, write, and convert Excel spreadsheets in any type of Python applications without installing Microsoft Office.

Free Spire.XLS for Python provides a comprehensive set of interfaces that allow for the manipulation of Excel files with ease. By utilizing it, developers can automate spreadsheet-related tasks, streamline data analysis, and build applications that interact seamlessly with Excel documents.

Excel Spreadsheets Processing & Security Features

• Create, read and write Excel files

• Merge Excel files, or split Excel files

• Insert rows & columns in Excel

• Delete rows & columns from Excel

• Set row height & column width in Excel

• Add worksheets, copy worksheets, or rename worksheets

• Move or delete worksheets

• Hide or show worksheets

• Freeze or unfreeze Excel panes

• Apply conditional formatting in Excel

• Remove conditional formatting from Excel

• Add comments in Excel

• Edit or remove comments in Excel

• Hide or show Excel comments

• Add or remove auto filter in Excel

• Encrypt or decrypt Excel files

• Detect and remove digital signatures in Excel

• Tracking changes in Excel

• Lock Excel cells

Compatible with: old Excel 97-2003 format (.xls), Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), and Open Office(.ods) format.

High Quality Excel File Conversion

• Convert Excel (XLS or XLSX) to PDF
• Conversion between Excel and HTML
• Convert Excel to Images (PNG, JPG or BMP)
• Conversion between Excel and CSV
• Convert Excel to XML
• Convert Excel to TXT
• Convert CSV to PDF
• Convert Excel to SVG
• Convert Excel to XPS
• Convert XLS to XLSM
• Conversion between XLS and XLSX
• Convert Excel to ODS (OpenDocument Spreadsheet)
• Convert Excel charts to Images

Advanced Cell Manipulation & Calculation Engine

• Merge or unmerge Excel cells
• Wrap or unwrap text in Excel Cells
• Align text in Excel cells
• Add or remove cell borders in Excel
• Set fonts in Excel cells (including font size, color, bold, italic, underlining, etc.)
• Set fill color, gradient or pattern for Excel cells
• Find & replace data in Excel cells
• Add or read Excel formulas
• Calculate Excel formulas
• Remove Excel formulas
• Create, edit or delete named ranges in Excel

Excel Charts, Images, Shapes and Other Elements

• Create pie charts in Excel
• Create column charts in Excel
• Create bar charts in Excel
• Create line charts in Excel
• Create radar charts in Excel
• Insert or delete pictures in Excel
• Compress, resize, or move images in Excel
• Replace or extract images in Excel
• Insert or remove shapes in Excel
• Create or operate pivot tables in Excel
• Add, update, or delete textboxes in Excel
• Insert hyperlinks in Excel
• Update or remove hyperlinks in Excel
• Add header & footer in Excel
• Add watermarks in Excel

Examples

Create an Excel File in Python

from spire.xls.common import *
from spire.xls import *

outputFile = "CreateAnExcelWithFiveSheet.xlsx"

# Create an object of Workbook class 
workbook = Workbook()

# Add five sheets to this file 
workbook.CreateEmptySheets(5)

# Loop through the added worksheets
for i in range(0, 5):
    sheet = workbook.Worksheets[i]
    sheet.Name = "Sheet" + str(i)

    # Add text to cells
    for row in range(1, 151):
        for col in range(1, 51):
            sheet.Range[row,col].Text = "row" + str(row) + " col" + str(col)

# Save the Excel file            
workbook.SaveToFile(outputFile, ExcelVersion.Version2016)
workbook.Dispose()

Convert Excel to PDF in Python

from spire.xls import *
from spire.xls.common import *

inputFile = "Input.xlsx"
outputFile = "ExcelToPDF.pdf"

# Create a Workbook object
workbook = Workbook()

# Load an Excel document
workbook.LoadFromFile(inputFile)

# Set worksheet to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = True

# Convert the Excel file to PDF
workbook.SaveToFile(outputFile, FileFormat.PDF)
workbook.Dispose()

Convert Excel to Image in Python

from spire.xls import *
from spire.xls.common import *

# Create a Workbook object
workbook = Workbook()

# Load an Excel file
workbook.LoadFromFile("Sample.xlsx")

# Get the first worksheet
sheet = workbook.Worksheets[0]

# Save the worksheet to an image
image = sheet.ToImage(sheet.FirstRow, sheet.FirstColumn, sheet.LastRow, sheet.LastColumn)

# Save the image to a PNG file
image.Save("SheetToImage.png")
workbook.Dispose()

Product Page | Documentation | Examples | Forum | Customized Demo