New excel not create with only header without data

Help Studio
, , ,
1

Hi,new excel not create with only header without data using build data table @Palaniyappan

1 Like
2

Build data table creates a new data table . did you read the datas which you want to use inside the datatable

3

I just want to create new sheet which contain only header

4

@Aditya10989

Use Write Cell activity and mention column name and it’s cell range.

5

Perfect
-use a BUILD DATATABLE a activity and create a table structure we want
And get the output with a variable of type datatable named dt
—next this build datatable activity use a CLEAR DATATABLE activity where mention the input as dt so that it will delete all the records and keep only the headers
—now use a WRITE RANGE activity where pass the variable dt as input and enable Add Headers property in the property panel which would right only the headers to the excel we need

Cheers @Aditya10989

6

Thanks for reply I try this it remove header also

1 Like