Re: AW: Insert Between rows..

Suma G Shanthappa Tue, 09 Dec 2003 03:11:45 -0800

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>&nbsp;Hi! All...</DIV>
        <DIV>&nbsp;</DIV>
        <DIV>Is there a way to insert a row between two row using =
poi?</DIV>
        <DIV>&nbsp;</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:&nbsp; +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&amp;lang=3D9";><I=
MG=20
  align=3Dbaseline alt=3D"" border=3D0 hspace=3D0=20
  src=3D"cid:B7235289-5829-4E85-8213-B4A8AE7DBEF9";></A>&nbsp; =
<I>IncrediMail</I> -=20
  <B>Email has finally evolved</B> - </FONT><A=20
  =
href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&amp;lang=3D9";><F=
ONT=20
  face=3D"Times New Roman" size=3D3><B><U>Click=20
  =
Here</U></B></FONT></A></SPAN></SPAN></FONT></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_0008_01C3BE3A.265FD0A0--

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: AW: Insert Between rows..

Reply via email to