How to create the table for Excel with out range

Hi guys.I need to create the table for Excel with out mentioning the range of the excel.Can anyone help me with this.

Can you be more specific? Do you want to create datatable to insert into excel?

@sandhyak9 - Can you brief your scenario what you want exactly?

Hi @sandhyak9

Based on what I understood about your question, you need to write to an excel file without specifying the cell range of the excel… If that is what you asked, yes you can… In the Write Range activity, you can leave the range empty… Just like below


For the rest, you can specify the workbook path, and the datatable variable that contains data to be written to the excel file.

Does it work for you?