That is right. This is why I shift all the rows in the sheet with higher number than the actual row as you can see. Of course this may be not optimal but at the moment I do not know of a better way. If you can come up with a better solution I will be glad to incorporate this in my code.
bye Bodo > Shift rows is not same as insert rows i think. > When you shift a row, the contents of the row where the > current row is > shifted to are overwritten. > Content-Type: multipart/alternative; > boundary="----=_NextPart_001_0008_01C3BE3A.265FD0A0" > > > ------=_NextPart_001_0008_01C3BE3A.265FD0A0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > How about this one? > > sheet.shiftRows(actualRowNumber, sheet.getLastRowNum(), 1); > > row =3D sheet.createRow(actualRowNumber); > > bye Bodo > > -----Urspr=FCngliche Nachricht----- > Von: iansdev [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 9. Dezember 2003 03:03 > An: [EMAIL PROTECTED] > Betreff: Insert Between rows.. > > > > Hi! All... > =20 > Is there a way to insert a row between two row using poi? > =20 > <?xml:namespace prefix =3D o ns =3D > "urn:schemas-microsoft-com:office:office" />Caezar Ian Santilla > > Web Developer > > 6/F Alpap I Bldg., 140 L.P. Leviste St. > > Salcedo Village, Makati City > > Manila, Philippines > > Tel: +63 (0) 2 751 7010 - ext 112 > > Fax: +63 (0) 2 751 7013 > > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>=20 > > =09 > ____________________________________________________ > <http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9> = > IncrediMail - > Email has finally evolved - > <http://www.incredimail.com/redir.asp?ad_id=3D309&lang=3D9> Click Here > > > ------=_NextPart_001_0008_01C3BE3A.265FD0A0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Diso-8859-1"> > > > <META content=3D"MSHTML 5.00.3810.1700" = > name=3DGENERATOR><!--IncrdiXMLRemarkStart> > <IncrdiX-Info> > <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> > <X-FVER>3.0</X-FVER> > <X-CNT>;</X-CNT> > </IncrdiX-Info> > <IncrdiXMLRemarkEnd--></HEAD> > <BODY background=3D"" bgColor=3D#ffffff scroll=3Dyes=20 > style=3D"BACKGROUND-POSITION: 0px 0px; FONT-FAMILY: Arial; > FONT-SIZE: = > 12pt; MARGIN: 5px 10px 10px"=20 > X-FVER=3D"3.0" ORGYPOS=3D"0"> > <DIV><FONT size=3D2> > <P><FONT size=3D3><SPAN class=3D731445108-09122003>How about this=20 > one?</SPAN></FONT></P> > <P>sheet.shiftRows(actualRowNumber, sheet.getLastRowNum(), 1);</P> > <P>row =3D sheet.createRow(actualRowNumber);</P> > <P><SPAN class=3D731445108-09122003>bye Bodo</SPAN></P></FONT></DIV> > <BLOCKQUOTE=20 > style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; > PADDING-LEFT: = > 5px"> > <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = > face=3DTahoma=20 > size=3D2>-----Urspr=FCngliche Nachricht-----<BR><B>Von:</B> > iansdev=20 > [mailto:[EMAIL PROTECTED]<BR><B>Gesendet:</B> Dienstag, 9. > Dezember 2003=20 > 03:03<BR><B>An:</B> [EMAIL PROTECTED]<BR><B>Betreff:</B> = > Insert=20 > Between rows..<BR><BR></DIV></FONT> > <TABLE border=3D0 cellPadding=3D2 cellSpacing=3D0 = > id=3DINCREDIMAINTABLE=20 > width=3D"100%"><TBODY> > <TR> > <TD id=3DINCREDITEXTREGION=20 > style=3D"CURSOR: auto; FONT-FAMILY: Arial; FONT-SIZE: 12pt" = > width=3D"100%"> > <DIV> Hi! All...</DIV> > <DIV> </DIV> > <DIV>Is there a way to insert a row between two row using = > poi?</DIV> > <DIV> </DIV> > <DIV> > <DIV><FONT color=3D#004080 face=3DCourier size=3D1> > <DIV><FONT color=3D#c0c0c0 size=3D1> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT=20 > face=3D"Times New Roman"><SPAN=20 > style=3D"COLOR: black; FONT-SIZE: 10pt"></SPAN><SPAN=20 > style=3D"COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; = > mso-bidi-font-size: 12.0pt"><?xml:namespace=20 > prefix =3D o ns =3D > "urn:schemas-microsoft-com:office:office"=20 > /><o:p><STRONG>Caezar Ian = > Santilla</STRONG></o:p></SPAN></FONT></P> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT=20 > face=3D"Times New Roman"><SPAN=20 > style=3D"COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; = > mso-bidi-font-size: 12.0pt"><o:p>Web=20 > Developer</o:p></SPAN></FONT></P> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT=20 > face=3D"Times New Roman"><SPAN=20 > style=3D"COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; = > mso-bidi-font-size: 12.0pt"><o:p></o:p></SPAN></FONT><SPAN=20 > style=3D"COLOR: black; FONT-SIZE: 10pt"><FONT > face=3D"Times New = > Roman">6/F=20 > Alpap I Bldg., 140 L.P. Leviste > St.<o:p></o:p></FONT></SPAN></P> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 > style=3D"COLOR: black; FONT-SIZE: 10pt"><FONT=20 > face=3D"Times New Roman">Salcedo Village, Makati=20 > City<o:p></o:p></FONT></SPAN></P> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT=20 > face=3D"Times New Roman"><SPAN=20 > style=3D"COLOR: black; FONT-SIZE: 10pt">Manila, = > Philippines</SPAN><SPAN=20 > style=3D"COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: = > 10pt"><o:p></o:p></SPAN></FONT></P> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT=20 > face=3D"Times New Roman"><SPAN=20 > style=3D"COLOR: black; FONT-SIZE: 10pt">Tel: > +63 (0) 2 751 = > 7010 -=20 > ext 112</SPAN></FONT></P> > <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><SPAN=20 > style=3D"COLOR: black; FONT-SIZE: 10pt"><FONT > face=3D"Times New = > Roman">Fax:=20 > +63 (0) 2 751 7013<o:p></o:p></FONT></SPAN></P><SPAN=20 > style=3D"COLOR: black; FONT-FAMILY: 'Times New Roman'; = > FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; = > mso-ansi-language: EN-US; mso-fareast-language: EN-US; = > mso-bidi-language: AR-SA">Email:=20 > <A=20 > = > href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A></SPAN></FONT>< > /DIV></FONT= > ></DIV></DIV></TD></TR> > <TR> > <TD id=3DINCREDIFOOTER width=3D"100%"> > <TABLE cellPadding=3D0 cellSpacing=3D0 width=3D"100%"> > <TBODY> > <TR> > <TD width=3D"100%"></TD> > <TD align=3Dmiddle id=3DINCREDISOUND vAlign=3Dbottom></TD> > <TD align=3Dmiddle id=3DINCREDIANIM=20 > = > vAlign=3Dbottom></TD></TR></TBODY></TABLE></TD></TR></TBODY></ > TABLE><SPAN= > =20 > id=3DIncrediStamp><SPAN dir=3Dltr><FONT face=3D"Arial, Helvetica, = > sans-serif"=20 > > size=3D2>____________________________________________________< > BR><FONT = > > face=3D"Comic Sans MS" size=3D2><A=20 > = > href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&l > ang=3D9"><I= > MG=20 > align=3Dbaseline alt=3D"" border=3D0 hspace=3D0=20 > src=3D"cid:B7235289-5829-4E85-8213-B4A8AE7DBEF9";></A> = > <I>IncrediMail</I> -=20 > <B>Email has finally evolved</B> - </FONT><A=20 > = > href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&l > ang=3D9"><F= > ONT=20 > face=3D"Times New Roman" size=3D3><B><U>Click=20 > = > Here</U></B></FONT></A></SPAN></SPAN></FONT></BLOCKQUOTE></BOD > Y></HTML> > > ------=_NextPart_001_0008_01C3BE3A.265FD0A0-- > >
smime.p7s
Description: S/MIME cryptographic signature
