Skip to main content
Question

Fanout Excel Sheet and keep formatting

franco69
Contributor
Forum|alt.badge.img+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
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • May 30, 2022

Hi @franco69​ 

 

Please, could you share your data?

 

 

Thanks in Advance

franco69
Contributor
Forum|alt.badge.img+6
  • franco69Contributor
  • Author
  • Contributor
  • May 31, 2022
danilo_fme wrote:

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
Contributor
Forum|alt.badge.img+5
  • pknoContributor
  • Contributor
  • April 24, 2023
franco69 wrote:

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


Helpful Members This Week

Community Stats

31,378
Posts
119,013
Replies
39,009
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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