Worksheet list

• The file is not supported for the windows system.

• Extended version is greater than or equal to 1.2.7;

• PECL will prompt you to open the read function when installing, please type yes;

Function Prototype

sheetList(): array

Example

$excel = new \Vtiful\Kernel\Excel(['path' => './tests']);

// Build the sample file
$filePath = $excel
    // First worksheet
    ->fileName('tutorial.xlsx', 'test1')
    ->header(['sheet'])
    ->data([['test1']])

    // Second worksheet
    ->addSheet('test2')
    ->header(['sheet'])
    ->data([['test2']])

    ->output();

// Open the sample file
$sheetList = $excel->openFile('tutorial.xlsx')
    ->sheetList();

Foreach ($sheetList as $sheetName) {
    echo 'Sheet Name:' . $sheetName . PHP_EOL;

    // Get the worksheet data by the worksheet name
    $sheetData = $excel
        ->openSheet($sheetName)
        ->getSheetData();

    var_dump($sheetData);
}

Sample output

Sheet Name: test1
Array(2) {
  [0]=>
  Array(1) {
    [0]=>
    String(5) "sheet"
  }
  [1]=>
  Array(1) {
    [0]=>
    String(5) "test1"
  }
}
Sheet Name: test2
Array(2) {
  [0]=>
  Array(1) {
    [0]=>
    String(5) "sheet"
  }
  [1]=>
  Array(1) {
    [0]=>
    String(5) "test2"
  }
}