how to create another sheet while write data using fputcsv in php

Question

I am using fputcsv for write data. It is working fine. what i need is i need to create another sheet like any name and i need to write data on that. How to do that? Please guide. I am not familiar with this. This is my code.

$filename = date("Y-m-d").".csv";
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename=' . $filename);
header("Content-Transfer-Encoding: UTF-8");
$fp = fopen('php://output', 'a');
$yetToaproveFields = array('job_no'=>'Job Number',
                         'revisioncycle'=> 'Revision Cycle',
                         'version'=>'Version',
                         'is_approved'=>'Approved Status'
);

fputcsv($fp, $yetToaproveFields);

$notApproveArr = array();
$notApprovedValues = self::getNotApprovedJobs($_REQUEST);
foreach ($notApprovedValues as $key=>$value) {
    if ($value['is_approved'] == 1)
        $value['is_approved'] = 'No';
    fputcsv($fp, $value);
}
fclose($fp);

score 2 · Answer 1 · answered Jan 17 '17 at 09:59

2

CSV doesn't support multiple sheets, it's a simple text file. To use sheets, you should use an Excel extension, such as PHPExcel.

answered Jan 17 '17 at 09:59

roberto06

3,844
1
18
29

using by this library PHPEXcel can i generate .csv file – shanthi Jagadeesh Jan 17 '17 at 10:04
Yes you can, but, once again, CSV **does not support** multiple sheets. – roberto06 Jan 17 '17 at 10:05
C i just explain my task. Initially someone created one file with the extension of .csv. and they write data using fputcsv.What i need to do is I have to create another sheet with the same file. So if i use PHPExcel means should i change previously used fputcsv commands also? – shanthi Jagadeesh Jan 17 '17 at 10:09
Yep, you must use PHPExcel to generate your whole file (both sheets). – roberto06 Jan 17 '17 at 10:13
I have used PHPEXcel for creating sheets. The problem is row height and width is too small. How to set height and width? – shanthi Jagadeesh Jan 18 '17 at 05:24
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($headerCol, $headerRow, $headerValue); – shanthi Jagadeesh Jan 18 '17 at 05:24
using by above method I'm writing data. – shanthi Jagadeesh Jan 18 '17 at 05:24

score 0 · Answer 2 · answered Jan 17 '17 at 09:59

0

You can't.

CSV is a very simple data file format. It doesn't support spreadsheet features like styling or multiple worksheets. If you want multiple worksheets, then you need to use a spreadsheet file format like BIFF (.xls), OfficeOpenXML (.xlsx) or OASIS (.ods)

answered Jan 17 '17 at 09:59

Mark Baker

209,507
32
346
385

can i use fputcsv after create new sheet? – shanthi Jagadeesh Jan 17 '17 at 10:01
No, you can't use multiple sheets with CSV. You have to use a whole different PHP extension, which won't create a `.csv` file, but a `.xls` or `.xlsx` file. – roberto06 Jan 17 '17 at 10:04
Thanks for ur answer Sir. – shanthi Jagadeesh Jan 17 '17 at 10:06

how to create another sheet while write data using fputcsv in php

2 Answers2