POI is only for MS-Document formats. To read ODF-Files you should use
the OO-API which can be accessed from many different languages.
An example how to convert OpenOfficeDocuments to other formats can be
found here:
http://codesnippets.services.openoffice.org/Office/Office.ConvertDocuments.sni
ice for this purpose. Depending on the OpenOffice
> installation will mean that I will have to port OpenOffice along with my own
> application. Is there any other workaround to solve this problem?
>
> Thanks,
> Suyog
>
> - Original Message -
> From: "Tom Schindl&q
Suyog Mahajan schrieb:
> Hi Karl,
>
> Thanks for your prompt response. I have already seen that thread about using
> OOo for format conversion. But I am unable to figure out how to use it. The
> solution I am looking for, is like a JAR file, you simply port it with your
> application, and this JAR
KHZ (SAW) schrieb:
> Hi Ravi.
>
> There are code snippets which you find in the internet and in the
> documentation (some directory of the installation; as it's some time away
> don't ask me about the exact name).
>
http://codesnippets.services.openoffice.org/Office/Office.ConvertDocuments.snip
Well data is sent to you following multipart/form-data you need to use
something like commons-fileupload
(http://jakarta.apache.org/commons/fileupload/) to read the file sent to
you from the browser.
Tom
Natu, Ashlesha [IT] wrote:
> Hi,
>
> I am new to POI. I am trying to upload an excel sheet
Beyer, Daniel (SL1 D) wrote:
> thx, but i wrote the following and it doesn´t seem to work:
>
> HSSFCellStyle captionStyle = workBook.createCellStyle();
> captionStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
The next line is not needed
> captionStyle.setFillBackgroundColor
Strange enough what you need is setFillForeground and the style is
HSSFCellStyle.SOLID_FOREGROUND
Tom
Beyer, Daniel (SL1 D) wrote:
> Hello,
>
> i am new to POI and trying to generate an Excel-File.
> My prob ist that the background-color setting doesn´t work.
>
> My Code ist here:
>
I think that your problem is that the XLS is saved into a too new format
I think I can remember this exception when loading Spreadsheets created
with a new excel and saved them to the current excel format. Try saving
it as Excel an older Excel Format.
Tom
Nick Heudecker wrote:
> I'm encountering
t is using odt extension for source file. Will it work
> with XLS?
> Regards,
> Tahir
> -Original Message-
> From: Tom Schindl [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 08, 2006 8:05 PM
> To: POI Users List
> Subject: Re: POI to PDF
>
> Well you
Well you can't export to PDF from POI you need to load the file into
e.g. OpenOffice using UNO and let OO do the Job for you. How this can be
done is shown in the codesnippet here:
http://codesnippets.services.openoffice.org/Office/Office.ConvertDocuments.snip
Tom
Tahir Akhtar wrote:
> Hi,
>
>
There's been a thread about this a while ago. Search the archives.
Tom
Bickel, Sean wrote:
> Is there a way to autofit a column width in excel?
>
> Also, Is there a way to search the mailing archive?
>
> Thanks
> Sean Bickel
>
> -
Although not pure Java you can use OOffice's UNO-Bridge to extract
almost everything from a word, excel, ppt, ... .
Take a look at:
http://api.openoffice.org
Tom
Andreas Höhmann wrote:
> Hi folks,
>
> on http://jakarta.apache.org/poi/hwpf/projectplan.html there is a
> milestone for year 2003 (a
dex.
> I'll try the named colors approach.
>
> Claus
>
> -----Ursprüngliche Nachricht-
> Von: Tom Schindl [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 26. Januar 2006 13:00
> An: Claus Luethje; POI Users List
> Betreff: Re: AW: AW: Excel colors
>
&
) relevant?
>
> Claus
>
> -Ursprüngliche Nachricht-
> Von: Tom Schindl [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 26. Januar 2006 12:37
> An: POI Users List; Claus Luethje
> Betreff: Re: AW: Excel colors
>
> Ok and here's the 'fault', This
LS style according to a table definition. The
> method 'tfd.getEvenRowColor()' returns the HSSFColor - as converted by the
> getColor(final Color col) method from my first mail.
>
> Claus
>
> -Ursprüngliche Nachricht-
> Von: Tom Schindl [mailto:[EMAIL PROTE
Could you post the code how you are setting the background color on a cell?
Tom
Claus Luethje wrote:
> Hi,
> I build an excel sheet with colored cells and texts, and it works fine
> when I use the predefined colors. But when I add colors myself, I get
> grey scale colors. Do I have to change some
Have you tried running gc inside your loop?
Tom
[EMAIL PROTECTED] wrote:
> Hello,
>
> Thx to Marot Laurent, Stefan and Karsten Voges.
> 2 solutions :
> - increase the heap size with –Xmx (it depends if you can or not)
> - use CSV instead of Excel file for large data(more than 5000 -1
Hi,
I have the problem that I want to use my own colors in Excel. I read the
quick guide about custom colors and when registering my own color using
this method e.g. red with RGB(255,0,0) the color displayed in Excel is
not a read matching 255,0,0 but a much darker red it seems that it is
the red
18 matches
Mail list logo
