java格式转化异常,java.text.ParseException：无法解析的日期：“ 42321”(这是关于将日期从excel格式转换为java格式，而不是有关DateFormat.parse。...-CSDN博客

processOneSheet("C:/Users/Penchalaiah/Desktop/New folder/"+hs.getAttribute("filename1"));

System.out.println(hs.getAttribute("filename1"));

System.out.println("clossing the connnection");

ps.close();

con1.close();

System.out.println("execution completed");

//request.setAttribute("message","THE XLSX DATA TRANSFERRED SUCCEFULLY");

// request.getRequestDispatcher("/HomePage.jsp").forward(request, response);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

/*try {

ps.close();

con1.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}*/

}

public void processOneSheet(String filename) throws Exception {

System.out.println("executing Process Method");

OPCPackage pkg = OPCPackage.open(filename);

XSSFReader r = new XSSFReader( pkg );

SharedStringsTable sst = r.getSharedStringsTable();

XMLReader parser = fetchSheetParser(sst);

// To look up the Sheet Name / Sheet Order / rID,

// you need to process the core Workbook stream.

// Normally it's of the form rId# or rSheet#

InputStream sheet2 = r.getSheet("rId2");

System.out.println("Sheet2");

InputSource sheetSource = new InputSource(sheet2);

parser.parse(sheetSource);

sheet2.close();

}

public XMLReader fetchSheetParser(SharedStringsTable sst) throws SAXException {

XMLReader parser = XMLReaderFactory.createXMLReader("org.apache.xerces.parsers.SAXParser");

ContentHandler handler = new SheetHandler(sst);

parser.setContentHandler(handler);

return parser;

}

/**

* See org.xml.sax.helpers.DefaultHandler javadocs

private class SheetHandler extends DefaultHandler {

private SharedStringsTable sst;

private String lastContents;

private boolean nextIsString;

String TxnNo;

String SurveyId;

Date date;

String Time;

String Lane;

String Avspeed;

String Direction;

String VehicleCategory;

String Axle_count;

String Vehicle;

int i = 1;

private SheetHandler(SharedStringsTable sst) {

this.sst = sst;

}

public void startElement(String uri, String localName, String name,

Attributes attributes) throws SAXException {

// c => cell

if(name.equals("c")) {

// Print the cell reference

//System.out.print(attributes.getValue("r") +" -");

// Figure out if the value is an index in the SST

String cellType = attributes.getValue("t");

if(cellType != null && cellType.equals("s")) {

nextIsString = true;

} else {

nextIsString = false;

}

// Clear contents cache

lastContents ="";

}

public void endElement(String uri, String localName, String name)

throws SAXException {

// Process the last contents as required.

// Do now, as characters() may be called more than once

if(nextIsString) {

int idx = Integer.parseInt(lastContents);

lastContents = new XSSFRichTextString(sst.getEntryAt(idx)).toString();

nextIsString = false;

}

// v => contents of a cell

// Output after we've seen the string contents

if(name.equals("v")) {

if(i == 1){

TxnNo = lastContents;

}

if(i == 2){

SurveyId = lastContents;

}

if(i == 3){

try {

//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

date = new SimpleDateFormat("dd/MM/yyyy",Locale.ENGLISH).parse(lastContents);

//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

System.out.println("The Date is:"+date);

} catch (ParseException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}