java:常见问题(解决获取properties乱码,解决poi自适应宽度)
1.解决获取properties乱码
File cf = new File("D:\\app\\java_jar\\config.properties"); String[] paths = null; try { FileInputStream fis = new FileInputStream(cf); Properties pro = new Properties(); //prop.load(in);直接这么写,如果properties文件中有汉字,则汉字会乱码。因为未设置编码格式 pro.load(new InputStreamReader(fis, "utf-8")); Set<Object> set = pro.keySet(); paths = new String[pro.size()]; int count = 0; for (Object object : set) { paths[count]=pro.getProperty((String)object); count++; } } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }
2.解决poi自适应宽度
sheet.autoSizeColumn(列所在的下标); (版本不能太老) sheet.autoSizeColumn(列所在的下标, true);(合并的单元格使用) sheet.setColumnWidth(列所在的下标, “列名”.getBytes().length*2*256);(中文适用)