CODEWITHSUNDEEP
phpexport-to-csv
Quicksilver
Quicksilver

Reputation: 2700

printing a new line in a csv file cell

I am generating an CSV file in php. I need to print the text in new line inside a cell(I can do this in excel using Ctrl+Enter or Alt+Enter). For that I tried using '\n', '\r', but nothing helped. How can I achieve this?

I am using yii extension ECSVExport to generate csv.

I want an output like this:

ID  Value
1   A
    B
2   C
3   E
    FF
    G
4   X

Upvotes: 23

Views: 68946

Answers (2)

Samy Massoud
Samy Massoud

Reputation: 4385

Warning: this short remark is not a generic answer to the question. Consider checking another answer below.

Try this

"\n"

inside double quote

Upvotes: 26

Mark Baker
Mark Baker

Reputation: 212452

Use "\n" inside the cell value (wrapped in ") and "\r\n" for your end-of-record marker. If your cell entry include multiple lines, then you must enclose it in "

$fh = fopen('test1.csv', 'w+');
fwrite($fh, "sep=\t" . "\r\n");
fwrite($fh, 'A' ."\t" . 'B' . "\t" . 'C' . "\r\n");
fwrite($fh, 'D' ."\t" . "\"E\nF\nG\"" . "\t" . 'H' . "\r\n");
fclose($fh);

or (working with variables)

$varA = 'A';
$varB = 'B';
$varC = 'C';
$varD = 'D';
$varE = 'E';
$varF = 'F';
$varG = 'G';
$varH = 'H';
$fh = fopen('test2.csv', 'w+');
fwrite($fh, "sep=\t"."\r\n");
fwrite($fh, $varA . "\t" . $varB . "\t" . $varC . "\r\n");
fwrite($fh, $varD . "\t" . "\"$varE\n$varF\n$varG\"" . "\t" . $varH . "\r\n");
fclose($fh);

or (using fputcsv())

$fh = fopen('test3.csv', 'w+');
fwrite($fh, "sep=\t" . "\r\n");
fputcsv($fh, array('A', 'B', 'C'), "\t");
fputcsv($fh, array('D', "E\nF\nG", 'H'), "\t");
fclose($fh);

or (using fputcsv() and working with variables)

$varA = 'A';
$varB = 'B';
$varC = 'C';
$varD = 'D';
$varE = 'E';
$varF = 'F';
$varG = 'G';
$varH = 'H';
$fh = fopen('test4.csv', 'w+');
fwrite($fh, "sep=\t" . "\r\n");
fputcsv($fh, array($varA, $varB, $varC), "\t");
fputcsv($fh, array($varD, "$varE\n$varF\n$varG", $varH), "\t");
fclose($fh);

Upvotes: 25

Related Questions