We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Report Templates with PivotTables don''t open

Thread ID:

Created:

Updated:

Platform:

Replies:

69652 Nov 6,2007 05:58 PM UTC Nov 7,2007 12:39 PM UTC ASP.NET Web Forms (Classic) 2
loading
Tags: XlsIO
Jim Barry
Asked On November 6, 2007 05:58 PM UTC



I am using excel template ideas to preform Excel templates (including pivot tables). I then take the template, dynamically add data and provide a web link to download the resuling file.

When the file is downloaded through IE, the PivotTable is having problems with the IE naming convention (ie the brackets) while the file sits inside of Temporary Internet Files

Two scenarios are troublesome:

1) DataSource =

If I use named regions as the datasource, I get the following error:

"The PivotTable field name is not valid. To create a Pivot Table report, you must use the data...".

If I save the file, and then refresh the PivotTable data --- it works.

All columns are non-blank and valid.

2) DataSource =

If I use a standard range syntax for the datasource, I get the following error:

"Cannot open PivotTable source file'[filename[x].xls]'Results!"

where 'Results!' is the worksheet that has the dynamic data.

It can't seem to reference the file because of the naming convention that includes brackets.

I tried opening the template excel files two ways with no luck..

workbook = excelEngine.Excel.Workbooks.Open(
strNewFileNamePath,
ExcelParseOptions.DoNotParseCharts
);

workbook = excelEngine.Excel.Workbooks.Open(
strNewFileNamePath,
ExcelParseOptions.Default
);


Operating Systems = XPSP2
Browser = IE7

If I save the file to be outside of the Temporary Internet Files, everything works as expected.

Any Ideas...



Jim Barry
Replied On November 6, 2007 06:35 PM UTC

Also tried opening the workbook with no luck using...

workbook = ExcelUtils.CreateWorkBookUsingTemplate(
strNewFileNamePath
);


Melba Winshia [Syncfusion]
Replied On November 7, 2007 12:39 PM UTC

Hi Jim,

Your direct-trac incident 38886 has been updated which has been created for the same issue. Please follow this issue in that incident #38886.

Kindly let me know if you have any other questions.

Thanks,
Melba



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;