[Advanced Excel] Rearrange columns - Dynamic Export to excel (Advanced Excel)

Question

Hi Team,

We have generated a dynamic report using Advanced Excel. Now we want to rearrange the columns as per the user request.

Eg, We have a report generated with four columns - Country, Ciy, State, Zip.

Now 1st user can request to have the report with column sequence as State, City, Country, Zip

Similarly, 2nd user can request to have the report with column sequence as Country, State, City, Zip

and so on..

To sum up the requirement - we want to rearrange the columns to be generated in dynamically generated excel using Advanced Excel component.

Kindly suggest a good way to achieve the same.

Thanks in advance!

Regards,

Neha Agrawal

on 6th Apr

Hi Guys,

We have resolved the issue with a logic using CellRead, CellWrite, and WorkbookPorperties action from Advance Excel component.

Thanks for the support.

Regards,

Neha Agrawal

on 7th Apr

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.