We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Error creating xsl from template

Thread ID:

Created:

Updated:

Platform:

Replies:

42187 Mar 22,2006 04:14 AM Mar 22,2006 08:44 AM Windows Forms 1
loading
Tags: XlsIO
Guy Mahieu
Asked On March 22, 2006 04:14 AM

Hi, When I want to create a workbook from a template that contains a reference to some xla files, I receive the error below (sf 2.1.0.9). Do you guys have any idea if this is something that can be done with ExcelRW or should I just give up? Thanks in advance! Guy --- System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Invalid parameter used. at System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement) at System.Drawing.Image.FromStream(Stream stream) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoMetafilePicture.ParseStructure() at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoMetafilePicture..ctor(MsoBase parent, Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtBSE.ParseStructure() at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtBSE..ctor(MsoBase parent, Byte[] data, Int32 iOffset) --- End of inner exception stack trace --- at System.Reflection.RuntimeConstructorInfo.InternalInvoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.ConstructorInfo.Invoke(Object[] parameters) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, MsoRecords recordType, Byte[] data, Int32& iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, Byte[] data, Int32& iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseItems(Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseStructure() at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase..ctor(MsoBase parent, Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtBstoreContainer..ctor(MsoBase parent, Byte[] data, Int32 iOffset) --- End of inner exception stack trace --- at System.Reflection.RuntimeConstructorInfo.InternalInvoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.ConstructorInfo.Invoke(Object[] parameters) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, MsoRecords recordType, Byte[] data, Int32& iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, Byte[] data, Int32& iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseItems(Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseStructure() at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase..ctor(MsoBase parent, Byte[] data, Int32 iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtDggContainer..ctor(MsoBase parent, Byte[] data, Int32 iOffset) --- End of inner exception stack trace --- at System.Reflection.RuntimeConstructorInfo.InternalInvoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.ConstructorInfo.Invoke(Object[] parameters) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, MsoRecords recordType, Byte[] data, Int32& iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, Byte[] data, Int32& iOffset) at Syncfusion.ExcelRW.Parser.Biff_Records.MSODrawingGroupRecord.ParseStructure() at Syncfusion.ExcelRW.Parser.Biff_Records.BiffRecordRaw.FillRecord(BinaryReader reader) at Syncfusion.ExcelRW.Parser.Biff_Records.BiffContinueRecordRaw.FillRecord(BinaryReader reader) at Syncfusion.ExcelRW.Parser.BiffRecordFactory.GetRecord(TBIFFRecord type, BinaryReader reader) at Syncfusion.ExcelRW.Parser.BiffRecordFactory.GetRecord(BinaryReader reader) at Syncfusion.ExcelRW.Parser.BiffReader.PeekRecord() at Syncfusion.ExcelRW.Implementation.WorkbookImpl.Parse(BiffReader reader, Boolean ignoreStyle) at Syncfusion.ExcelRW.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName, Boolean ignoreStyles) at Syncfusion.ExcelRW.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName) at Syncfusion.ExcelRW.Implementation.ApplicationImpl.CreateWorkbook(Object parent, String strTemplateFile) at Syncfusion.ExcelRW.Implementation.Collections.WorkbooksCollection.Open(String Filename) at Syncfusion.ExcelRW.ExcelUtils.CreateWorkBookUsingTemplate(String templateLocation)

Administrator [Syncfusion]
Replied On March 22, 2006 08:44 AM

Hi Guy, Would it be possible to send us the template file so that we can test with the latest version?. You can also open a Direc-Trac insident so that the attachment remains confidential. You can also try our latest build which most likely fixes this issue ftp://syncpatch.syncfusion.com/EssentialStudio/4.1.0.63/syncfusionessentialstudiosetup.exe Best regards, Stephen. >Hi, > >When I want to create a workbook from a template that contains a reference to some xla files, I receive the error below (sf 2.1.0.9). Do you guys have any idea if this is something that can be done with ExcelRW or should I just give up? > >Thanks in advance! > >Guy > >--- > >System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. >---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. >---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. >---> System.ArgumentException: Invalid parameter used. >at System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement) >at System.Drawing.Image.FromStream(Stream stream) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoMetafilePicture.ParseStructure() >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoMetafilePicture..ctor(MsoBase parent, Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtBSE.ParseStructure() >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtBSE..ctor(MsoBase parent, Byte[] data, Int32 iOffset) >--- End of inner exception stack trace --- >at System.Reflection.RuntimeConstructorInfo.InternalInvoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault) >at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) >at System.Reflection.ConstructorInfo.Invoke(Object[] parameters) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, MsoRecords recordType, Byte[] data, Int32& iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, Byte[] data, Int32& iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseItems(Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseStructure() >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase..ctor(MsoBase parent, Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtBstoreContainer..ctor(MsoBase parent, Byte[] data, Int32 iOffset) >--- End of inner exception stack trace --- >at System.Reflection.RuntimeConstructorInfo.InternalInvoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault) >at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) >at System.Reflection.ConstructorInfo.Invoke(Object[] parameters) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, MsoRecords recordType, Byte[] data, Int32& iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, Byte[] data, Int32& iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseItems(Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase.ParseStructure() >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase.FillRecord(Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset, GetNextMsoDrawingData dataGetter) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoBase..ctor(MsoBase parent, Byte[] data, Int32 offset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoContainerBase..ctor(MsoBase parent, Byte[] data, Int32 iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsofbtDggContainer..ctor(MsoBase parent, Byte[] data, Int32 iOffset) >--- End of inner exception stack trace --- >at System.Reflection.RuntimeConstructorInfo.InternalInvoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault) >at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) >at System.Reflection.ConstructorInfo.Invoke(Object[] parameters) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, MsoRecords recordType, Byte[] data, Int32& iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MsoDrawing.MsoFactory.CreateMsoRecord(MsoBase parent, Byte[] data, Int32& iOffset) >at Syncfusion.ExcelRW.Parser.Biff_Records.MSODrawingGroupRecord.ParseStructure() >at Syncfusion.ExcelRW.Parser.Biff_Records.BiffRecordRaw.FillRecord(BinaryReader reader) >at Syncfusion.ExcelRW.Parser.Biff_Records.BiffContinueRecordRaw.FillRecord(BinaryReader reader) >at Syncfusion.ExcelRW.Parser.BiffRecordFactory.GetRecord(TBIFFRecord type, BinaryReader reader) >at Syncfusion.ExcelRW.Parser.BiffRecordFactory.GetRecord(BinaryReader reader) >at Syncfusion.ExcelRW.Parser.BiffReader.PeekRecord() >at Syncfusion.ExcelRW.Implementation.WorkbookImpl.Parse(BiffReader reader, Boolean ignoreStyle) >at Syncfusion.ExcelRW.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName, Boolean ignoreStyles) >at Syncfusion.ExcelRW.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String FileName) >at Syncfusion.ExcelRW.Implementation.ApplicationImpl.CreateWorkbook(Object parent, String strTemplateFile) >at Syncfusion.ExcelRW.Implementation.Collections.WorkbooksCollection.Open(String Filename) >at Syncfusion.ExcelRW.ExcelUtils.CreateWorkBookUsingTemplate(String templateLocation)

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;