怎样控制Excel的列宽?谢谢。
这是我的一段产生Excel的程序,请问怎样控制它的列宽?
public class XML2Excel extends HttpServlet {
//static final private String CONTENT_TYPE = "text/html; charset=GBK;";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("application/vnd.ms-excel; charset=GBK");
PrintWriter out = response.getWriter();
Hashtable hs = XML2Hashtable.convert("D:\\ATML_Q1_2000.xml");
out.println(hs.get("ci:identifiers.entityName_nNC4101") +"综合财务信息\t");
out.println("文档信息");
out.print("标识符\t");
out.print(hs.get("ci:generalDocumentInformation.identifier_nNC4101\t"));
out.print("财季");
out.println(hs.get("ci:significantAccountingPoliciesNote.fiscalYearPolicy_nNC4101"));
out.print("制定日期");
out.print(hs.get("ci:generalDocumentInformation.date_nNC4101"));
out.print("标题");
out.print(hs.get("ci:generalDocumentInformation.title_nNC4101"));
out.print("创建方");
out.print(hs.get("ci:generalDocumentInformation.creator_nNC4101"));
out.print("修订日期");
out.print(hs.get("ci:revision.revisionDate_nNC4101"));
out.println("公司信息");
out.print("公司名称");
out.print(hs.get("ci:identifiers.entityName_nNC4101"));
out.print("所属行业");
out.print(hs.get("ci:industryClassification.description_nNC4101"));
out.print("标示代码");
out.print(hs.get("ci:entityIdentifier.code_nNC4101\t"));
out.print("描述");
out.print(hs.get("ci:entityIdentifier.description_nNC4101\t"));
}
//Clean up resources
public void destroy() {
}
}