Breaking News: Grepper is joining You.com. Read the official announcement!

Get array from Excel spread sheet

Exuberant Elephant answered on September 5, 2022 Popularity 1/10 Helpfulness 1/10

answer Get array from Excel spread sheet

Get array from Excel spread sheet

Comment

$dataArray = $spreadsheet->getActiveSheet()
    ->rangeToArray(
        'C3:E5',     // The worksheet range that we want to retrieve
        NULL,        // Value that should be returned for empty cells
        TRUE,        // Should formulas be calculated (the equivalent of getCalculatedValue() for each cell)
        TRUE,        // Should values be formatted (the equivalent of getFormattedValue() for each cell)
        TRUE         // Should the array be indexed by cell row and cell column
    );

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: phpspreadsheet.readthedocs.io

Tags: excel get spread whatever

Link to this answer
Share Copy Link