Hi Nick, Thanks for solution. I read the data from excel file and convert it to List(it represent Sheet of excel file) of List(it represent one row). My business logic assume that all the List(represent Rows) would have same number of elements.
I have a Sheet in excel which contain no of rows and each row have different number of column. I read the data from file successfully and convert it to List(represent rows) but some list have two elements and some have three due to which ArrayIndexOutOfBound exception thrown by business logic. So I need that appache poi read the data from excel file and return same number of cells for each row. Please suggest. Is there Any Way? I have checked out all the methods provided by HSSFWorkbook, but unfortunatly it is not helpful for me. Thanks In Advance. Nick Burch-11 wrote: > > On Wed, 17 Mar 2010, Tyagi wrote: >> Is there any way through which I get 5 cells for each row ? > > http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setMissingCellPolicy(org.apache.poi.ss.usermodel.Row.MissingCellPolicy) > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/Read-data-from-excel-file-in-matrix.-tp27929789p27949111.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]
