使用Spreadsheet Excel Writer php为Excel单元格中的特定单词设置颜色 [英] Set the color for a specific word in a Excel cell using Spreadsheet Excel Writer php
问题描述
我正在尝试使用Spreadsheet_Excel_Writer设置单元格中特定单词的颜色,但在文档.
I am trying to set the color for a specific word in a cell using Spreadsheet_Excel_Writer but did not found any way in the documentation.
我必须为单元格的第一个单词设置红色,但不能为其中的整个文本设置红色.
I have to set the red color for the first word of a cell but not for the whole text in it.
是否可以使用Spreadsheet_Excel_Writer做到这一点?
Is there a way to do this with Spreadsheet_Excel_Writer?
推荐答案
XMLSS规范允许您使用标签,您可以使用这些标签来更改字体的颜色.请参阅 http://msdn.microsoft .com/zh-CN/library/aa140066(v = office.10).aspx#odc_xmlss_ss:data
The XMLSS spec allows you to use tags, which you can use to change the colour of the font. See http://msdn.microsoft.com/en-us/library/aa140066(v=office.10).aspx#odc_xmlss_ss:data
在这种情况下,Spreadsheet_Excel_Writer不适用于您,但是,如果要将文档另存为XML,则可以按照下面的示例将第一个单词包装在字体标签中.
Spreadsheet_Excel_Writer won't work for you in this case, however if you want to save the document as XML, you can then wrap your first word in a font tag as per the example below.
<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ss:Worksheet ss:Name="Sheet1">
<Table>
<Column/>
<Row>
<Cell>
<ss:Data xmlns="http://www.w3.org/TR/REC-html40" ss:Type="String">
<Font html:Color="#00ff00">green</Font>
<Font html:Size="48" html:Color="#ff0000">red</Font>
<Font html:Color="#0000ff">blue</Font>
</ss:Data>
</Cell>
</Row>
</Table>
</ss:Worksheet>
</Workbook>
请注意,这是XML而不是HTML,因此它们必须格式正确.
Just make note that this is XML not HTML so they must be well formed.
这篇关于使用Spreadsheet Excel Writer php为Excel单元格中的特定单词设置颜色的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!