Create blank excel sheet

Help Studio
,
1

Hi I want to create blank excel sheet.How I can create …?
right now I am using application scope in this case I need to pass datatable but I don’t have data table what I need to pass in daTA TAble.As mention in attachment

Untitled
Untitled1440×900 57.1 KB

2

@Aditya10989

You can pass empty DataTable also. Just create one DataTable variable and pass it.

1 Like
3

thanks.I am getting error.object of instance like null value.I need to pass default value in data table…?

4

@Aditya10989

Pass below way under DataTable field in Write Range activity.

                        New DataTable()

image

2 Likes
5

then I think no need to create variable.and can you please explain me how to pass header in this excel

6

@Aditya10989

Yes in this case you no need to create new variable of type DataTable.

Do you mean want to create new excel sheet with headers ?

If yes then use Build DataTable activity and write headers and save it into one datatable variable. And then pass that datatable into Write Range activity.

1 Like
7

you mean to say build table use data table variable same data table variable I need to pass in write range instead of new data table() …?

8

image

Just do this!
Use Build Data Table activity and you can give columns
@Aditya10989

1 Like
9

@Aditya10989

Yes, Exactly.

If you want to create empty sheet then pass New DataTable()
Else use Build DataTable activity and write what fields you want to write it and then save into one DataTable variable and pass it to Write Range activity.

1 Like
10

not getting header error as mention in attachment

Untitled
Untitled1440×900 64.2 KB

11

@Aditya10989

Did you saved the Build DataTable output into DtProcessReport variable or not ?

And also check Add Headers option in Write Range activity.

12

yes but I am using same build data table in another work flow I just copy and paste and remove output data table name used DtProcessReport and add header already checked

13

@Aditya10989 Do you want an Excel Sheet with Headers present or Just an Empty Excel Sheet?

14

@Aditya10989

If you want to write headers then use Write Cell activity and provide range and column names.

15

yes this I can do but I need to pass 15 header.Every time I used write cell activity it makes my code lengthy.what is the possible reason I am not getting header using build data table…?

Untitled
Untitled1440×900 61 KB

16

I only want header

17

@Aditya10989 You can use Datatable.Clone as the Value Inside Write Range if you have a Datatable with the Headers you need, with Add Headers Checked.

18

Sequence.xaml (5.7 KB)

Go through this workflow!
@Aditya10989

19

I run your application also not get header

Untitled
Untitled1440×900 65.9 KB

1 Like
20

Sequence.xaml (6.8 KB)

try now!
@Aditya10989