Hi mark,
thanks for the reply.
Below is the code for reading i have used.
FileInputStream myInput = new
FileInputStream("C:\\Testingforlargexlsx\\sxxf\\temp.xlsx");
XSSFWorkbook arbitory_ss = new XSSFWorkbook(myInput);
SXSSFWorkbook wb_ss = new
SXSSFWorkbook(arbitory_ss,-1);
SXSSFSheet sheet = null;
sheet = (SXSSFSheet) wb_ss.getSheet("sheet1");
System.err.println(" LOG sheet Merged Regions
"+sheet.getNumMergedRegions());
SXSSFRow row1 = (SXSSFRow) sheet.getRow(1);
System.out.println("SXSSFRow
"+ sheet.getFirstRowNum());
System.out.println("SXSSFRow
"+ row1);
Row row12 = (SXSSFRow)
sheet.getRow(0);
System.out.println("Row "+
sheet.getFirstRowNum());
System.out.println("Row "+
row1);
I have run this above mentioned code to get the 1st row in two ways SXSSFRow
and Row but for both the values its showing null.
Is there any separate api for reading rows????
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/SXSSF-for-Writing-huge-data-on-exisitng-excel-tp5712656p5712669.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
