Support to export large data of Pivot Table columns across multiple sheets in a Excel Workbook Validated

Currently, the Excel export functionality is limited by Excel's maximum column count of 16,384 columns per worksheet. To address this limitation, we need to enhance the export process so that when the pivot table's column count exceeds this limit, the remaining columns are exported into subsequent worksheets within the same workbook. This will allow users to export large datasets without losing any data due to the column limitation. Please refer the before reference images in which the data is exported in two work sheets within the same workbook.

Sheet 1:

Sheet 2:

Additionally, consider utilizing the IMigrantRange instead of the standard Range property to enhance the performance of the Excel export process. For more information on performance improvements, please refer to the following user guide:

Goal: Ensure that users can export large datasets without data loss due to column limitations.