Magento: by php excel reader, read an excel file

Magento: by php excel reader, read an excel file

September 3, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento: by php excel reader, read an excel file

Integrating PHP Excel Reader with Magento: Step-by-Step Guide

Hello! I’m delighted to help you integrate the PHP Excel Reader library into your Magento store version 1.7.2. Let’s dive right in.

Prerequisites

Before we begin, ensure you have:

  • Access to your server using an FTP client like FileZilla.
  • A local development environment set up for Magento.
  • The PHPExcel library downloaded and ready to upload.

Uploading the Library

  1. Download the latest version of PHPExcel from their official website.

  2. Extract the contents into a folder named PHPExcel in your Magento root directory (public_html/magento).

Creating a Helper Function

Let’s create a helper function to read Excel files.

In your Magento root, navigate to app/code/local. If the local folder doesn’t exist, create it. Inside local, create a new folder named YourCompany_ExcelReader.

Within this new folder structure:

app/code/local/YourCompany/ExcelReader

Create the following files and directories:

  • etc/config.xml
  • src/Helper/Data.php

Configuring Config.xml

In config.xml, add the following configuration to enable our module:

<?xml version="1.0"?>
<config>
    <modules>
        <YourCompany_ExcelReader>
            <active>true</active>
            <codePool>local</codePool>
        </YourCompany_ExcelReader>
    </modules>
</config>

Creating the Helper Function

Open Data.php and add the following code:

class YourCompany_ExcelReader_Helper_Data extends Mage_Core_Helper_Abstract
{
    public function readExcel($filePath)
    {
        require_once 'PHPExcel/IOFactory.php';
        $spreadsheet = IOFactory::load($filePath);
        return $this->processSpreadsheet($spreadsheet);
    }

    private function processSpreadsheet($spreadsheet)
    {
        // Implement your logic to read the Excel data here
        // You can use $spreadsheet->getActiveSheet()->toArray()
        // or iterate through rows and cells as needed

        return [];  // Placeholder, replace with actual processing code
    }
}

Reading an Excel File

You can now call this helper function from anywhere in your Magento store. For example:

$helper = Mage::helper('yourcompany_excelreader');
$data = $helper->readExcel('/path/to/your/excel/file.xlsx');

Conclusion

Integrating the PHP Excel Reader library with Magento allows you to read and process Excel files directly within your store. This is particularly useful for importing product data, processing orders, or handling other CSV-based files.

Remember to adjust the processSpreadsheet method according to your specific needs for reading and manipulating the Excel data.

If you found this guide helpful, please consider browsing our Magento development services at LaravelCompany. We offer a range of solutions tailored to businesses like yours.

Magento 1 Extensions Configuration CLI

Our network