Currently I have an application where I use C# and Apose to read a DBF file, put the data in a worksheet and use it as a datasource to populate my pivots. But, I am getting hit by the excel limitation of number of rows whenever I have a huge DBF. I know we can access several of Excels properties through Aspose, so here's my question
Is there a way to open a sheet that has pivot in it and refresh the pivot using a DBF directly. I am able to do it manually,but wondering if we can do it programatically using Aspose.
Any help on this is greatly appreciated.