Cannot Open Storage Exception

[Santhosh A V]

Hi,

I have a problem opening the excel template document , which uses the CreateWorkBookUsingTemplate(String TemplateLocation) method to create the workbook using the template format.

We are using 3.3.0.0 version of syncfusion & in that we are using 3.302.0.0 version of syncfusion assemblies which are built on .NET Framework 2.0.The problem is , earlier our excel template format was  of type .xlt , where without any problem was getting opened.But now we want to upgrade from .xlt to .xltm version.We are hardcoding the entire template location in code as below.

Using Syncfusion.ExcelRW;

            ExcelEngine excelEngine = new ExcelEngine();
            excelEngine.ThrowNotSavedOnDestroy = false;
           
            IWorkbook myWorkBook = null;
            IApplication application = excelEngine.Excel;

 myWorkBook =                ExcelUtils.CreateWorkBookUsingTemplate(System.Windows.Forms.Application.StartupPath + "\\" + "Template.xltm");    //////
Here in this statement it is throwing th exception "Cannot open storage"..The same statement , works if I change the extension of template to .xlt.

We are actually using the .xlt template & saving it as .xltm using 2007 or 2010 excel & then trying to open in our code.

Kindly let us know your valuable suggestions

Regards,
Santhosh Ambale Venkatesh

[Rajesh A]

Hi Santhosh,

Thank you for using the Syncfusion products.

Currently we don’t have the support for *.xlt to *.xltm conversion. We are requesting you to create a new direct-trac incident and Request for issue in that. And also your assemblies’ version seems to be very old. So, we strongly recommend you to upgrade your product to our latest version, which resolves major fixes and enhancements.

Direct-Trac Link: Login

You can download the latest version from the following link.

http://www.syncfusion.com/downloads/latest-version

Kindly let us know if you need any clarification.

Regards,

Rajesh A

[Santhosh A V]

Thanks for the quick reply Rajesh.I will do as per your suggestion & will come back for clarifications , if any

Regards,
Santhosh Ambale Venkatesh

[Rajesh A]

Hi Santhosh,

   Thank you for your update.

  Please let us know if you have any clarification.

Thanks,
Rajesh.A