[RESOLVED] creating Excel file - troube with columnsg

tomas_teicher

Hi,
I want to create csv file which will be read in Excel. I found some scripts on the web using various classes and various functions. I tried each of them and I got the same problem. Created csv. file has only one column.
for example
<?php

$list = array (
'aaa,bbb,ccc,dddd',
'123,456,789',
'"aaa","bbb"'
);

$fp = fopen('file1.csv', 'w');

foreach ($list as $line) {
fputcsv($fp, split(',', $line));
}

fclose($fp);

?>
I just cannot understand how to create Excel file with more columns using PHP

scrupul0us

you need to add field delimiters

	//COLUMN HEADS
	$line = '"First Name","Last Name","Company","Email"'."\n";
	file_put_contents($file,$line,FILE_APPEND);

//LOOP STRUCTURE
$line = '"'.$fn.'","'.$ln.'","'.$cn.'","'.$ea.'"'."\n";
file_put_contents($file,$line,FILE_APPEND);
//LOOP STRUCTURE

tomas_teicher

hi,
thanks for reply,
I tried it but it still doesnt work. I got this text in cell A1: First Name,"Last Name","Company","Email". Everything in cell A1. Maybe I have to set something in headers. I dont know. I tried many scripts on the web and for each time I got only one column. I use Excel within MS Office 2007.

tomas_teicher

now it works. I used semicolon instead of comma and it works. I dont know why I have to change delimitator, but I am lucky that it works. Many thanks
Tomas

johanafm

The , vs ; is some kind of windows, office or excel setting. Somewhere. Furthermore, I'd take a guess the ; is used as field delimiter on systems using , as a decimal point. But it should be possible to change, once you find that "somewhere".

scrupul0us

Start / Settings / Control Panel / Regional and Language Options / Regional Options [Tab] / Customize [Button] / Numbers [Tab] / List Separator [Field]

tomas_teicher

Many thanks
problem resolved
Tomas