I have 2 excel files
file 1: rawdata.xlsx - has only one sheet with a TABLE full of data
file 2: pivot.xlsx - Contains only 1 sheet with a pivot table - whose data is comning from rawdata.xlsx (file 1).
I am using GridWeb v2.5.0.2000 and runtime version: v2.0.50727
also Cells v5.3.0.0, and runtime version: v2.0.50727
I have an simple ASP.NET 2.0 test web app with the GridWeb control on the default.aspx page.
here’s the code i am using to load the pivot.xlsx file:
---------------------
string filepath = “pivotxlsx”;
//Opening an Excel file as a stream
FileStream fs = File.OpenRead(filepath);
//Loading the Excel file contents into the control from a stream
GridWeb1.WebWorksheets.ImportExcelFile(fs);
//Closing stream
fs.Close();
---------------------------
The webpage renders the pivot file ok, but if my rawdata file changes how do I make the gridweb control refresh the pivot?
Nitin
Bell Canada
Hi,
Well, I am afraid GridWeb does not support to manipulate pivot table or Refresh pivot table report’s data from the template file(s). Anyways, I have logged your request into our issue tracking system with an id: CELLSNET-24720. We may look into the feature in future versions.
Thank you.