Hello,
Could you please provide demo with Cells GridView control displaying Excel PivotTable in .Net 7 app.
I tried to modify https://github.com/aspose-cells/Aspose.Cells-for-.NET/tree/master/Examples_GridWeb/GridWeb.Net6 to include PivotTable but without luck.
Will appreciate any help.
Best regards,
Roman K
@kasyanovri
We haven’t built a .NET 7.0 DLL for GridWeb yet. However, you can still use the .NET 6.0 Windows DLL for GridWeb in a .NET 7.0 Windows project. Here is a demo project, GridWebNet7Demo.zip, for .NET 7.0 Windows. Please give it a try. If you still encounter any issues, please provide us with feedback.
Hi Peter,
Thank you for the quick response.
Unfortunately I wasn’t able to run your demo project.
It was missing Aspose.Cells.GridView, so I installed latest NuGet package but project not compiling. See screenshot with errors attached.
Please help.
image.png (161.3 KB)
Best regards,
Roman K
@kasyanovri,
I tested the project shared by @peter.zhou. You are right, by default, when you open the project into VS.NET and then import Aspose.Cells.GridWeb (latest version), it does not work. I found the same errors/issues as you pointed out via screenshot. Upon further evaluation, I found the Aspose.Cells.GridWeb.Dll (.NET 4.0 compiled) was imported/referenced instead of .NET6.0 Dll. So, I have to manually do that. I first removed the Aspose.Cells.GridWeb assembly from the Package and Assemblies nodes (in solution explorer of VS.NET). Then, I manually added the latest Aspose.Cells.GridWeb.Dll assembly reference (I have already Dlls version present at some folder) from “net6.0-windows” sub-folder to the project via “Add Project Reference…” right-click menu command. Now I fixed the paths for “SessionStorePath” and “PictureCachePath” in GridController.cs. Then I rebuild and run the project, it works fine. I clicked on the demo link on the page in the browser and I can see the pivot table from the template file is displayed fine. See the screenshot for your reference.
sc_shot1.png (64.6 KB)
Hi Amjad,
Thank you for your help. It works.
Does GridView support Excel Pivot Table designer? I mean can you change columns or rows fields from ui etc.?
Best regards,
Roman K
@kasyanovri,
No, there is no such UI designer available in GridWeb where you can directly drag/drop or change pivot fields or use other options. But, you can use filters attached to the row, column or data field(s) where you can filter pivot data accordingly. You can click on the arrow headers to filter data, just like in MS Excel.