gHowl WISH: Spreadsheet Writer Revamp.

Hi Luis,

As you already know I'm a big fan of this and cannot praise its inclusion in GH enough.

Recently I have had a job which has highlighted a need which you might be able to incorporate to make the implementation of the Component more autonomous without the need for user intervention.

At present you have 1 main input for the data to be placed on a single sheet as per the input and the option to add more sheets manually.

Would it be possible to alter this to have a Data input and a Sheet Name Input so that the Path Structure dictates which sheet gets what data and the optional Name input gets applied.

For example

{0;0;0}(N=10) is Range A1:A10 on Sheet 1

...

{0;0;9}(N=10) is Range J1:J10 on Sheet 1

{1;0;0}(N=10) is Range A1:A10 on Sheet 2

...

{1;0;9}(N=10) is Range J1:J10 on Sheet 2

etc.

I realise that this would have to be very particular, making sure that only Place Holder A has influence over what sheet is used If there is a distinction of multiple sheet names.

For Example if you had a list of:

{0}(N=10)

{1}(N=10)

{2}(N=10)

{3}(N=10)

Place holder A could either be sheets or Rows so it would have to only work when there was a corresponding Sheet Names List for {0}, {1}, {2} and {3}

At present I have to do this manually using Explode Tree etc. Whenever I expand on the conditions (different Draft or Heel) Then I have to increase all of the outputs for the components highlighted in Pink