Creating Excel Workbook from template - issues

kpc · September 20, 2018, 2:00pm

I want to create a excel workbook from a template file and manipulate some sheets.
The template file has 8 worksheets and some have pivot tables/charts. When I create a workbook from the template, the browser just hangs. I cannot figure out what is happening.
Otherwise if I use a simple template, the aspose workbook does get created. In the case of my specific template, the code at the workbook creating just hangs. Help!!

amjad.sahi · September 20, 2018, 2:17pm

@kpc,

Thanks for the datails.

Please provide your template file, so we could evaluate your issue by opening the file via Aspose.Cells APIs. If we find the issue, we will log a ticket for it, so it could be fixed soon.

kpc · September 20, 2018, 2:40pm

Thank you for looking into this. How can I send you a .xlsx file ?

amjad.sahi · September 20, 2018, 5:41pm

@kpc,

Please zip the file and attach it here, we will check it soon.

kpc · September 20, 2018, 7:11pm

d1.zip (46.0 KB)
Hi,
Please find the zip attached.
One of the tabs will be populated with data dynamically.

Thanks again for the support.

ahsaniqbalsidiqui · September 21, 2018, 1:25am

@kpc ,

Thank you for providing the sample XLSX file. We have loaded and saved the attached file again but observed no issue. Latest version Aspose.Cells for .NET 18.9.x is used for testing. Please send us a console application(runnable) for our testing here. We will use it to reproduce the issue and provide our feedback accordingly.

kpc · September 21, 2018, 1:52pm

Thank you for the feedback. We will see if we can upgrade to latest version or I will send you the console script. Thanks again!!

ahsaniqbalsidiqui · September 21, 2018, 8:14pm

@kpc

Alright, let us know your feedback. You are welcome.

kpc · September 24, 2018, 5:37pm

We decided to create the pivot charts and tables via code. Now, I need to change the color of a column in a pivot chart and also control the column height and width. how can I do it? I see such things can be done with series collection.

ahsaniqbalsidiqui · September 25, 2018, 2:05am

@kpc,

Thanks for contacting Aspose support team again.

Please provide us the following data to understand your requirements. We will provide our feedback once the required information is available.

A console application (runnable) which creates the pivot charts and tables as mentioned above.
The output file created by this application using latest version Aspose.Cells for .NET 18.9.x.
Modify the output file (in step2) using Excel where all the required changes are done like color change of a column in a pivot chart, change in column height and width. This shall be your desired output file which you want to create using application. It will help us to exactly understand your requirement and provide solution to achieve same output using Aspose.Cells API.