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.
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.
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.
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.
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)
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.