Move columns in Excel and write values …Is this the best?

Hello!

I want to move columns and write when writing to excel.

Now it works, is this the best?

This was the limit for me :innocent:

But I think there is a better way … :pleading_face:

Hi,

Although it depends on what you want to achieve, the following might help you.

In general, write range is more efficient than write cell if number of data is many. If you have much data, perhaps you should use it.

Regards,

1 Like

Yes You Can Achieve you can move the column using the SetOdina method inside the invoke method you just call it will move the column and give the index inside the parameter
image
image


That 3 is where you have to move

regards
Chethan P

1 Like

あなたのお陰でとても素晴らしいものが出来上がりました!
やり方を教えてくれてありがとう!
とっても感謝します :smiling_face_with_three_hearts: :smiling_face_with_three_hearts:

こんなやり方があるのを知りませんでした。
教えてくれてありがとう :smiling_face_with_three_hearts:
とっても感謝します :blush: