Writing to the same Excel file but differnt sheets via tMap

RVeitch_84 — Fri, 15 Nov 2024 23:49:23 GMT

I'm having an issue trying to do a simple query and send the output to the same excel file but in two different sheets.

Iv'e tried it two differnt options with the same result, an error?

Option1

Option2

Exception in component tFileOutputExcel_15 (Canvas_Summary_v2)

jxl.read.biff.BiffException: The input file was not found

at jxl.read.biff.File.<init>(File.java:124)

at jxl.Workbook.getWorkbook(Workbook.java:221)

at remote_jobs.canvas_summary_v2_2_0.Canvas_Summary_v2.tDBInput_3Process(Canvas_Summary_v2.java:3451)

at remote_jobs.canvas_summary_v2_2_0.Canvas_Summary_v2.runJobInTOS(Canvas_Summary_v2.java:6043)

at remote_jobs.canvas_summary_v2_2_0.Canvas_Summary_v2.main(Canvas_Summary_v2.java:5761)

[FATAL] 16:19:26 remote_jobs.canvas_summary_v2_2_0.Canvas_Summary_v2- tFileOutputExcel_15 The input file was not found

Any help would be appreciated.

Re: Writing to the same Excel file but differnt sheets via tMap

Anonymous — Mon, 23 Aug 2021 04:08:24 GMT

Cache the second output into memory, read the data back from memory and append it the same file (different sheet) in next subjob, this way avoid the error that the same file is open by another process.

....tMap---out1--tFileOutputExcel

--out2--tHashOutput

|onsubjobok

tHashInput--main--tFileOutputExcel(append to existing file, another sheet name)

Regards

Shong

topic Writing to the same Excel file but differnt sheets via tMap in Talend Studio

Writing to the same Excel file but differnt sheets via tMap

Re: Writing to the same Excel file but differnt sheets via tMap