Several sheets in one Excel file

pawe84 — Sat, 16 Nov 2024 01:42:53 GMT

Hi everyone.

I'm optimizing this following job which creates several sheets in one excel file in order to reduce components.

The current workflow is:

Sheet1: create headline -> query data -> append data to sheet1 then

Sheet2: create headline -> query data -> append data to sheet2 etc.

Now in step1 I wanted to use tReplicate in order to create the column headlines.

The problem now "Sheet1" will be overwritten although I set the "append data" option.

How to solve that problem?

Thanks for any hints.

Re: Several sheets in one Excel file

Anonymous — Mon, 10 Aug 2020 10:05:18 GMT

Cache the data in memory , read the data in next subjob and append it to existing file, this ensures the execution order of job. eg:

tPrejob--oncomponentok--tFixedFlowInput--main-tReplicate --tFileOutputExcel1

--tHashOutput

|onsubjobok

tHashInput--main--tFileOutputExcel2

Hope it helps you!

Regards

Shong