topic Copy and paste one excel sheet into another in Talend Studio

Copy and paste one excel sheet into another

Anonymous — Sat, 16 Nov 2024 11:20:48 GMT

Hi All,
I am trying to take one excel worksheet in one workbook and paste the entire thing into the other workbook and replace that sheet. When I try to use the below it doesn't paste anything. Can you please see below and tell me what I am missing or doing wrong? I am using tfileinput and tfileoutput I appreciate all the help.

Re: Copy and paste one excel sheet into another

Anonymous — Sun, 18 Jan 2015 00:48:49 GMT

I do not know what do you mean with paste but transferring data from one sheet to another sheet (also in another workbook) is not a big deal. I would do that with the components like tFileExcel* from Talend Exchange.
You need 2 tFileExcelWorkbookOpen for every workbook (source and target) and read from source with tFileExcelSheetInput and write with tFileExcelSheetOutput in the other workbook.
At least write the workbook with tFileExcelWorkbookSave to you local file system.
Go to Talend Exchange view in your studio and install all 4 mentioned components in the Exchange view of your studio.

Re: Copy and paste one excel sheet into another

Anonymous — Sun, 18 Jan 2015 19:33:24 GMT

Hi,
Thank you for your help.
I tried to do what you said (see screenshots below), but all it did was recreate the target workbook and save it as a new copy. Basically I was hoping to do the following.
1. Copy sheet from source workbook
2. Paste and replace the data in the target workbook for a specific sheet.

Re: Copy and paste one excel sheet into another

Anonymous — Mon, 19 Jan 2015 10:18:46 GMT

I cannot see any screenshots from you. Here is how I thought it

The tFileExcelSheetInput belongs to tFileExcelWorkbookOpen_1 and the tFileExcelSheetOutput and tFileExcelWorkbookSave belongs to tFileExcelWorkbookOpen_2.
In tFileExcelWorkbookOpen_2 you have to open your target file.

Re: Copy and paste one excel sheet into another

Anonymous — Mon, 19 Jan 2015 15:55:35 GMT

Thank you, Thank you! It almost worked.. how do i get it to paste values.. and not the formulas from the other excel sheet?

Re: Copy and paste one excel sheet into another

Anonymous — Mon, 19 Jan 2015 15:57:20 GMT

If you read a cell with a numeric datatype like Double or BigDecimal the formula should be calculated and only the value should be transferred.

Re: Copy and paste one excel sheet into another

Anonymous — Tue, 20 Jan 2015 02:47:21 GMT

Hi Jbolling,
Can you show me to how to extra emails from my email and save to my email address. I can't extract emails that come directly to me.. only those that come from a group. I tried using tpop and tfileinputmail but wasn't sure what to do with the schema. Can you please provide an example that you have done with screenshots of the parameters for each dimension (tpop and t fileinputmail)

Re: Copy and paste one excel sheet into another

Anonymous — Tue, 20 Jan 2015 02:49:06 GMT

Sorry it sounded confusing on the top. I want to save an email attachment to a specific location on my hard drive. I have been able to do it, but only for emails that come to an alias I belong to, and not those emails with attachments that come directly to me.

Re: Copy and paste one excel sheet into another

Anonymous — Tue, 20 Jan 2015 03:18:06 GMT

Here are some screenshots. I believe it finds the file but no screenshots

Re: Copy and paste one excel sheet into another

Anonymous — Tue, 20 Jan 2015 03:22:17 GMT

Also if you can't see my screenshots.. is there another way I can show you? I pasted them into this chat, but for some reason when I click submit they never show up.

Re: Copy and paste one excel sheet into another

Anonymous — Tue, 20 Jan 2015 07:20:34 GMT

I know, I save screenshots as png file and drag them directly into the post editor window. Try this way.