topic insert data into merged cell of excel file in Talend Studio

insert data into merged cell of excel file

Anonymous — Tue, 25 Sep 2018 16:19:24 GMT

Hi All,

I am trying to insert data into a excel file which have some merged cells.

Scenario:

data present in file :

Testing Orders		Testing2 Orders
Date	Orders received	Orders sent to WTX	Orders sent to PDP	Comments	Orders sent to PDP	Orders sent to PDP	Comments
Waiting for PDP response	PDP response received	Waiting for PDP response	PDP response received
02/09/2028(records found on 3rd September 03.57 PM IST))	347	347	753	47		2352	2	2350
02/09/2028(records found on 3rd September 03.57 PM IST))	408	407	232	753		75	25	750
03/09/2028(records found on 4th September 03.24 PM IST))	235	235	247	228		294	29	293

data I am trying to insert/append :

24/09/2018(records found on 24th September 05:45 AM IST)) 1714 1617 409 1208 3770 22 2264

--------------------

when ever I am trying to do so , data inserted looks like this:

Testing Orders		Testing2 Orders
Date	Orders received	Orders sent to WTX	Orders sent to PDP	Comments	Orders sent to PDP	Orders sent to PDP	Comments
Waiting for PDP response	PDP response received	Waiting for PDP response	PDP response received
02/09/2028(records found on 3rd September 03.57 PM IST))	347	347	753	47		2352	2	2350
02/09/2028(records found on 3rd September 03.57 PM IST))	408	407	232	753		75	25	750
03/09/2028(records found on 4th September 03.24 PM IST))	235	235	247	228		294	29	293
24/09/2018(records found on 24th September 05:45 AM IST))	1714	409	1208		3370	22	2264

please check the snap shots of the file and talend job in attachments

Re: insert data into merged cell of excel file

manodwhb — Thu, 27 Sep 2018 06:27:55 GMT

@amit_dev_d9,it could be the space issue that i see in the bleow value there is more space between 1280 and 3770,when compared with other spaces.

data I am trying to insert/append :

24/09/2018(records found on 24th September 05:45 AM IST)) 1714 1617 409 1208 3770 22 2264

Re: insert data into merged cell of excel file

Anonymous — Thu, 27 Sep 2018 09:05:23 GMT

Hi Manodwhb,

Thanks for pointing out cell "B". I realized the same yesterday after posting my problem. So I added null column and tried that again . It didn't work .

Here is my workaround until I find a proper solution.

Note : I have ticked the below options :

1) Append existing file

2) Append existing sheet

3) Is absolute Y pos

in "first cell X" value is changing

toracleinput --> thashoutput

thashinput --> tMap -->tFileOutputEcel (map data for first six columns including b as null and 6th column will be merged cell) "first cell X"= 0

thashinput --> tMap -->tFileOutputEcel (this is mapped with 7th 8th and 9th cell , actually I left 7th cell as I am supposed to leave it blank) "first cell X"= 2

thashinput --> tMap -->tFileOutputEcel (10 th column is mapped that is again a merged cell) "first cell X"= 0