최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday

티스토리 뷰


del.xls


delete.php



<?php
include_once './phpexcel/Classes/PHPExcel.php';
include_once './phpexcel/Classes/PHPExcel/IOFactory.php';

$fileType = 'Excel5';
$fileName = './del.xls';

$objReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objReader->load($fileName);

// delete
$objPHPExcel->getActiveSheet()
			//->removeColumnByIndex(0, 1);
			->removeColumn('D', 4);

//Write the file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);
$objWriter->save($fileName);
exit;
?>
댓글