CODEWITHSUNDEEP
php
Alok Jha
Alok Jha

Reputation: 572

Xlsx file, Read all spreadsheet in php

I am using simplexlsx to read xlsx sheet,

I have multiple tabs in my xlsx file, When I am trying to read data, its shows data only for first tab,

for better understanding i have attach print screen.

enter image description here

Upvotes: 0

Views: 957

Answers (2)

Ajay Prakash Singh
Ajay Prakash Singh

Reputation: 46

Try This,

$this->load->library('simplexlsx');

$xlsx = new SimpleXLSX( $file_path );

$data['csv_data'] = $xlsx->rows();

Upvotes: 1

Satyapal Sharma
Satyapal Sharma

Reputation: 291

It is because when you select something from an excel file it performs that action with the active sheet which is by default is the first one.

You need to change that to the required sheet Use the following code to do that 

$objPHPExcel->setActiveSheetIndex($count); // Use no of the sheet you want to select -1 as count

Upvotes: 1

Related Questions