Open Source Perl API to Work with Excel Binary Files

Getting Started with Spreadsheet-WriteExcel

The recommend way to install Spreadsheet-WriteExcel is using CPAN. Please use the following command for a smooth installation.

$ cpan Spreadsheet::WriteExcel 

Create a New Excel Workbook via Perl API

The open source Spreadsheet-WriteExcel library provides a user-friendly interface, making it accessible to both beginners and seasoned programmers. The library enables software developers to generate Excel files compatible with various Excel versions, ensuring compatibility across different platforms. The library allows users to add worksheets, format cells, insert charts, and include various elements like images, hyperlinks, formulas and so on. The library doesn't rely on any Microsoft Excel components, making it platform-independent and highly efficient for handling large datasets. The following example shows how to create a new Excel workbook using Perl code.

use Spreadsheet::WriteExcel;

# Create a new Excel workbook
my $workbook = Spreadsheet::WriteExcel->new('example.xlsx');

# Add a worksheet
my $worksheet = $workbook->add_worksheet();

# Write data to cells
$worksheet->write('A1', 'Hello');
$worksheet->write('A2', 'Spreadsheet::WriteExcel');
$worksheet->write('B1', 'Welcome');
$worksheet->write('B2', 'to the world of Perl');

# Save the workbook
$workbook->close();

Apply Formatting Options via Perl API

The Spreadsheet-WriteExcel library makes it easy for software developers to open an existing spreadsheets and allows to format the data to enhance the visual appeal of the generated spreadsheet. To add data to a worksheet, you'll need to create a worksheet object and then write data to specific cells. The library provides several methods to format cells, such as setting font styles, cell alignment, background colors, customize cell borders, and may more. The following example demonstrates how software programmers can apply formatting to a worksheet cells inside Perl API.

my $worksheet = $workbook->add_worksheet('Sheet1');
$worksheet->write('A1', 'Hello');
$worksheet->write('A2', 'World');

# Formatting the cells
my $format = $workbook->add_format();
$format->set_bold();
$format->set_color('red');
$worksheet->write('A1', 'Hello', $format);

Add & Manage Charts in a Worksheet via Perl

Visualizing data is crucial for a better understanding of trends and patterns. The open source Spreadsheet-WriteExcel library supports the addition of charts to Excel worksheets. The library supports the creation of bar charts, line charts, pie charts, and more. The following example shows how software developers can add chart inside an Excel workbook using Perl commands.

my $chart = $workbook->add_chart( type => 'column', embedded => 1 );
$chart->add_series( values => '=Sheet1!$A$1:$A$5' );
$worksheet->insert_chart('C1', $chart);