PHP write csv file merge headers

Question

$file_format = "testfile.csv";
$file = fopen($file_format,"w");

$header = array(array('Class Name','Group'));

foreach($header as $fields)
{
    fputcsv($file, $fields);
}

fclose($file);

My question is how do I merge the group cells as image below?

what does the csv look like now and what do you want it to look like after ? — user557846
– user557846, Commented Aug 28, 2015 at 3:14
Can't do anything without seeing a sample of the data... (as Dagon said above) — Darren
– Darren, Commented Aug 28, 2015 at 3:18
csv is a data exchange format and can't control the formatting of cells in excel — Orangepill
– Orangepill, Commented Aug 28, 2015 at 3:48

Community · Accepted Answer · 2017-05-23 12:24:14Z

1

You can't... a CSV file has no formatting of any kind, including column size.

If you want to control column widths, then you need to write the data to a format that does support columns widths, such as BIFF (.xls) or OfficeOpenXML (.xlsx) or OASIS Open Document Format (.ods) or Gnumeric or other spreadsheet.

From How to set size of column of csv file?

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Aug 28, 2015 at 4:35

Abdallah Alsamman

1,69216 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashish Ranade · Accepted Answer · 2015-08-28 05:01:41Z

1

If you want to manipulate the data then you can use the PHP libraries for handling CSV data link this

but if you need to show the well formatted data then you need to use the .xls file. There are lots of libraries which allows you to handle .xls data. Hope this will help you out.

answered Aug 28, 2015 at 5:01

Ashish Ranade

6053 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP write csv file merge headers

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related