I am also looking out for the solution for this proble. Applying differet
font/styles to sub part of cell values.
In SXSSF,has anything been discovered to handle such scenarios?
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/BigGridDemo-for-a-RichText-tp3412641p5724980
Hi Nick,
I will explain the issue i faced,kindly take a look and suggest me.
We need an java export for nearly 1lakh records,in which in one cell in
the worksheet needs a multiple styling text(Say for example - "BLUE WIDGET"-
Blue in bold and Red color,widget in green color).
As i implemented S
As RICH text string wont work it out in SXSSF,i came back to biggriddemo,do u
have any sample xml,please attach it for rich textstring
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/BigGridDemo-for-a-RichText-tp3412641p5724967.html
Sent from the POI - User mailing list
On Sun, 2 Oct 2016, Ratna wrote:
Could you please specify the XML format for each cell,as mine is not working
Don't use BigGridDemo any more! You should use SXSSF instead
Nick
-
To unsubscribe, e-mail: user-unsubscr...@poi.ap
Could you please specify the XML format for each cell,as mine is not working
http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
Title% ChangeRatioExpensesDate
Blue
Widget VK
My requirement is like in one cell "Blue Widget" with murltiple tesxt
style,remaining three cells with
Good news and yes, the shared strings table does sound like the correct
approach. I supect the answer to the encoding question lies within the code
of the XSSFRichTextString class. It will use other classes from the xmlbeans
layer I am sure but if you have a dig through the source for that class, i
just tried adding a formatted string into the sharedString and referenced it
from the sheetn.xml and it worked, while putting the same string in the
sheetn.xml as an inlineStr didn't, i think that's what i'll try to do, build
the sharedString.xml and fill it with data, not i just need to see how to
Yes, you can do that of course. The impetus behind my idea was to preclude
the requirement for the sharedStrings.xml file in the first place and to
'stuff' everything into the sheetn.xml file. If that were possible, you
would not need to make any changes to the way BigGridDemo currently works,
just
Not sure i understand,
what i thought was needed to be done is change the cell type to s and not
inlineStr, and give it an id, and then build the sharedString.xml to include
this string with the given id?
On Tue, Mar 8, 2011 at 2:38 PM, Mark Beardsley wrote:
> ..and that failed as well. Suffic
..and that failed as well. Suffice it to say there is mark-up in the
sharedStrings.xml file that defines the contents for the cell and the format
of the same. There are tags that define the fonts and other characteristcs
and this chunk of mark-up is then referenced from the cell record in the
sheet
Well that failed. Lets see if I can get the mark-up into the message by
smuggling it in as a String of text
"
Rich
Text
String
"
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/BigGridDemo-for-a-RichText-tp3412641p3413866.html
Sent from the POI - User mailing list ar
This morning, I had the chance to play around just a little and hope this
will explain a little better my post from yesterday.
Using Excel, I created a workbook with a single sheet in it. That sheet had
a couple of cells populated with Strings and one of these strings I
formatted
so that one word
No real advice from me I am afraid other than a way to make a start on the
problem. As you possibly know, xlsx files are simply zipped xml and so my
first step would be to create a very simple file using Excel, change the
extension to .zip and then unzip it. After that, you can have a dig around
in
13 matches
Mail list logo
