Is it possible to create multiple outputs in one single excel bt in different sheets and if it is then how to rename that sheets from EasyDataTransform?

Want Example too asap

You can write to multiple sheets in the same Excel file. You probably want Write mode set to Overwrite / Sheet.

If you output to MySpreadsheet.xlsx[Sheet1] means the sheet named Sheet1 of file MySpreadsheet.xlsx (the sheet name is not case sensitive).

See also: