sivio Posted December 14, 2011 Report Share Posted December 14, 2011 Fiz essa classe que ler todos os valores do excel.Como fazer para pegar só o valor da celula A1??import java.io.IOException;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import org.junit.Test;public class TesteLerExcel { @Test public void ler() throws IOException{ Workbook wb =new XSSFWorkbook(getClass().getResourceAsStream("Notas_OOI.xlsx")); Sheet sheet = wb.getSheetAt(0); for (Row row : sheet) { for (Cell cell : row) { System.out.print(cell.toString()); System.out.print("\t"); } System.out.println(); } }} Quote Link to comment Share on other sites More sharing options...
Question
sivio
Fiz essa classe que ler todos os valores do excel.Como fazer para pegar só o valor da celula A1??
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;
public class TesteLerExcel {
@Test
public void ler() throws IOException{
Workbook wb =new XSSFWorkbook(getClass().getResourceAsStream("Notas_OOI.xlsx"));
Sheet sheet = wb.getSheetAt(0);
for (Row row : sheet) {
for (Cell cell : row) {
System.out.print(cell.toString());
System.out.print("\t");
}
System.out.println();
}
}
}
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.