You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by David Thielen <da...@windward.net> on 2004/12/04 18:28:20 UTC
Some getting started questions
Hi;
I'm creating spreadsheets (this is great) and have a couple of questions.
All of these are for creating xls files:
1. How do I format part of a cell differently from the rest of the cell
(ie bold just some of the text in the cell)?
2. Does xls have the concept of sections like Word does?
a. If so, how do I set that?
b. And how do I set section properties (page size, etc.)?
3. Where do I set the document properties (standard page size, header,
creator, etc.)?
4. How do I set a hard page break?
5. Does xls have fields like Word?
6. How do I set hyperlinks in the file?
And here is the biggie. I am building the xls file as I get a stream of
objects giving me the size of paragraphs of text and then the size of
tables/rows/cells. This means that only when I get to a table in my stream
do I know where each cell starts and ends. So I can't pre-set all the column
widths for the spreadsheet.
Is there a way on the fly as I create each row to just set cell positions
and the final xls will line everything up ok?
I am just starting so I apologize if any of the above is included in the
documentation (which I like - it is concise yet explains a lot). But the
above are the things I have not found so far.
Thanks - dave
Re: hyperlink discussions
Posted by Danny Mui <da...@muibros.com>.
try this link
http://marc.theaimsgroup.com/?l=poi-user&w=2&r=1&s=hyperlink&q=b
David Thielen wrote:
> Hi;
>
>
>
> Ok, I think this makes no sense. But a search of the maillist for hyperlink
> returns nothing.
>
>
>
> http://nagoya.apache.org/eyebrowse/SearchList?listId=
> <http://nagoya.apache.org/eyebrowse/SearchList?listId=&listName=poi-user@jak
> arta.apache.org&searchText=hyperlink&defaultField=body&Search=Search>
> &listName=poi-user@jakarta.apache.org&searchText=hyperlink&defaultField=body
> &Search=Search
>
>
>
> Any ideas?
>
>
>
> Thanks - dave
>
>
>
> -----Original Message-----
> From: Danny Mui [mailto:danny@muibros.com]
> Sent: Monday, December 06, 2004 10:48 AM
> To: POI Users List
> Subject: Re: Some getting started questions
>
>
>
> ...
>
>
>>6. How do I set hyperlinks in the file?
>
>
>
>
> search the mailing list on common approaches to do so.
>
> ...
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: hyperlink discussions
Posted by David Thielen <da...@windward.net>.
Hi;
Ok, I think this makes no sense. But a search of the maillist for hyperlink
returns nothing.
http://nagoya.apache.org/eyebrowse/SearchList?listId=
<http://nagoya.apache.org/eyebrowse/SearchList?listId=&listName=poi-user@jak
arta.apache.org&searchText=hyperlink&defaultField=body&Search=Search>
&listName=poi-user@jakarta.apache.org&searchText=hyperlink&defaultField=body
&Search=Search
Any ideas?
Thanks - dave
-----Original Message-----
From: Danny Mui [mailto:danny@muibros.com]
Sent: Monday, December 06, 2004 10:48 AM
To: POI Users List
Subject: Re: Some getting started questions
...
> 6. How do I set hyperlinks in the file?
search the mailing list on common approaches to do so.
...
Re: Some getting started questions
Posted by Danny Mui <da...@muibros.com>.
Answers inline.
David Thielen wrote:
> Hi;
>
>
>
> I'm creating spreadsheets (this is great) and have a couple of questions.
> All of these are for creating xls files:
>
> 1. How do I format part of a cell differently from the rest of the cell
> (ie bold just some of the text in the cell)?
This is called Rich Text functionality. HSSF doesn't support that at
this time.
> 2. Does xls have the concept of sections like Word does?
> a. If so, how do I set that?
> b. And how do I set section properties (page size, etc.)?
usually called sheets. check the API for sheet printing options
> 3. Where do I set the document properties (standard page size, header,
> creator, etc.)?
sheet printing options
> 4. How do I set a hard page break?
row breaks? see API.
> 5. Does xls have fields like Word?
form fields?
> 6. How do I set hyperlinks in the file?
search the mailing list on common approaches to do so.
>
> And here is the biggie. I am building the xls file as I get a stream of
> objects giving me the size of paragraphs of text and then the size of
> tables/rows/cells. This means that only when I get to a table in my stream
> do I know where each cell starts and ends. So I can't pre-set all the column
> widths for the spreadsheet.
widths work a little strange (due to font width calculations). you may
choose to "merge" a few columns on the fly to help you accomodate
especially large rows?
>
> Is there a way on the fly as I create each row to just set cell positions
> and the final xls will line everything up ok?
line up ok is up to you. you can dynamically create rows and cells.
>
> I am just starting so I apologize if any of the above is included in the
> documentation (which I like - it is concise yet explains a lot). But the
> above are the things I have not found so far.
>
>
>
> Thanks - dave
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org