직접 실습 하기 : 03.셀 데이터 삭제

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;
?>