Results 1 to 5 of 5
Thread: set column width in Jxl
- 02-29-2012, 02:26 PM #1
Member
- Join Date
- Dec 2011
- Location
- Tbilisi (Georgia)
- Posts
- 24
- Rep Power
- 0
- 02-29-2012, 03:11 PM #2
Moderator
- Join Date
- Apr 2009
- Posts
- 10,438
- Rep Power
- 16
Re: set column width in Jxl
WritableSheet.setColumnView().
The link is to one of a couple of versions, but the one I suspect you need?Please do not ask for code as refusal often offends.
- 03-01-2012, 07:25 AM #3
Member
- Join Date
- Dec 2011
- Location
- Tbilisi (Georgia)
- Posts
- 24
- Rep Power
- 0
Re: set column width in Jxl
thx it helped me, if true yesturday i found this on myself but i thought that i'm wrong and closed the page and when u suggested same i read this
- 03-01-2012, 02:35 PM #4
Member
- Join Date
- Dec 2011
- Location
- Tbilisi (Georgia)
- Posts
- 24
- Rep Power
- 0
Re: set column width in Jxl
i have one more problem i using
WritableCellFormat normalFormat = new WritableCellFormat(normalFont);
normalFormat.setWrap(true);
normalFormat.setAlignment(jxl.format.Alignment.CEN TRE);
normalFormat.setVerticalAlignment(VerticalAlignmen t.CENTRE);
normalFormat.setBorder(Border.NONE, BorderLineStyle.THIN);
and then adding sme label
then i doing
WritableCellFormat normalFormat1 = new WritableCellFormat(normalFont);
normalFormat.setWrap(true);
normalFormat.setAlignment(jxl.format.Alignment.CEN TRE);
normalFormat.setVerticalAlignment(VerticalAlignmen t.CENTRE);
normalFormat.setBorder(Border.ALL, BorderLineStyle.THIN);
because now i want border and when i getting error " Attempt to modify a referenced format"
- 03-01-2012, 02:54 PM #5
Moderator
- Join Date
- Apr 2009
- Posts
- 10,438
- Rep Power
- 16
Re: set column width in Jxl
You're using the same variable name:
WritableCellFormat normalFormat = new WritableCellFormat(normalFont);
normalFormat.setWrap(true);
...
WritableCellFormat normalFormat1 = new WritableCellFormat(normalFont);
normalFormat.setWrap(true);Please do not ask for code as refusal often offends.
Similar Threads
-
insert row and column and delete row and column
By daredavil82 in forum New To JavaReplies: 13Last Post: 09-22-2011, 06:10 PM -
Column width in excel through jsp
By syed0071 in forum JavaServer Pages (JSP) and JSTLReplies: 1Last Post: 07-05-2011, 04:16 PM -
How to write column by column to text file
By trkece in forum JDBCReplies: 9Last Post: 02-15-2011, 01:13 AM -
selecting column names dynamically from table column header
By neha_sinha in forum AWT / SwingReplies: 1Last Post: 07-06-2010, 04:50 PM -
how to retrieve the width of the column
By katie in forum New To JavaReplies: 1Last Post: 08-06-2007, 10:56 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks