Question

Fanout Excel Sheet and keep formatting

franco69
Rank
Badge +6

Hi guys,

i have different excel files which i have to split in separate excel files (fanout with row C), name them as Row C input (PA9-BK.....) and keep the formatting...first two columns (the grey ones should stay in all files) and the rest (green colours and so on) should also keep in the new files. how is the plan for that? i have searched some articles but not found the right one.....sry

 

cheers, thxscreenshot and greetz FRanco

3 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @franco69​ 

 

Please, could you share your data?

 

 

Thanks in Advance

franco69
Rank
Badge +6

Hi @franco69​ 

 

Please, could you share your data?

 

 

Thanks in Advance

Hi Danilo,

i have solved it for myself...thx....to take the cell colors from the reader to the writer i have read that there is no solution at the moment.

Cheers

Franco

pkno
Rank
Badge +1

Hi Danilo,

i have solved it for myself...thx....to take the cell colors from the reader to the writer i have read that there is no solution at the moment.

Cheers

Franco

I know its been a while but could you elaborate how you solved this? I am having the same problem right now. Thanks

Reply


Community Stats

28,731
Posts
109,528
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.