CODEWITHSUNDEEP
phpexcel
Vidya
Vidya

Reputation: 8207

how to delete rows in excel sheet using PHP

Is it possible to delete rows in excel sheet using PHP ?

Upvotes: 2

Views: 1860

Answers (2)

oliver31
oliver31

Reputation: 2523

Only works if your PHP is hosted under Windows.

This should be a good start if PHPExcel* doesn't work.

Open

$this->excel = new COM("Excel.sheet") or $this->error("error");
$this->workbook = $this->excel->application->Workbooks->Open($path) or $this->error("error");

Close

$this->excel->application->ActiveWorkbook->Close("False");
unset($this->workbook);
unset($this->excel);

*I've never used PHPExcel, but it doesn't look bad

Upvotes: 2

brendan
brendan

Reputation: 29986

If it's Excel 2007 you can take a look at http://www.phpexcel.net

Upvotes: 2

Related Questions