I know how to upload a file:
<html>
<head>
<title>File Uploading Form</title>
</head>
<body>
<form action="UploadServlet" method="post"
enctype="multipart/form-data">
File :<input type="file" name="file" size="50" />
<input type="submit" value="Upload File"/>
</form>
</body>
</html>
This is the class for reading the file:
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
public class BufferedReaderExample {
public static void main(String[] args) {
try (BufferedReader br = new BufferedReader(new FileReader("C:\\testing.txt")))
{
String sCurrentLine;
while ((sCurrentLine = br.readLine()) != null) {
System.out.println(sCurrentLine);
}
} catch (IOException e) {
e.printStackTrace();
}
}
}
Now how do you link both these together. The user uploads the file onto the server and the server processes it. i.e., it accepts the file and prints it contents. Can I use struts framework for this? I want to upload excel sheet and print the contents to the jsp page. I have the code for reading the excel sheet in java using apache poi. But the path to read the excel file is hard coded. how do you take it from the uploaded file?
This is the file for reading excel sheet:
public class ReadExcelDemo
{
public static void main(String[] args)
{
try
{
FileInputStream file = new FileInputStream(new File("howtodoinjava_demo.xlsx"));
//Create Workbook instance holding reference to .xlsx file
XSSFWorkbook workbook = new XSSFWorkbook(file);
//Get first/desired sheet from the workbook
XSSFSheet sheet = workbook.getSheetAt(0);
//Iterate through each rows one by one
Iterator<Row> rowIterator = sheet.iterator();
while (rowIterator.hasNext())
{
Row row = rowIterator.next();
//For each row, iterate through all the columns
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext())
{
Cell cell = cellIterator.next();
//Check the cell type and format accordingly
switch (cell.getCellType())
{
case Cell.CELL_TYPE_NUMERIC:
System.out.print(cell.getNumericCellValue() + "t");
break;
case Cell.CELL_TYPE_STRING:
System.out.print(cell.getStringCellValue() + "t");
break;
}
}
System.out.println("");
}
file.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
Output:
ID NAME LASTNAME
1.0 Amit Shukla
2.0 Lokesh Gupta
3.0 John Adwards
4.0 Brian Schultz
But how do you stitch the uploaded and the servlet file together. How do you read the uploaded file?
You can achieve it by breaking whole process in two steps
1) Upload file
2) After upload pass file location to the method which read file data using apche poi. Use
File uploadedFile = new File(filePath);
object to get file location.Like many operations in Java, reading a file upload is unneccessarily complex, and difficult to work out from the javadocs. You are already planning to use Apache libraries to read your uploaded file, so I recommend using apache.commons.fileupload to upload your file as well.
This code fragment uploads a CSV file into a string:
I got it. The index file(html) is for uploading the file (as above in my qquestion) The java class for it is:
This is the class for reading the excel sheet using apache poi jars: