Need to create Pivot table from different sheets inside a single workbook

Aspose.Cells Product Family
1

Hi

I have a large data , so reduce the load on the I have shared the data into different multiple sheets in a single excel file

Can I create a Pivot table from these multiple sheets ?
If yes , please share some node js related aspose examples for this so that I can use them

Thanks,
veerendra

2

@Veerendra1234,

Could you do this manually in MS Excel? If you can create a pivot table with a data source based on data from multiple worksheets in MS Excel, then you can accomplish this using Aspose.Cells APIs. Could you please provide a sample Excel file having a pivot table with data from multiple worksheets? You may create the file manually in MS Excel and then zip it before attaching. We will then investigate how to achieve this using Aspose.Cells APIs.