Write to multiple sheets of an Excel file

<< Click to Display Table of Contents >>

Navigation:  How do I? >

Write to multiple sheets of an Excel file

To write to multiple sheets (tabs) of the same Excel file you need to set the Write mode of each output item to Overwrite/Sheet (to clear the sheet first) or Append (to add to existing sheet data).

 

Write to multiple sheets of an Excel file

 

If you set the Write mode to Overwrite/File for an item then the write will remove existing sheets.