CODEWITHSUNDEEP
phpfputcsv
devlin carnate
devlin carnate

Reputation: 8592

How to prevent character conversion to integer in data export in PHP

I have a link on a page that, when clicked, exports an array of data to csv using fputcsv. When Excel displays the data, there is a column that looks like an integer, but it's not, and Excel is converting it to scientific notation. How do I export the data so that this column is displayed as characters (not a scientific number) ?

The code I'm using for export is from Alain Tiemblo's answer here: Link to Code

function array2csv(array &$array)
{
   if (count($array) == 0) {
     return null;
   }
   ob_start();
   $df = fopen("php://output", 'w');
   fputcsv($df, array_keys(reset($array)));
   foreach ($array as $row) {
      fputcsv($df, $row);
   }
   fclose($df);
   return ob_get_clean();
}

Upvotes: 1

Views: 7195

Answers (4)

Radhika Choudhary
Radhika Choudhary

Reputation: 71

converting integer to string using :- string, strval or enclosing value in double/single quotes , or even concat space with the variable does not work because CSV doesn't hold field type information.

The only way I found is to add some character or symbol to forcefully make it string but that will show in output too.

Upvotes: 0

Thomas
Thomas

Reputation: 1401

You could cast the value to string using strval.

Upvotes: 0

Alex Howansky
Alex Howansky

Reputation: 53543

Not sure about Excel, but LibreOffice and OpenOffice will import fields as strings if the CSV field is quoted. For example, you want your CSV to be something like:

foo,bar,"12345",baz

(You may also have to check "Quoted field as text" option in the file open dialog.)

Edit: PHP's fputcsv() function will only use quote wrappers if it needs to, so you'll likely have to manually force quotes around the actual field value yourself:

$field = 12345;
$quoted_field = '"' . $field . '"';

Edit 2: If you don't need to worry about escaping, this might work for you instead of fputcsv():

fwrite($fp, '"' . implode($fields, '","') . '"' . "\n");

Upvotes: 1

Nathan H
Nathan H

Reputation: 49371

Try to force your int into a string before your fputcsv.

For example

$foo = "$foo";

http://php.net/manual/en/language.types.type-juggling.php

But then again Excel might make up its own mind when converting your CSV to an Excel format...

Also this question might help: Excel CSV - Number cell format

Upvotes: 0

Related Questions