I had a small doubt
As this is my query
*while using read range activity to read the data
*but in the data we are having 8columns but I am getting 11 with empty columns
Want to delete the empty columns
@Vajrang Can you Please help me on this.
you can save the columns you need using this query
Take a Look at the Workflow in the Below Post, It Should be able to Remove the Empty Columns in the Datatable :
Could you try following the Below Steps :
Use the WorkBook Read Range Activity to Read Excel file from the Range "A2"
Next use the Below Workflow to Remove Empty Columns in the Datatable
Remove Empty Columns.xaml (11.7 KB)
You would require to Invoke this as a Workflow, from your main workflow and supply the arguments.
or if you do know the Column Names before hand, we can pass the Column Names to the Below Expression to Keep only needed Columns :
Using an Assign Acti…
we can achieve this using LINQ query
lets say u hv used Read range and stored Output as DT
so drag an assign activity and write the expression as below
newDT = DT.DefaultView.ToTable(False,"Column 1","Column 2", ...,"Column 8").CopyToDataTable
next use write range and print that datatable to an excel
Hope this Helps
The solution is resolved as here
i am using while loop into that
if condition to check the column names contains “Column” if its there
iit will move to then condition and in that i am using list variable
So i am storing “column” names.
again I had used for each so i gave that list variable
with remove data column activity.