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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
