I read item data from Base fields of my pivot table. All fields have data (in Excel), but I can read only some fields.
Is there any way to read all data from Base fields?
With latest dll that you suggest, I have the same result.
I created simple Excel file with pivot table.
I can read items from fields:
RegionThese fields I see as empty:
PivotFieldCollection pfc = pt.BaseFields;
bool tryReloadItems = true;
for (int i = 0; i < pfc.Count; i++)
PivotField pf = pfc[i];
printLine(“ItemCount”, pf.ItemCount.ToString(), SPACE4); // my inner printing method
for (int j = 0; j < pf.ItemCount; j++)
int cntTry = 0;
string str = “Item”;
if (cntTry > 0) str = “[” + cntTry.ToString() + "] " + str;
printLine(str, pf.Items[j], SPACE4);
if ((cntTry > 1000) || (!tryReloadItems))
printLine(“Item”, " ============== ERROR ============== ", SPACE4);
I’ve attached sample document.
The issues you have found earlier (filed as CELLSNET-40105) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.