Hello All, I have a very basic question. I am trying to read large sets of data from excel and write to SQL server. Current i am able to iterate over the data and read the entire data. What i am not able to figure out is, how do i get a result set of every row so that i can reference cells. for example. i need to be able to say row1.getvalue(1), row1.getvalue(2) etc...
I need this so i can use them to perform inserts to sql server. Eg: insert into DB values (rs.getValue1, rs.getValue(3)...) Basically i need to be able to get handle to rows and be able to reference values on each row returned. Any help would be appreciated. Thanks! -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Basic-Question-Apache-POI-tp5712531.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
