How to read an Excel file, get and set the information using POI
- by user1399713
I'm using Java to read a form that is in an Excel spreadsheet that the user fills in with information about geometric shape. Ex:
Shape :_________
Color :_________
Area: _________
Perimeter:________
So far the code I have can I can read what I want in the form and print out the values of Shape, Color, Area, Perimeter.
public class RangeSetter {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
FileInputStream file = new FileInputStream(new File("test2.xls"));
//C:\Users\Yo\Documents
// Setup code
String cname = "Shape";
HSSFWorkbook wb = new HSSFWorkbook(file); // retrieve workbook
// Retrieve the named range
// Will be something like "$C$10,$D$12:$D$14";
int namedCellIdx = wb.getNameIndex(cname);
Name aNamedCell = wb.getNameAt(namedCellIdx);
// Retrieve the cell at the named range and test its contents
// Will get back one AreaReference for C10, and
// another for D12 to D14
AreaReference[] arefs = AreaReference.generateContiguous(aNamedCell.getRefersToFormula());
for (int i=0; i<arefs.length; i++) {
// Only get the corners of the Area
// (use arefs[i].getAllReferencedCells() to get all cells)
CellReference[] crefs = arefs[i].getAllReferencedCells();
for (int j=0; j<crefs.length; j++) {
// Check it turns into real stuff
Sheet s = wb.getSheet(crefs[j].getSheetName());
Row r = s.getRow(crefs[j].getRow());
Cell c = r.getCell(crefs[j].getCol());
if (c!= null ){
switch(c.getCellType()){
case Cell.CELL_TYPE_STRING:
System.out.println(c.getStringCellValue());
}
}
}
}
What I want to do is to create a method that gets the that information and another that sets it.
So far I can only print to the console
