How could we swap columns in excel file, using Invoke Method?

Help Activities
, , ,
1

Hello,

I was trying to swap my columns in a generated Excel file in the same workflow and I was trying to use invoke method for it. It’s showing error as “Value cannot be null”.
In image shown,I am trying to swap my second column to first and first to second.
And could we use it swap multiple columns?

I am attaching the screenshot of the same. And the variables used in it.
Thank-you

Screenshot (64)
Screenshot (64)1920×1080 223 KB

Screenshot (66)
Screenshot (66)1920×1080 213 KB

2

@Neha_Kumari1
Welcome to the forum

have you used on following:
grafik

FilteredData.Columns(1) e.g. for reposition the second column?
Ensure FilteredData is valid and not null

once the second sol is repositioned to first postion, the original first col will be already on second position.

not with the SetOrdinal Method.
Give a try on this (Assumption Datatable defines 4 cols):
DtReordered = yourDataTableVar.DefaultView.ToTable(False,{“Col2”,“Col4”,“Col3”,“Col1”})
grafik

3

Thanks @ppr :blush:
I used FilteredData.Columns(“Value Date”) therein, as I wish to move one of my section Value Date to the first position. Should I use Index number there?
Yes, I am getting an output for filtered data

4

Okay sure, I would be trying on same and would let you know if it works.

5

@Neha_Kumari1
Working with Column Name is fine

  • set a breakpoint before the invoke method
  • debug it
  • use the immediate panel and type in following:
 FilteredData.Columns
 FilteredData.Columns(1)
 FilteredData.Columns("Value Date")

so you can check if the column is not null by using the statement within invoke method

6

Hi @ppr
Correct me if I am wrong, Did you meant this(attached image)to use in place of SetOrdinal method? Getting an error
The coulmn names i put in here are as I wish them to be swapped

Screenshot (71)
Screenshot (71)1920×1080 242 KB

7

@Neha_Kumari1
it was meant as an alternate:
grafik

grafik
grafik705×61 15.1 KB

8

@ppr
It’s still showing error as such :point_down:

Screenshot (73)
Screenshot (73)1920×1080 249 KB

9

you are missmatching and do part merging two different things. Please rearead the posts from above:

use invoke method, SetOrdinal
OR
use assign and the DefaultView approach

10

Sorry I get it now, just got confused
Would be checking on same and would update on if it works
Thanks @ppr :v:

11

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