HWPFDocument Questions.

2010-05-20 Thread Zachary Mitchell
If I am to go: ? //* import ...; int colorOne = 7; int ftcfe = 9; HWPFDocument document = new HWPFDocument(); FontTable fontTable = document.getFontTable(); List fontList = Arrays.asList(fontTable.getFontNames()); //This is ho

Re: POI 3.6: class not found: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPhoneticRun

2010-05-20 Thread gudfooht
Thanks for the comprehensive answer, Dave! In regards to your suggested options below: (1) Wow, that's a hefty jar file, but it did the trick. Thanks! (2) I'll get started on the bug submission. (3) My present schedule won't allow me to jump in this deep at the moment, but I'll consider it. If I

Re: Reading Shapes

2010-05-20 Thread Al Vargas
Hi Mark Yeah I had done a shapeList.get(i).getClass().getName() and every shape in the shape list returned as a HSSFTextbox (which is odd since the worksheet I'm reading has other shapes besides textboxes, but they all do contain text...). Thanks for the suggestion about looking at the parent

Re: POI 3.6: class not found: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPhoneticRun

2010-05-20 Thread David Fisher
The poi-ooxml-schemas jar is a cut-down version of ooxml-schemas-1.0.jar - the full schemas are about 13 MB. So, you will need to do one or more of three actions. (1) Replace poi-ooxml-schemas in your classpath with ooxml-schemas-1.0.jar. You can get this from the maven repository: groupId:

Re: POI 3.6: class not found: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPhoneticRun

2010-05-20 Thread gudfooht
Oh yeah, I forgot to mention that I tried setting Websphere's classloader policy to "parent last" and I still got the exception. Thanks, Ted --- On Thu, 5/20/10, gudfooht wrote: > From: gudfooht > Subject: POI 3.6: class not found: > org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPho

POI 3.6: class not found: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPhoneticRun

2010-05-20 Thread gudfooht
Hi all, I've been trying to resolve an issue for a couple of hours now, but I'm not making too much progress and I'd really appreciate any insight. I'm getting the following exception when trying to open an .xlsx spreadsheet that I'm uploading via Struts1 (full stack trace at the bottom). java

Re: html snippet in cell

2010-05-20 Thread David Fisher
Recently a contribution was made to generate HTML to render Excel according to the style. This might be useful in understanding how HTML/CSS might be converted into Excel. https://issues.apache.org/bugzilla/show_bug.cgi?id=49066 Regards, Dave On May 20, 2010, at 9:48 AM, MSB wrote: > > Ah, t

Re: html snippet in cell

2010-05-20 Thread MSB
Ah, that's because it does not existbut you might like to write one and submit it to the project. Forgive the heavy handed hint please and the time it took to reply. You must have posted your reply as I was writing mine in response to David's question. Seriously though, it should not be too ha

Re: Reading Shapes

2010-05-20 Thread MSB
Hello Al, Sorry to say that I do not have an answer for you but rather a couple of questions. When you say that they are all instances of HSSFTExtbox, how do you know? Have you done a getClass().getName() (shapeList.get(i).getClass().getName()) on the contents of the shapes list? Secondly, I do

Re: html snippet in cell

2010-05-20 Thread Guilherme Mussi
Hey, thanks for your reply, but actually my question was exactly how to build a cell (with the XSSF api) from a simple html snippet. Something like RichTextString rts = parseHtmlToRichText("some text here"); I searched for such function but couldn't find anyhting. Regards, -- Guilherme Petterl

Re: html snippet in cell

2010-05-20 Thread MSB
Hello David, The honest answer is I do not know, but thinking about it a little further and I would expect it to be rendered as simple text rather than interpreted as markup. It should be easy enough to test and, if I ever do manage to find out how to get headers and footers in Word documents wor

Re: html snippet in cell

2010-05-20 Thread David Fisher
Hi Mark, I am curious what happens if you write strict XHTML to a cell in XSSF? Regards, Dave On May 20, 2010, at 8:50 AM, MSB wrote: > > So, let me get this clear, you are NOT asking how to use POI but a more > general question about Excel - how to place HTML into a cell? > > If this is the

Re: html snippet in cell

2010-05-20 Thread MSB
So, let me get this clear, you are NOT asking how to use POI but a more general question about Excel - how to place HTML into a cell? If this is the case then the answer is no and yes, confused? Had a quick google and found someone had written a macro that you may be able to build upon/develop fu

html snippet in cell

2010-05-20 Thread Guilherme Mussi
Hello Folks, i'm writing to this list after a couple hours of google. I need to know whether it is possible to write an html snippet to a cell? just some tags setting the text as bold, italic, underlined, and also and can you tell me if there is any kind of implementation for this anywhere on

html snippet in cell

2010-05-20 Thread Guilherme Mussi
Hello Folks, i'm writing to this list after a couple hours of google. I need to know whether it is possible to write an html snippet to a cell? just some tags setting the text as bold, italic, underlined, and also and can you tell me if there is any kind of implementation for this anywhere on