用过jxl的来帮帮忙，急阿！！！！！！！！！！！！

Question

也不熟！不过我想是否有properties的东东set一下呢。

Answer 1

帮你up...大家先帮我看一个问题啊,100分,不够再加,烦死人了...http://community.csdn.net/Expert/topic/3848/3848281.xml?temp=3.403872E-02

Answer 2

/**************设置单元格字体***************/
  WritableFont NormalFont = new WritableFont(WritableFont.ARIAL,10);
  WritableFont BoldFont = new WritableFont(WritableFont.ARIAL,14,WritableFont.BOLD);  /**************以下设置几种格式的单元格*************/
  //用于标题
  WritableCellFormat wcf_title = new WritableCellFormat(BoldFont);
  wcf_title.setBorder(Border.NONE, BorderLineStyle.THIN); //线条
  wcf_title.setVerticalAlignment(VerticalAlignment .CENTRE); //垂直对齐
  wcf_title.setAlignment(Alignment.CENTRE); //水平对齐
  wcf_title.setWrap(false); //是否换行
你要设置单元格
如：
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.lang.Integer"%>
<%@ page import="java.io.File"%>
<%@ page import="jxl.Workbook"%>
<%@ page import="jxl.WorkbookSettings"%>
<%@ page import="jxl.Range"%>
<%@ page import="jxl.write.WritableWorkbook"%>
<%@ page import="jxl.write.WritableSheet"%>
<%@ page import="jxl.write.WritableFont"%>
<%@ page import="jxl.write.WritableCellFormat"%>
<%@ page import="jxl.write.NumberFormats"%>
<%@ page import="jxl.write.DateFormats"%>
<%@ page import="jxl.write.Label"%>
<%@ page import="jxl.write.Number"%>
<%@ page import="jxl.write.DateTime"%>
<%@ page import="jxl.write.NumberFormat"%>
<%@ page import="jxl.write.DateFormat"%>
<%@ page import="jxl.write.WriteException"%>
<%@ page import="jxl.write.WritableHyperlink"%>
<%@ page import="jxl.write.Boolean"%>
<%@ page import="jxl.write.Formula"%>
<%@ page import="jxl.format.Alignment"%>
<%@ page import="jxl.format.VerticalAlignment"%>
<%@ page import="jxl.format.Border"%>
<%@ page import="jxl.format.BorderLineStyle"%>
<%@ page import="jxl.format.Colour"%>
<%@ page import="jxl.format.UnderlineStyle"%>
<%@ page import="jxl.format.ScriptStyle"%>
<%@ page import="jxl.format.Orientation"%>
<%@ page import="jxl.format.PageOrientation"%>
<%@ page import="jxl.format.PaperSize"%>
<%
 boolean bExportSucc = false;
 String sErrorStr="";  String sFileName="Test.xls";
  String dirStr=getServletContext().getRealPath("/")+"excel\\";
  String sCurrPath=dirStr+sFileName; //以下开始输出到EXCEL
 try {
  /************创建工作簿*************/
  WritableWorkbook workbook = Workbook.createWorkbook(new File(sCurrPath));
  /************创建工作表*************/
  WritableSheet sheet = workbook.createSheet("定单", 0);
  /************设置页眉、页脚******************/
  sheet.setHeader("页眉","","第 &P 页，共 &N 页"); //设置页眉
  sheet.setFooter("","","&D &T"); //设置页脚
  /******注：以上这些&P、&D等参数可以从EXCEL的宏录制取得***** ***/  /***********设置列宽*****************/
  sheet.setColumnView(0,13); //第1列
  sheet.setColumnView(1,26); //第2列
  sheet.setColumnView(2,13);
  sheet.setColumnView(3,26);  /**************设置单元格字体***************/
  WritableFont NormalFont = new WritableFont(WritableFont.ARIAL,10);
  WritableFont BoldFont = new WritableFont(WritableFont.ARIAL,14,WritableFont.BOLD);  /**************以下设置几种格式的单元格*************/
  //用于标题
  WritableCellFormat wcf_title = new WritableCellFormat(BoldFont);
  wcf_title.setBorder(Border.NONE, BorderLineStyle.THIN); //线条
  wcf_title.setVerticalAlignment(VerticalAlignment .CENTRE); //垂直对齐
  wcf_title.setAlignment(Alignment.CENTRE); //水平对齐
  wcf_title.setWrap(false); //是否换行  //用于正文左
  WritableCellFormat wcf_left = new WritableCellFormat(NormalFont);
  wcf_left.setBorder(Border.ALL, BorderLineStyle.THIN); //线条
  wcf_left.setVerticalAlignment(VerticalAlignment. CENTRE); //垂直对齐
  wcf_left.setAlignment(Alignment.LEFT);
  wcf_left.setWrap(true); //是否换行  //用于正文右
  WritableCellFormat wcf_right = new WritableCellFormat(NormalFont);
  wcf_right.setBorder(Border.ALL, BorderLineStyle.THIN); //线条
  wcf_right.setVerticalAlignment(VerticalAlignment .CENTRE); //垂直对齐
  wcf_right.setAlignment(Alignment.RIGHT);
  wcf_right.setWrap(false); //是否换行  //用于跨行
  WritableCellFormat wcf_merge = new WritableCellFormat(NormalFont);
  wcf_merge.setBorder(Border.ALL, BorderLineStyle.THIN); //线条
  wcf_merge.setVerticalAlignment(VerticalAlignment .TOP); //垂直对齐
  wcf_merge.setAlignment(Alignment.LEFT);
  wcf_merge.setWrap(true); //是否换行
  /**************单元格格式设置完成*******************/  /*****************以下是标题************************* **/
  sheet.mergeCells(0, 0, 3, 0); //合并单元格
  sheet.addCell(new Label(0,0,"标题",wcf_title));  /*****************以下是定单内容**********************/
  sheet.addCell(new Label(0,2,"正文左",wcf_right));
  sheet.addCell(new Label(0,3,"正文左1",wcf_right));  sheet.addCell(new Label(2,2,"正文左2",wcf_right));
  sheet.addCell(new Label(2,3,"正文左3",wcf_right));  sheet.addCell(new Label(1,2,"正文右",wcf_left));
  sheet.addCell(new Label(1,3,"正文右1",wcf_left));  sheet.addCell(new Label(3,2,"正文右2",wcf_left));
  sheet.addCell(new Label(3,3,"正文右3",wcf_left));  /*************详细内容***************/
  sheet.mergeCells(0, 4, 3, 4);
  sheet.setRowView(4,50); //设置行高
  sheet.addCell(new Label(0,4,"跨行内容",wcf_merge));  /****************联系/回复方式等*******************/
  int iRow = 4;
  sheet.addCell(new Label(0,iRow+1,"正文左",wcf_right));
  sheet.addCell(new Label(0,iRow+2,"正文左1",wcf_right));
  sheet.addCell(new Label(0,iRow+3,"正文左2",wcf_right));  sheet.addCell(new Label(2,iRow+1,"正文左3",wcf_right));
  sheet.addCell(new Label(2,iRow+2,"正文左4",wcf_right));
  sheet.addCell(new Label(2,iRow+3,"正文左5",wcf_right));  sheet.addCell(new Label(1,iRow+1,"正文右",wcf_left));
  sheet.addCell(new Label(1,iRow+2,"正文右1",wcf_left));
  sheet.addCell(new Label(1,iRow+3,"正文右2",wcf_left));  sheet.addCell(new Label(3,iRow+1,"正文右3",wcf_left));
  sheet.addCell(new Label(3,iRow+2,"正文右4",wcf_left));  sheet.addCell(new Label(3,iRow+3,"正文右5",wcf_left));
  jxl.write.WritableImage wi=new jxl.write.WritableImage(5,5,5,7,new File(dirStr+"tu.png"));
  sheet.addImage(wi);  sheet.mergeCells(0,iRow+4,3,iRow+4);
  sheet.setRowView(iRow+4,50);
  sheet.addCell(new Label(0,iRow+4,"跨行内容1",wcf_merge));  /************以上所写的内容都是写在缓存中的，下一句将缓存的内容写到文件中***** ****/
  workbook.write();
  /***********关闭文件**************/
  workbook.close();
  bExportSucc = true;
 } catch(Exception e){
  sErrorStr = e.toString();
  System.out.println("在输出到EXCEL的过程中出现错误，错误原因："+e.toString());
}
%>
<html>
 <head>
  <title>EXCEL输出</title>
  <link rel=stylesheet href="../style/wholeStyle.css" type="text/css">
    <link rel=stylesheet href="../style/specialStyle.css" type="text/css">
 </head>
 <body>
   <div align=center>
  <%if ( bExportSucc ) { %>
   <font color=blue>成功输出到EXCEL文件！<br/>
   <br/>
   <br/>
        请点击鼠标右键选择“目标另存为”将EXCEL文件下载到本地
         </font>
      <%} else {%>
       <font color=red>
        在输出到EXCEL文件的过程中发生错误，错误原因： <%=sErrorStr%>
       </font>
      <%}%>
     </div>
</body>
</html>

Answer 3

多谢你们，我是想设置页边距，纸张大小等，希望大家关注一下这个问题。
Class SheetSettings 有这个类可以完成我说的功能，不过我不知道怎样拿到他的实例，

Answer 4

SheetSettings getSettings() 
          Gets the settings used on a particular sheet Workbook wb=Workbook.getWorkbook(new File("c:\\bug.xls")); 
Sheet sheet = wb.getSheet(0); 
SheetSettings ss = sheet.getSettings(); \\这句出错！！