Reading all data from the Base fields of Pivot Table

Aspose.Cells Product Family
1

Hi,

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?

Thank you,
Alex Shloma

2

Hi,


Could you try our latest version/fix: v7.0.3.1, if you still find the issue, kindly give us template files and also paste your sample code here to reproduce the issue, we will check your issue soon.

3

Hi,

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:

Region
Product
Mar
Apr
May
Jun
These fields I see as empty:
Jan
Feb
Jul
Aug
Sep
Oct
Nov
Dec

Code snippet:

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;
while (true)
try
{
string str = “Item”;
if (cntTry > 0) str = “[” + cntTry.ToString() + "] " + str;
printLine(str, pf.Items[j], SPACE4);
break;
}
catch
{
if ((cntTry > 1000) || (!tryReloadItems))
{
printLine(“Item”, " ============== ERROR ============== ", SPACE4);
break;
}
cntTry++;
}
}
}

I’ve attached sample document.

Thank you,
Alex Shloma
4

Hi,


Thanks for sharing the sample code and template file.

I have logged a ticket with an id: CELLSNET-40105. We will look into your issue soon.

Thank you.
5

Thanks!

Best regards,
Alex Shloma

6

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.
(1)
7

Hi,


I checked the latest version (7.0.4.0) and it has the same problems. Should I create new ticket for this or you can reopen?

Best regards,
Alex Shloma
8

Hi,


It will be better if you could create a new thread for your issue. Also give us complete details, screen shots, sample console application (with v7.0.4), template files etc. We will check it soon.

Thank you.