Excel CSV

[Nodral]

Hi

 

I'v a script that generates a CSV file which the user then downloads in Excel.  Is there a way of setting column widths in the excel.csv file prior to opening?  Some of the data generated is longer than the standard column width and the user is expected to print the file.  I can't rely on the user having enough 'grey matter' to realise they will have to increase the width prior to printing!!

[silkfire]

Export it as an XLS. You will not have control of width with a CSV file, it's pure data.

[dragon_sa]

Actually you can set the widths by putting your data in a table use this format in your headers

 

// Convert page to xls document
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("content-disposition: attachment;filename=filename.xls");

 

Then set out the rest of the page in a table keeping the width to your page width, I have used this method for tax reporting software and works fine.

 

You are also able to change background colors of cells and include borders if you wish.