Columns name - Excel Application Scope

Hey buddies, how do I set the column names of an Excel file created using the “Excel Application Scope” activity and fed with the “Append Range” activity?

Hi @bipenett

Welcome to forum

You can create a datatable varaible dt1 and using invoke code activitiy with dt1 varaible being as In/Out argument u can add the below code

dt1.Columns.Add(ColumnName,typeof( datatype)

Like.that u can add in the datatable

It would be a way u can try

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

could you please share workflow i appreciate

i am getting error while using
Main.xaml: No compiled code to run
error BC30112: ‘System.Data’ is a namespace and cannot be used as an expression. At line 1
error BC30109: ‘String’ is a class type and cannot be used as an expression. At line 1
error BC30287: ‘.’ expected. At line 1

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.