ello.<\/p>\n
When i use some style in cell like color, font size,… then an error returned among the cell value.<\/p>\n
I use PHPExcel in this way:<\/p>\n
require_once ‘include\/excel\/PHPExcel\/IOFactory.php’;
\n$objReader = PHPExcel_IOFactory::createReader(‘Excel5’);\/\/use excel5
\n$objPHPExcel = $objReader->load($_FILES[‘excelfile’][‘tmp_name’]);
\n$FAValue = ($objPHPExcel->getActiveSheet()->getCell(‘A’.$i)->getvalue());<\/p>\n
The returened value to $FAValue will be:<\/p>\n
__PHP_Incomplete_Class::__set_state(array(
\n‘__PHP_Incomplete_Class_Name’ => ‘PHPExcel_RichText’,
\n‘_richTextElements’ =>
\narray (
\n0 =>
\n__PHP_Incomplete_Class::__set_state(array(
\n‘__PHP_Incomplete_Class_Name’ => ‘PHPExcel_RichText_TextElement’,
\n‘_text’ => ‘dsfsdf ‘,
\n)),
\n1 =>
\n__PHP_Incomplete_Class::__set_state(array(
\n‘__PHP_Incomplete_Class_Name’ => ‘PHPExcel_RichText_Run’,
\n‘_font’ =>
\n__PHP_Incomplete_Class::__set_state(array(
\n‘__PHP_Incomplete_Class_Name’ => ‘PHPExcel_Style_Font’,
\n‘_name’ => ‘Arial’,
\n‘_size’ => 10,
\n‘_bold’ => true,
\n‘_italic’ => false,
\n‘_superScript’ => false,
\n‘_subScript’ => false,
\n‘_underline’ => ‘none’,
\n‘_strikethrough’ => false,
\n‘_color’ =>
\n__PHP_Incomplete_Class::__set_state(array(
\n‘__PHP_Incomplete_Class_Name’ => ‘PHPExcel_Style_Color’,
\n‘_argb’ => ‘FF000000’,
\n‘_isSupervisor’ => false,
\n‘_parent’ => NULL,
\n‘_parentPropertyName’ => NULL,
\n)),
\n‘_parentPropertyName’ => NULL,
\n‘_isSupervisor’ => false,
\n‘_parent’ => NULL,
\n‘colorIndex’ => 32767,
\n)),
\n‘_text’ => ‘sdfsdf’,<\/p>\n
Thanks in Advance<\/p>\n
<\/p>\n
Answer:<\/p>\n
This isn’t quite the same of styling of a cell…. it’s actually rich text styling of the cell content: test to see if $FAValue is an instance of a PHPExcel_RichText object, and if so then use the getPlainText() method (or simply cast to string, as PHPExcel_RichText has a magic __toString() method).<\/p>\n
<\/p>\n
\u53c2\u8003\uff1a
\nhttp:\/\/phpexcel.codeplex.com\/discussions\/353348
\nhttp:\/\/blog.csdn.net\/longxuu\/article\/details\/7480311
\nhttp:\/\/phpexcel.codeplex.com\/discussions\/34513 \u8fd9\u91cc\u6709\u5f88\u591a\u7b54\u6848:)(<\/p>\n
<\/p>\n
<\/p>\n
\u6211\u7528\u4ee5\u4e0b\u65b9\u6cd5\u89e3\u51b3\u4e86\uff0c\u4ec5\u9650\u4e8e\u8bfb\u53d6\u3002<\/p>\n
If you need just the plain text then probably the right solution for you is to use Example:<\/p>\n $PHPExcel = $reader->load('test.xlsx');<\/p>\n $ws = $PHPExcel->getActiveSheet();<\/p>\n \/\/ A1 contains Rich-Text <\/code>It is important that you use the latest source found under ‘Source Code’ as the behavior was changed after the release of PHPExcel 1.6.3. Until recently you would get Rich-Text even with ello. When i use some style in cell like color, font si […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/posts\/110"}],"collection":[{"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/comments?post=110"}],"version-history":[{"count":1,"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/posts\/110\/revisions"}],"predecessor-version":[{"id":111,"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/posts\/110\/revisions\/111"}],"wp:attachment":[{"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/media?parent=110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/categories?post=110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sangqiao.com\/blog\/wp-json\/wp\/v2\/tags?post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}setReadDataOnly(true)<\/code> for the reader.<\/p>\n$reader = new PHPExcel_Reader_Excel2007();
\n$reader->setReadDataOnly(true);<\/p>\n
\necho $ws->getCell('A1')->getValue();<\/p>\nsetReadDataOnly(true)<\/code>.
\nhttp:\/\/www.codeplex.com\/PHPExcel\/Thread\/View.aspx?ThreadId=34770<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"