Excel support (XLT format)

Aspose.Cells Product Family
1

Hello,

Our application use Aspose.cells version 7.7.0.0 for creating Excel reports based on Excel templates.

When we try to generate excel report based on xltx template, it works fine.

However, it failed with xlt templates.

Is this version of Aspose support xlt format?

On previous versions of Aspose it worked fine.

Thanks,

2

Hi,


Could you share a template Excel file (XLT) here, we will check your issue soon.

Thank you.
3

Template file is attached

Thanks,

4

Hi,


Thanks for sharing the template file.

After an initial test, I observed the issue as you have mentioned. I can read the XLT file fine but if I resave it back to XLT file format, the output file is somehow corrupt which is not opened fine into MS Excel. We will look into it soon. I used the template file provided by you and resaved it back to XLT file format type.
e.g
Sample code:

string filePath = @“E:\test2\Bill_of_Materials.xlt”;


Workbook workbook = new Workbook(filePath);


workbook.Save(filePath + “.outxlt1.xlt”, SaveFormat.Excel97To2003);
workbook.Save(filePath + “.outxls1.xls”, SaveFormat.Excel97To2003);

I have logged a ticket with an id “CELLSNET-42283” for your issue. We will look into your issue soon.

Once we have any update on it, we will let you know here.

Thank you.
5

Hello,

We are committed to our customers for supporting xlt format

I will appreciate if you can update me soon as possible

Thanks,

6

Hi Yoel,

Thank you for your patience with us.

This is to bring in your knowledge that we have resolved the ticket logged earlier as CELLSNET-42283. As soon as the fix for the said issue is available for public use, you will be able to save/re-save the spreadsheet in XLT format.

We will keep you posted with updates in this regard.

7

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.7.1.1 and let us know your feedback.

8

Hello,

The issue still reconstructed with Aspose.cells. version 7.7.1.0

For now, I found some workaround to save the fie as "xltx"

If (System.IO.Path.GetExtension(filePath).Equals(".xlt", StringComparison.InvariantCultureIgnoreCase)) Then

filePath = System.IO.Path.ChangeExtension(filePath, ".xltx")

End If

Please let me know if there is another solution for the short period.

Thanks,

9

Hi Yoel,

Thanks for using Aspose.Cells.

I have tested your issue with the latest version: Aspose.Cells
for .NET v7.7.1.4 and it works fine. I tested it using the following code. I have attached the output files for your reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Bill_of_Materials.xlt”;


Workbook workbook = new Workbook(filePath);


workbook.Save(filePath + “.outxlt1.xlt”, SaveFormat.Excel97To2003);

workbook.Save(filePath + “.outxls1.xls”, SaveFormat.Excel97To2003);

workbook.Save(filePath + “.outxls1.xltx”, SaveFormat.Xltx);

10

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.