You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Kazuaki Miyauchi <mi...@gmail.com> on 2015/01/09 04:28:54 UTC

insert row function

Hi, now we cannot insert row in Excel File using POI?

Regards,                          K.Miyauchi

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: insert row function

Posted by Kazuaki Miyauchi <mi...@gmail.com>.
2015-01-19 4:33 GMT+09:00 Dominik Stadler <do...@gmx.at>:
> you can probably use Sheet.shiftRows(int startRow, int endRow, int n)
> to shift the rows down starting at the point of insertion and then
> create a new row at the index that is then unpopulated.

 Thank you very much. I'll try to use that function.

Best Regards,

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: insert row function

Posted by Dominik Stadler <do...@gmx.at>.
Hi,

you can probably use Sheet.shiftRows(int startRow, int endRow, int n)
to shift the rows down starting at the point of insertion and then
create a new row at the index that is then unpopulated.

Dominik.

On Tue, Jan 13, 2015 at 4:43 AM, Kazuaki Miyauchi <mi...@gmail.com> wrote:
> Sorry, my question is "are there any function of inserting row in Excel File
> in POI?". I'd like to insert row into Excel File using POI.
>
> 2015-01-09 18:32 GMT+09:00 Dominik Stadler <do...@gmx.at>:
>> This is not a very useful question as you do not state at all what
>> actually fails and how it fails. You will increase your chances of
>> getting some answers if you add more information about your problem,
>> e.g. sample code, actual error message, what you already tried, if it
>> worked in a previous version, ...
>>
>> Thanks... Dominik.
>>
>> On Fri, Jan 9, 2015 at 4:28 AM, Kazuaki Miyauchi <mi...@gmail.com> wrote:
>>> Hi, now we cannot insert row in Excel File using POI?
>>>
>>> Regards,                          K.Miyauchi
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: insert row function

Posted by Kazuaki Miyauchi <mi...@gmail.com>.
Sorry, my question is "are there any function of inserting row in Excel File
in POI?". I'd like to insert row into Excel File using POI.

2015-01-09 18:32 GMT+09:00 Dominik Stadler <do...@gmx.at>:
> This is not a very useful question as you do not state at all what
> actually fails and how it fails. You will increase your chances of
> getting some answers if you add more information about your problem,
> e.g. sample code, actual error message, what you already tried, if it
> worked in a previous version, ...
>
> Thanks... Dominik.
>
> On Fri, Jan 9, 2015 at 4:28 AM, Kazuaki Miyauchi <mi...@gmail.com> wrote:
>> Hi, now we cannot insert row in Excel File using POI?
>>
>> Regards,                          K.Miyauchi

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: insert row function

Posted by Dominik Stadler <do...@gmx.at>.
This is not a very useful question as you do not state at all what
actually fails and how it fails. You will increase your chances of
getting some answers if you add more information about your problem,
e.g. sample code, actual error message, what you already tried, if it
worked in a previous version, ...

Thanks... Dominik.

On Fri, Jan 9, 2015 at 4:28 AM, Kazuaki Miyauchi <mi...@gmail.com> wrote:
> Hi, now we cannot insert row in Excel File using POI?
>
> Regards,                          K.Miyauchi
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org