Writing to the same Excel file but differnt sheets via tMap

[RVeitch_84]

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.

[Anonymous · Accepted solution]

Hi

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