poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ratna <ratnachar...@gmail.com>
Subject Rich text string implementation in Biggriddemo
Date Mon, 03 Oct 2016 09:54:42 GMT
 Could you please specify the XML format for each cell,as mine is not working

<?xml version="1.0" encoding="UTF-8"?><worksheet
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><sheetData>
<row r="1">
<c r="A1" t="inlineStr" s="5"><is><t>Title</t></is></c><c
r="B1"
t="inlineStr" s="5"><is><t>% Change</t></is></c><c r="C1"
t="inlineStr"
s="5"><is><t>Ratio</t></is></c><c r="D1" t="inlineStr"
s="5"><is><t>Expenses</t></is></c><c r="E1" t="inlineStr"
s="5"><is><t>Date</t></is></c></row>
<row r="2">
<c r="B2"><si><r><rPr><sz val="11"/><color theme="4"/><rFont
val="Calibri"/><family val="2"/><scheme
val="minor"/></rPr><t>Blue</t></r><r><rPr><sz val="11"/><color
theme="1"/><rFont val="Calibri"/><family val="2"/><scheme
val="minor"/></rPr><t xml:space="preserve"> </t></r><r><rPr><u/><sz
val="11"/> <color theme="9"/> <rFont val="Calibri"/> <family val="2"/>
<scheme val="minor"/> </rPr> <t>Widget</t> </r></si> </c><c
r="C2"
t="inlineStr"><is><t>V</t></is></c><c r="D2"
t="inlineStr"><is><t>K</t></is></c></row>
</sheetData></worksheet>

My requirement is like in one cell "Blue Widget" with murltiple tesxt
style,remaining three cells with V and K

I formatted XML like this,multiple style is not working.Please give me as
ample XML format for multiple styling in one cell  and no styling in another
cell for a sinlge workssheet in SPreadsheet xml format
Please help me as iam strucked.

Thanks in advance




--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Rich-text-string-implementation-in-Biggriddemo-tp5724964.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message