java如何读取excel文件

package com.srk.usual; import java.io.ByteArrayOutputStream; import java.io.InputStream; import java.io.DataOutputStream; import java.io.IOException; import java.io.FileOutputStream; import java.io.OutputStream; import java.io.FileInputStream; public class DTLanguage { public static void main(String[] args) { DTLanguage u = new DTLanguage(); u.readFile(); } private void readFile() { InputStream is = null; try { is = new FileInputStream("D:/workspace/text/dd.txt"); if (is == null) { return; } this.parseRescourse(is); } catch (Exception e) { //#debug error System.out.println(e.getMessage()); } finally { try { if (is != null) { is.close(); } } catch (IOException ex1) { } } } private void parseRescourse(InputStream is) { if (is == null) { return; } OutputStream os = null; DataOutputStream dos = null; ByteArrayOutputStream baos = null; try { os = new FileOutputStream( "D:/workspace/mini-V4.0.1-e/ant/image/public/language.dat"); dos = new DataOutputStream(os); baos = new ByteArrayOutputStream(); int ch = 0; while ((ch = is.read()) != -1) { baos.write(ch); } byte[] data = baos.toByteArray(); String languageText = new String(data, "UTF-8"); System.out.println("TEXT length = " + languageText.length()); String tempText = null; int poundCount = 0; int contentStartIndex = 0; int contentEndIndex = 0; char lastChar = '\n'; int lineType = 0; for (int i = 0; i < languageText.length(); i++) { char currentChar = languageText.charAt(i); if (lastChar == '\n' && currentChar != '#') { i = languageText.indexOf('\n', i); continue; } if (currentChar == '#') { if (lastChar == '\n' || lastChar == '#') { poundCount++; lineType = poundCount; } } else if (currentChar == '\n' || i == languageText.length() - 1) { contentEndIndex = i; if (i > 0 && languageText.charAt(i - 1) == '\r') { contentEndIndex--; } } else { if (lastChar == '#' && poundCount != 0) { poundCount = 0; contentStartIndex = i; } } lastChar = currentChar; if (contentEndIndex == 0) { continue; } else if (contentEndIndex == languageText.length() - 1) { tempText = languageText.substring(contentStartIndex); } else { tempText = languageText.substring(contentStartIndex, contentEndIndex); } System.out.println("type = " + lineType); System.out.println("text = " + tempText); switch (lineType) { case 3: { if (tempText != null && tempText.startsWith("Language:")) { String value = tempText.substring(9); if (value != null && value.length() != 0) { dos.writeInt(3); dos.writeUTF("Language"); dos.writeUTF(value); } } else if (tempText != null && tempText.startsWith("Version:")) { String value = tempText.substring(8); if (value != null && value.length() != 0) { dos.writeInt(3); dos.writeUTF("Version"); dos.writeUTF(value); } } break; } case 2: { if (tempText != null && tempText.length() != 0) { dos.writeInt(2); dos.writeUTF(tempText); dos.writeUTF(""); } break; } case 1: { int poundIndex = tempText.indexOf('#'); String id = tempText.substring(0, poundIndex); String value = tempText.substring(poundIndex + 1); value = this.replace(value, "\\n", "\n"); if (id != null && id.length() != 0 && value != null && value.length() != 0) { dos.writeInt(1); dos.writeUTF(id); dos.writeUTF(value); } break; } default: {} } contentEndIndex = 0; contentStartIndex = 0; poundCount = 0; lineType = 0; } } catch (Exception e) { System.out.println(e); } finally { if (is != null) { try { is.close(); } catch (IOException ex) { } is = null; } if (os != null) { try { os.close(); } catch (IOException ex1) { } os = null; } } } public static String replace(String input, String search, String replacement) { int pos = input.indexOf(search); if (pos != -1) { StringBuffer buffer = new StringBuffer(); int lastPos = 0; do { buffer.append(input.substring(lastPos, pos)) .append(replacement); lastPos = pos + search.length(); pos = input.indexOf(search, lastPos); } while (pos != -1); buffer.append(input.substring(lastPos)); input = buffer.toString(); } return input; } }