Saving workbook causes [1] to be added to file name

Aspose.Cells Product Family
1

Hi,

I'm using the following code to save a pivot report.

pivotReport.Save("foo.xls", SaveType.OpenInExcel, FileFormatType.Excel2003, this.Response);

However when excel opens the filename is "foo[1].xls" which results in the following message "Cannot open PivotTable source file '[foo[1].xls]DataSheet'.

Trying to then manually pivot the data from the worksheet produces the same message.

Any thoughts on preventing the [1] from showing up? Saving the report to disk first is not an option.

Thanks,
Justin

2

Hi Justin,

Which version of Aspose.Cells .Net you are using? Please try the version downloading from the thread: <A href="</A>. If you still find the problem, please post your complete test code with the excel file(s) that could re-produce your issue.</P> <P>And related [1], well, that's the routine of the browser, you cannot omit it.</P> <P>Thank you.</P>

3

Hi Amjad,

Unfortunately my company does not me posting the code. I've attached the file it generated, the weird thing is the filters are populated (the drop down arrows for each column) but the data is not. I've attached it.

I'll try the new dll referenced in the other post, I see Excel2007xlsx as a valid format, does that also mean it can now handle more than 65,000 rows (the new limit in 2007 being 1 million)?

Thanks,
Justin

4

Hi Justin,

Which version do you use? Please try this version.

If you are creating a web application and open the file in IE,please confirm the URL does not follow with "?".It will throw "Could not find the PivotSource file '[xxx.aspx?name=test]data" if the URL likes `http://localhost/:1442/TestWeb/xxxx.aspx?name= test`. Please use "post" method to remove the string "?name=test" .