鍍金池/ 問答/PHP  Linux/ Thinkphp5如何將導(dǎo)出的excel表格存儲到服務(wù)器中項目目錄的指定目錄中？

Thinkphp5如何將導(dǎo)出的excel表格存儲到服務(wù)器中項目目錄的指定目錄中？

/**

  • excel表格導(dǎo)出
  • @param string $fileName 文件名稱
  • @param array $headArr 表頭名稱
  • @param array $data 要導(dǎo)出的數(shù)據(jù)
  • @author static7 */

function excelExport($fileName = '', $headArr = [], $data = []) {

$fileName .= "_" . date("Y_m_d", Request::instance()->time()) . ".xls";

$objPHPExcel = new \PHPExcel();

$objPHPExcel->getProperties();

$key = ord("A"); // 設(shè)置表頭

foreach ($headArr as $v) {

    $colum = chr($key);

    $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v);

    $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v);

    $key += 1;

}

$column = 2;

$objActSheet = $objPHPExcel->getActiveSheet();

foreach ($data as $key => $rows) { // 行寫入

    $span = ord("A");

    foreach ($rows as $keyName => $value) { // 列寫入

        $objActSheet->setCellValue(chr($span) . $column, $value);

        $span++;

    }

    $column++;

}

$fileName = iconv("utf-8", "gb2312", $fileName); // 重命名表

$objPHPExcel->setActiveSheetIndex(0); // 設(shè)置活動單指數(shù)到第一個表,所以Excel打開這是第一個表

header('Content-Type: application/vnd.ms-excel');

header("Content-Disposition: attachment;filename='$fileName'");

header('Cache-Control: max-age=0');

$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('php://output'); // 文件通過瀏覽器下載

exit();

}
//這是通知瀏覽器下載這個excel文件，那么如何不需要通知瀏覽器下載到本地，直接生成excel文件到指定目錄呢

回答
編輯回答
別瞎鬧

已經(jīng)解決，直接在save 處寫服務(wù)器絕對路徑既可
public function get_test()

{
$file = '456.xls';
  $file_path = ROOT_PATH.'uploads/Tmp/'.$file;
$PHPExcel = new \PHPExcel();
$PHPSheet = $PHPExcel->getActiveSheet();
$PHPSheet->setTitle("demo"); //給當(dāng)前活動sheet設(shè)置名稱
$PHPSheet->setCellValue("A1","姓名")->setCellValue("B1","分?jǐn)?shù)");//表格數(shù)據(jù)
$PHPSheet->setCellValue("A2","張三")->setCellValue("B2","2121");//表格數(shù)據(jù)
$objWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel2007');
$objWriter->save($file_path); //文件直接下載我指定的服務(wù)器目錄中
}
2017年4月7日 04:27