Home  >  Article  >  Backend Development  >  PHP generates excel and controls line breaks in Excel cells

PHP generates excel and controls line breaks in Excel cells

WBOY
WBOYOriginal
2016-07-25 09:03:562103browse
PHP generates excel and controls line breaks in Excel cells

The company uses Mantis to manage bugs. Mantis has a function to export bugs to Excel,

But in the current version of mantis, when exporting to excel, among the information such as "summary, description, instructions on steps to reproduce the problem, additional information, comments" and so on,

The carriage return and line feed characters when submitting a bug are all gone. Because there is no format, it is very inconvenient to read in excel,

Now that I think about it, this is the problem that has been improved,

When using PHP to create excel, how to write line breaks in an excel cell and control the format of the cell.

I tested it and found that rn is invalid when generating excel and will be filtered.

But if you write
, the effect is not to wrap the line in the cell, but to change a new cell.

After searching on Google, in order to achieve the purpose of wrapping lines in a cell, you need to insert the following string '
'

In addition, during my investigation, I discovered another interesting question.

As mentioned earlier, when using PHP to generate excel, rn does not have any line wrapping function. To control line wrapping, you need to use html tags.

But, if rn is mixed in

 
,

The shape is as follows, then, the rn at this time is equivalent to a
, and a new cell will be created in the generated excel. wrote

..........\r\n
..........\r\n
..........\r\n

<p>这种行为显然也不是我们想要的,</p>
<p>所以还是像下面这样, 把他们统统替换掉吧.
$p_new_lines = array("\r\n", "\n", "\r","\r\n", "</p><pre class="brush:php;toolbar:false">","
","
","","
"); $p_change_line_in_excel_cell = '
'; $p_result = str_replace( $p_new_lines,$p_change_line_in_excel_cell,$p_input);

>>>> Articles you may be interested in: php remove string newline character instance analysis php compress html (clear newlines, clear tabs, remove comment marks) How to convert textarea line breaks in php forms Code examples of php regular filtering html tags, spaces, newlines, etc. Summary of how to remove line breaks in php How to compress html webpage code with php (remove spaces, newlines, tabs, comment marks, etc.) Provide several php methods to replace line breaks



Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn