two diff collections output into same file

 
Parents
  • If you are writing to a CSV file then it will be a flat file and it will not be able to hold multi-sheet structure which is available in EXCEL so the short answer for CSV is no. However, another possible method would be:
    1. Write output to two different CSV files
    2. Use Excel macro which will read these CSV files and import data onto two separate tabs.

    I have not tried with Excel directly so will not comment on that part.
Reply
  • If you are writing to a CSV file then it will be a flat file and it will not be able to hold multi-sheet structure which is available in EXCEL so the short answer for CSV is no. However, another possible method would be:
    1. Write output to two different CSV files
    2. Use Excel macro which will read these CSV files and import data onto two separate tabs.

    I have not tried with Excel directly so will not comment on that part.
Children
No Data