Reorder excel sheets

Help Studio
1

Hi, could you please advise how to reorder excel sheets? I need to move one sheet xy on the first page with in the excel. Thank you

2

Hi @jarous ,

There is an Activity in the BalaReva.EasyExcel.Activity Package called Move Sheet.

image

image

Could you give that a try?

Kind Regards,
Ashwin A.K

3

Hi, I have already tried that one but I am getting the error Move Sheet: Object reference not set to an instance of an object. Do you know why I am getting this error? Thank you

4

Hi @jarous ,

I’ve tested it from my end, and I haven’t run into any issues.

You have to pass in the Sheet name, but if you don’t know what the name of the Sheet at the first index is, then here is a short sequence I’ve developed for you →

Sequence1.xaml (7.6 KB)

Kind Regards,
Ashwin A.K

5

Hi, this is how I have it

image
image736×317 7.04 KB

as I need to add it to a first page I write :First

6

Hi @jarous ,

I’ve shared a sequence above, could you please see if that helps you out?

Kind Regards,
Ashwin A.K

7

Hi, it works Thank you.

8

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