spire-xls

A Python Library for Processing Excel Spreadsheets

Product Page | Documentation | Examples | Forum | Temporary License | Customized Demo

Spire.XLS for Python is a powerful 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.

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

• Add or delete 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", ImageFormat.get_Png())
workbook.Dispose()

Product Page | Documentation | Examples | Forum | Temporary License | Customized Demo