Hi Mark, Thanks for the reply.
I am reading the data from db and writing the data on to spreadsheet using POI. I have attached a sample spreadsheet with this post. I have got 7 cells where the data has to be written. I first fill up cell 1 then cell2 and so on. Say for eg one cell one data was laid out for over 5 rows. When I start writing to cell 2 it starts writing from row 6 but i want it to start again from row 1 same with the rest. In the attached spreadsheet i have 2 worksheets wrong and right. wrong is what the pgm is doing at the moment and the right has the way data has to be laid out. Can you kindly http://www.nabble.com/file/p26012375/sample.xls sample.xls assist. Thanx a lot in advance. Thanks&Regards Jag MSB wrote: > > Sorry, but I am not competely clear what you are asking. > > Are you saying that you have a worksheet and use POI to open it, access a > number of cells on the sheet that could each be on a different row, change > the value in each of those cells and then re-position each onto row 3 of > the worksheet? > > Yours > > Mark B > > > njr30 wrote: >> >> Hi, >> >> I am writing some data to Excel using POI where I have to reset the row >> number to 3 as I complete inserting values in different cells. >> >> How do I do that ? >> >> Thanks, >> njr30 >> > > -- View this message in context: http://www.nabble.com/Setting-the-row-number-to-3-while-inserting-values-in-different-cells-%21%21-tp26003733p26012375.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]
