poi excel简单带注释.doc

1. package xls;2.3. import java.io.FileInputStream;4. import java.io.FileNotFoundException;5. import java.io.FileOutputStream;6. import java.io.IOException;7. import java.io.OutputStreamWriter;8. import java.io.UnsupportedEncodingException;9. import java.text.SimpleDateFormat;10. import java.util.ArrayList;11. import java.util.Date;12. import java.util.List;13.14. import org.apache.poi.hssf.usermodel.HSSFCell;15. import org.apache.poi.hssf.usermodel.HSSFRow;16. import org.apache.poi.hssf.usermodel.HSSFSheet;17. import org.apache.poi.hssf.usermodel.HSSFWorkbook;18.19. public class ReadXL20. 21. public static String fileName = C:xlsEXCEL.xls;22. public static String path = C:xls; /为方便,就这样写了.23. public static void main(String argv)24. 25. List list = readExcel();26. String xmldata = buildXML(list);27. createXMLFile(xmldata);28. 29.30. /* */*31. * 读取磁盘上的EXCEL文件的内容32. * return List33. */34. public static List readExcel()35. 36. List list = null;37. UserBean ub = null;38. try39. 40. HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(41. fileName); /得到excel对象42. HSSFSheet sheet = workbook.getSheetAt(0); /得到第一个sheet43. int rows = sheet.getPhysicalNumberOfRows(); /得到行数44. list = new ArrayList();45. for (int i = 1; i rows; i+)46. 47. HSSFRow row = sheet.getRow(i);48. ub = new UserBean();49. HSSFCell cell = row.getCell(short) 0); /得到列0(下标0,为第一列)50. ub.setName(cell.getStringCellValue();51. cell = row.getCell(short) 1); /得到列 152. ub.setEmail(cell.getStringCellValue();53. cell = row.getCell(short) 2); /得到列254. ub.setPhone(cell.getStringCellValue();55. cell = row.getCell(short) 3); /得到列356. ub.setPasswd(cell.getStringCellValue();57. list.add(ub);58. 59. return list;60. 61. catch (Exception e)62. 63. return null;64. 65. 66.67. /* */*68. * 组装xml格式字符串69. * param list List70. * return String71. */72. public static String buildXML(List list)73. 74. StringBuffer sb = new StringBuffer();75. sb.append(nt);76. sb.append(ntt);77. for (int i = 0; i list.size(); i+)78. 79. UserBean bean = (UserBean) list.get(i);80. sb.append(nttt);81. sb.append( + bean.getName() + nttt);82. sb.append( + bean.getEmail() + nttt);83. sb.append( + bean.getPhone() + nttt);84. sb.append( + bean.getPasswd() + ntt);85. if (i + 1 list.size()86. 87. sb.append(ntt);88. 89. else90. 91. sb.append(nt);92. 93. 94. sb.append(n);95. sb.append();96. return sb.toString();97. 98.99.100. /* */*101. * 输出到文件102. * param xmldata String103. */104. public static void createXMLFile(String xmldata)105. 106. String createTime = createTime();107. String filename = path + createTime + .xml;108. OutputStreamWriter osw = null;109. FileOutputStream output = null;110. try111. 112. output = new FileOutputStream(filename);113. osw = new OutputStreamWriter(output, utf-8);114. osw.write(xmldata);115. osw.flush();116. 117. catch (Exception ex)118. 119. 120. finally121. 122. try123. 124. if (null != output)125. 126. output.close();127. 128. 129. catch (IOException ex2)130. 131. 132. try133. 134. if (null != osw)135. 136. osw.close();137. 138. 139. catch (IOException ex3)140. 141. 142. 143. 144.145. /* */*146. * 用时间作为文件名147. * return String148. */149. public static String createTime()150. 151. Date dat