Reading Excel Files with PHP

Comments (0)

Views (519)

Recently I had to take datas from an excel file, when I was searching there was lot of complex codes, my intention was reading the datas row by row. Then I encountered with a repo. Our brother Sergey Shuckin wrote a class for this operations. Easy, useful and handles the situtation.

Firstly take files from here : https://github.com/shuchkin/simplexlsx (Note: Don't forget the give a star. )

Usage is very simple;

<?php

if ( $xlsx = SimpleXLSX::parse('test.xlsx') ) {
    print_r( $xlsx->rows() );
} else {
    echo SimpleXLSX::parse_error();
}

It will give you rows in excel as a array. You can choose and use.

When you are stuck while you are coding or when you need to relax yourself comment section is waiting for you. Ask what you don't know, answer what you know !