laravel excel numbers formatted as text still appearing as number

Solutions on MaxInterview for laravel excel numbers formatted as text still appearing as number by the best coders in the world

showing results for - "laravel excel numbers formatted as text still appearing as number"

1
2I found a workaround by using setCellValueExplicit()
3eg:
4
5$sheet->setColumnFormat(array( //se formatea la columna a texto
6    'C' => \PHPExcel_Style_NumberFormat::FORMAT_TEXT,
7    'I' => 'dd-mm-yyyy hh:mm'
8));
9
10$sheet->setCellValueExplicit('C10', $object->card_number, \PHPExcel_Cell_DataType::TYPE_STRING);
11
12Hope this helps ;)

similar questions

cart 3a 3atotal return number format value laravel excel return integer from date column laravel laravel excel laravel datatable format date column laravel excel import date laravel validate number to be at least 3 digits laravel validation numeric vs integer number format php laravel excel freeze row laravel excel prevent number format php number format laravel excel avoid scientific notation for long numbers convert 1 digit to five digits laravel laravel number add 0 before laravel format number blade valid number in excel php how handle the number with k in laravel balde laravel excel set cell height

queries leading to this page

laravel excel number scientific notation text laravel excel return cell with no decimal vlaue excel number format laravel laravel excel formatting phone number laravel excel put a cell in a number format formate big numbers in maatwebsite csv zero leading format in laravel excel 2 1 laravel excel how to ensure values are treated as text laravel excel export long number e2 80 9claravel excel numbers formatted as text still appearing as number laravel excel numbers formatted as text still appearing as number laravel excel appends 0 to numeric laravel excel numbers formatted as text still appearing as number