function _phpexcel_set_columns in PHPExcel 7

Same name and namespace in other branches

1. 8.3 phpexcel.inc \_phpexcel_set_columns()
2. 6.2 phpexcel.api.inc \_phpexcel_set_columns()
3. 6 phpexcel.api.inc \_phpexcel_set_columns()
4. 7.3 phpexcel.inc \_phpexcel_set_columns()
5. 7.2 phpexcel.inc \_phpexcel_set_columns()

Adds the data to the Excel file.

See also

phpexcel_export()

1 call to _phpexcel_set_columns()

phpexcel_export in ./phpexcel.api.inc

Simple API function which will generate an XLS file and save it in $path.

File

./phpexcel.api.inc, line 201

Defines the phpexcel api functions that other modules can use.

Code

function _phpexcel_set_columns(&$xls, &$data, $cols, $options) {
  $data = array_values($data);
  if (!is_array($data[0][0])) {
    $data = array(
      $data,
    );
  }
  phpexcel_invoke('export', 'data', $data, $xls, $options);
  foreach ($data as $sheet_id => $sheet_data) {
    $sheet = $xls
      ->setActiveSheetIndex($sheet_id);
    for ($i = 0, $len = count($sheet_data); $i < $len; $i++) {
      for ($j = 0; $j < $cols; $j++) {
        $value = isset($sheet_data[$i][$j]) ? $sheet_data[$i][$j] : '';

        // We must offset the row count (by 2, because PHPExcel starts the count at 1), because the first row is used by the headers
        phpexcel_invoke('export', 'pre cell', $value, $sheet, $options, $j, $i + 2);
        $sheet
          ->setCellValueByColumnAndRow($j, $i + 2, $value);
        phpexcel_invoke('export', 'post cell', $value, $sheet, $options, $j, $i + 2);
      }
    }
  }
}