How to write single column from data table to excel

Help Activities
1

I want to write one column to excel file how it is possible.

2

@Anil_Potekar

Keep only one column in the datatable and use write range…

Or

If it is a table use insert column

Cheers

1 Like
3

I have table like bank statement I want to find max debit entry from debit column with remaining balance,date , particular of that entry.
Please make sample file and send…

4

you can use this expression
dt.AsDataView().ToTable(False,“col1”)

2 Likes
5

HI @Anil_Potekar

You can use filter datatable activity and make the filter configuration like below and try
image

Regards
Sudharsan

1 Like
6

@Anil_Potekar

To get max value use the following in assign…output would be double type

Maxval = dt.AsEnumerable.Max(function(x) cdbl(x(“requiredcolumn”).ToString))

Now to the the row…you can use filter datatable

Cheers

7

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