We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Reading all data from the Base fields of Pivot Table

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

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.

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

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.

Thanks!

Best regards,
Alex Shloma

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)

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

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.