Apache POI : Copy data to Particular sheet at particular cell with Merged Columns in Source Sheet

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Apache POI : Copy data to Particular sheet at particular cell with Merged Columns in Source Sheet

shagunbhatt94@gmail.com
Problem

How to add some part of data from source excel sheet to the destination excel sheet using Apache POI(XSSF Format)?Excel sheet contains merged columns.

Requirement:

Requirement is not only to copy the row but also to put the data into desired Excel cell(desired column) of the destination sheet.
Note

-Copying row to desired row location in destination excel sheet is achievable. Problem is to first merge the cell as per source sheet in destination sheet and then put data into desired merged excel cell. - Merged Columns could vary in a row

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Apache POI : Copy data to Particular sheet at particular cell with Merged Columns in Source Sheet

Mark Murphy
What have you tried, what did you expect, and what happens? (Show Code and
sample data please)

On Tue, Nov 21, 2017 at 12:05 AM, [hidden email] <
[hidden email]> wrote:

> Problem
>
> How to add some part of data from source excel sheet to the destination
> excel sheet using Apache POI(XSSF Format)?Excel sheet contains merged
> columns.
>
> Requirement:
>
> Requirement is not only to copy the row but also to put the data into
> desired Excel cell(desired column) of the destination sheet.
> Note
>
> -Copying row to desired row location in destination excel sheet is
> achievable. Problem is to first merge the cell as per source sheet in
> destination sheet and then put data into desired merged excel cell. -
> Merged Columns could vary in a row
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>