How to get a value from specific cell address in Excel through Laravel

Question

Is there any way to get the cell value with exact address in Excel?

Like I upload the excel file then return sheet(2).cell(10,1).value ?

Since I am writing a website to upload a excel and put those data into DB, the file's rows and columns are automatically generated and the formats are not exactly matching maatwebsite/Excel's upload sample.

I am using Laravel 5.7 and maatwebsite/Excel 3.1

Please see Daniel's reply , he gave the ans, thanks for your comment~ — W Kenny
– W Kenny, Commented Apr 20, 2019 at 14:27

Daniel · Accepted Answer · 2019-04-20 08:42:47Z

1

In maatwebsite/Excel 2.* you could fetch the value in the cell with

Excel::load('file.xlsx, function($excel) {
    $cell = $excel->getSheet(2)->getCellByColumnAndRow(10, 1);       
});

These methods have been removed in 3.*

However maatwebsite/Excel is just a wrapper around phpoffice/phpspreadsheet - so we can still call the function directly from that library:

$inputFileName = 'filename.xlsx';

$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($inputFileName);

$cellValue = $spreadsheet->getSheet(2)->getCellByColumnAndRow(10, 1)->getValue();

edited Apr 20, 2019 at 8:42

answered Apr 20, 2019 at 7:56

Daniel

11.3k12 gold badges56 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

W Kenny Over a year ago

it's not work for version 3.1... The load method is not exsist~

W Kenny Over a year ago

Thanks you so much! I just found out they use PhpOffice but not able to find out they use that way to read the sheet!

Paresh Solanki · Accepted Answer · 2019-04-20 08:00:55Z

1

I hope this would be help to you.

answered Apr 20, 2019 at 8:00

Paresh Solanki

594 bronze badges

1 Comment

W Kenny Over a year ago

thanks for your help but it's not work... i would like to get the value in exact address

Collectives™ on Stack Overflow

How to get a value from specific cell address in Excel through Laravel

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related