<div>
Hi,<br />
I prefer not to change the whole code. <br />
I prefer &nbsp;keeping fromArray function and &nbsp;set the format of specific cells to text (or better set format of all column to text) if it is possible.
</div>


Hi,
I prefer not to change the whole code.
I prefer  keeping fromArray function and  set the format of specific cells to text (or better set format of all column to text) if it is possible.

<div>
Used the binder and worked. Thank you.
</div>


<div>
<div class="content wysiwyg-content">
I use the below to prepare my Excel sheet<br />
&nbsp;$objPHPExcel-&gt;getActiveShe<wbr />et()-&gt;from<wbr />Array($dat<wbr />asource, null, 'A3'); <br />
<br />
The problem is &nbsp;the values like 22.651 or 22,699 are formatted as numbers by default but I want to format the whole column &nbsp;as text.<br />
<br />
I tried this &nbsp;but not worked &nbsp;(it converts &nbsp;22.651 to 22,651)<br />
$objPHPExcel-&gt;getActiveShe<wbr />et()-&gt;getS<wbr />tyle(bla,b<wbr />la)-&gt;getNu<wbr />mberFormat<wbr />()-&gt;setFor<wbr />matCode(PH<wbr />PExcel_Sty<wbr />le_NumberF<wbr />ormat::FOR<wbr />MAT_TEXT);<wbr /><br />
<br />
Here <br />
stackoverflow.com/question<wbr />s/12457610<wbr />/reading-n<wbr />umbers-as-<wbr />text-forma<wbr />t-with-php<wbr />excel<br />
they suggest to use a binder but I want to use fromArray because I believe that it is much more faster.<br />
<br />
So keeping fromArray function how can I set the format of specific cells to text (or better set format of all column to text)?<br />
Thank you.
</div>
</div>


I use the below to prepare my Excel sheet
 $objPHPExcel->getActiveSheet()->fromArray($datasource, null, 'A3'); 

The problem is  the values like 22.651 or 22,699 are formatted as numbers by default but I want to format the whole column  as text.

I tried this  but not worked  (it converts  22.651 to 22,651)
$objPHPExcel->getActiveSheet()->getStyle(bla,bla)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);

Here 
stackoverflow.com/questions/12457610/reading-numbers-as-text-format-with-phpexcel
they suggest to use a binder but I want to use fromArray because I believe that it is much more faster.

So keeping fromArray function how can I set the format of specific cells to text (or better set format of all column to text)?
Thank you.

Format cell as text PHPExcel

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.