Skip to main content
Solved

Excel Writer - all outputs to same sheet

G
Forum|alt.badge.img

Hi all, i am creating a summary report of a larger workspace output in excel. I use 3 stats calculators and a sampler to output what i want to excel. Currently the outputs are going to individual sheets in my output xls file. I would like them on one sheet. Can this be achieved?

I have tried the "named ranges", "starting columns" etc etc. When i try and name my "Sheet Name" on the writer the same as another is appends 00 to it because it clashes? Any help appreciated or is this not possible ? Thanks Steve

Best answer by taojunabc

If you use more than one FeatureTypes, It will be automatically add 00,01 such serial number.

You can put all of the output connected to a FeatureType, so that it can be output to the same Sheet.

View original
Did this help you find an answer to your question?

5 replies

taojunabc
Participant
Forum|alt.badge.img+6
  • taojunabcParticipant
  • Participant
  • Best Answer
  • July 20, 2016

If you use more than one FeatureTypes, It will be automatically add 00,01 such serial number.

You can put all of the output connected to a FeatureType, so that it can be output to the same Sheet.

pratap
Contributor
Forum|alt.badge.img+11
  • pratapContributor
  • Contributor
  • July 20, 2016

Hi @goatboy,

Mapping has to be done as shown in the screenshot above. Data will be appended. For example, 1 record from creator and 1 record from Creator_2 are present then output excel will contain 2 rows of data. If you want the values should be in exact cell & column then you have to define using xlsx_row_id (format attribute) for row and User attributes for column.

Hope this helps

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • July 20, 2016

feature_type fanout on the writer sets the sheets. Use an attribute for that.

The excel workbook is a dataset. You can fanout a dataset in the navigator panel on the excell writer. parameter>advanced>fanout Dataset This creates separate workbooks.

G
Forum|alt.badge.img
  • goatboy
  • Author
  • July 20, 2016
taojunabc wrote:

If you use more than one FeatureTypes, It will be automatically add 00,01 such serial number.

You can put all of the output connected to a FeatureType, so that it can be output to the same Sheet.

Thanks Taojunabc, this is close to what i want. Its still a bit messy as each of my "creators" in your diagram above have different destination schema, I end up with a weird (but usable) hybrid schema in my xls file. Thanks for your help, Steve

taojunabc
Participant
Forum|alt.badge.img+6
  • taojunabcParticipant
  • Participant
  • July 21, 2016
@goatboy

If you need to output different Schema to the same Sheet, then you can consider to use the Template, and combining with the method specified xlsx_row_id @pratap said. Specific Settings refer to xlsxWriterSetting. png.

Reply


Helpful Members This Week

Community Stats

31,627
Posts
119,841
Replies
39,259
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.