Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id F04E0200D43 for ; Tue, 21 Nov 2017 10:10:14 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id ED67D160BFC; Tue, 21 Nov 2017 09:10:14 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 38300160BED for ; Tue, 21 Nov 2017 10:10:14 +0100 (CET) Received: (qmail 48404 invoked by uid 500); 21 Nov 2017 09:10:13 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Delivered-To: moderator for user@poi.apache.org Received: (qmail 39095 invoked by uid 99); 21 Nov 2017 05:06:03 -0000 X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 4.427 X-Spam-Level: **** X-Spam-Status: No, score=4.427 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, FREEMAIL_ENVFROM_END_DIGIT=0.25, FROM_MISSPACED=0.001, FROM_MISSP_EH_MATCH=1.803, KB_WAM_FROM_NAME_SINGLEWORD=0.2, NML_ADSP_CUSTOM_MED=1.2, SPF_SOFTFAIL=0.972] autolearn=disabled MIME-Version: 1.0 Message-ID: Subject: Apache POI : Copy data to Particular sheet at particular cell with Merged Columns in Source Sheet References: From: "shagunbhatt94@gmail.com" In-Reply-To: Content-Type: text/plain; charset="iso-8859-1" x-ponymail-sender: 07ea88e62b4fd1abb3511047a7db68a1e085f29d Date: Tue, 21 Nov 2017 05:05:59 -0000 x-ponymail-agent: PonyMail Composer/0.2 To: X-Mailer: LuaSocket 3.0-rc1 archived-at: Tue, 21 Nov 2017 09:10:15 -0000 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: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org