New report with existing template

Aspose.Cells Product Family
1

Hi,

I would like to use my own template with different styles to generate excel sheet.

Workbook workbook = new Workbook();
workbook.Open(“C:\excel\COMMON\deliverables\disp5.xls”);

… my new code
…
workbook.save(“C:\excel\COMMON\deliverables\abc.xls”);

So when i do like this my existing styles will not appear in the new report is there any way to do this.
and also one more question Does aspose.cells library supports for .xlsx file generation?
Please clarify.

Thanks,
Vissu.

2

Hi,

I am going to attach my documents will you please check this?

disp5.xls is my source document which contains pivot tables in first three tabs. I am going to fill the RAW DATA through source when i do like this all of my styles disappeared in the new sheet (abc.xls)

Can you please reply as early as possible?

Thanks,
Vissu.

3

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. It works fine with your template file.

vsnl:

and also one more question Does aspose.cells library supports for .xlsx file generation?

Yes, Aspose.Cells supports Excel 2007 Xlsx file format. Please see the following documentation link for opening and saving the files as Excel 2007 Xlsx file format.

Thank You & Best Regards,

4



Hi,

I am getting Null Reference exception when i open xlsx file with this code

Workbook workbook = new Workbook();
workbook.Open(“C:\excel\COMMON\deliverables\Dispose6.xlsx”, FileFormatType.Excel2007Xlsx);

Exception : obejct reference not set to an instance of object


Thanks,
Vissu


5

Hi,

Thank you for considering Aspose.

Please post your template file here. We will check it soon.

Thank You & Best Regards,

6

Hi,

Please find the attached template which i am using right now.

Thanks,
Vissu

7

Hi,

Thank you for considering Aspose.

Well, I tried your provided file with the latest version (attached in my previous post) and it opens the file fine. Have you tried the attached version? If not, please try it and let us know if you still face this problem.

Thank You & Best Regards,

8

Hi,

Whatever your said is correct.The file(xlsx) opened properly with new version but i am not getting source sheet styles to the new sheet.Is there any way to do this.


Thanks,
Vissu

9

Hi,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test regarding the style loose of pivot table. We will look into this issue and get back to you soon.

Thank You & Best Regards,

10

Hi,

Thanks for your help.

I am waiting for your reply whether it can be done through aspose or not. Please let me know.


Thanks,
Vissu

11

Hi Nausherwan Aslam,

Still i am waiting for your reply whether this can be done through aspose or not.

Thanks,
Vissu

12

Hi Vissu,

Thank you for considering Aspose.

Well, we are looking into your issue and we will try to update you as soon as we figure out the issue regarding style issue with pivot table.

Thank you for your patience,

13

Hi,

Please try the attached version, we have fixed it.

If you still find any issue, kindly feel free to contact us any time.

Thank you.

14

The issues you have found earlier (filed as 9958) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

Note: Just for your knowledge. In the new release v4.8.0, we have merged Aspose.Grid suite to Aspose.Cells for .NET msi installer as Aspose.Grid would be no longer offered as a separate product now. You need to install the installer (uninstall older one first if you have) and use only Aspose.Cells.dll library in your project for your need. You may also take advantage using Aspose.Cells Grid suite though.