Skip to main content
Question

copy tempelate tables from my sheet but modify number of rows in the tables copied with counter

  • February 15, 2020
  • 2 replies
  • 11 views

gogopotter90
Contributor
Forum|alt.badge.img+13

 

 

 

 

 

i tried a lot more than one hour but i did not success,

i did my work space and my output will be in different tables in the same sheet , so i would like to design a table include my result

.i mean,as example for the first table (Table A,) ,it will count how many rows that i have in my result then copy the first table from tempelate excel and add some rows or minus depend on the counter that counted my result ,and so on the same idea for the second and third .

i got from my workspace different tables but without any table format designed so i want to copy from my tempelate the design but with modify counter of my rows in output.so i used the counter

then i want the first row to include filter arrows for each table.

 

something else,i want to know i marked on overwriting existing file yes then i rerun workspace but i did not see any change in my output excel file till i delete it and rerun work space.it seems for me ,overwriting parameter does not work .how can i fix it .Thanks

 

 

FME version 2018

2 replies

takashi
Influencer
  • February 16, 2020

In the current FME, the Excel Writer just copies specified template file, I don't think there is a way to modify the copied template sheets at run-time.


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • February 17, 2020
takashi wrote:

In the current FME, the Excel Writer just copies specified template file, I don't think there is a way to modify the copied template sheets at run-time.

could i ask ,if it is possible before iam writting my output of workspace to excel writer ,i combine it by python caller or another transformers to generate tables according to my rows for each table so i will not need to the tempelate


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