Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Jan 26, 2010 1:43 pm

Hello,
I have a problem with Spire XLS, version 2.600.2.0.
I'm using Visual Stuido 2005 (.net framework 2.0) in order to create a web application in visual basic.
When I load a XLS file (332 kb) the Workbook.LoadFromFile("File path") method returns the following error: "Exception of type 'System.OutOfMemoryException' was thrown". This error doesn't appears if I load a smaller file (ex. 102 kb).

Could you please help me to solve this problem?

Thaks a lot, kind regards

Emanuele Cunegatti

gambling-laws.
 
Posts: 2
Joined: Fri Sep 08, 2006 7:03 am
Location: gambling-laws.AFFILIATE-BOOKS.COM

Tue May 25, 2010 7:27 am

Could you send your xls file to us ? thank you!

adtionsa
 
Posts: 5
Joined: Sat Sep 09, 2006 7:48 pm
Location: Basel

Thu Mar 15, 2018 1:11 pm

docX.SaveToFile(DOCXresultFilePath, Spire.Pdf.FileFormat.DOCX);


for me while calling this function it throws OUTOFMEMORYEXCEPTION..

WHY?

is this problem occurs because of i am using trial version?

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Fri Mar 16, 2018 1:39 am

Hello,

Thanks for your post. Please first use the latest Spire.Pdf(Spire.PDF Pack(Hot Fix) Version:4.3.4) to have a try. If the issue still exits, please share us with your input Pdf file and full code. You could attach your document here or send it to our email(support@e-iceblue.com).

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Fri Mar 16, 2018 5:03 am

Hi I am using Spire.Office 2.16.27 as i want to convert and merge both file types PDF and DOCX.
please look at the below steps i used for converting.. I want OutPut as Word file

1) Sending both docx and pdf files
2) If PDF file occur convert it to PDF
3) then collect all PDF files and Merge it. GENERATE NEW PDF FILE suppose SAMPLE.pdf.

till his step everything works fine..

4) Now i want to convert SAMPLE.pdf to Docx using below code

PdfDocument docX = new PdfDocument();
resultFilePath=SAMPLE.pdf file Path

docX.LoadFromFile(resultFilePath);

string DOCXFileName = String.Format("{0}.docx", Guid.NewGuid().ToString());
string DOCXresultFilePath = Path.Combine(_appFolders.TempFileDownloadFolder + "\\" + mainDirectory, DOCXFileName);

docX.SaveToFile(DOCXresultFilePath, Spire.Pdf.FileFormat.DOCX);


NOW EXCEPTION occurs for this function..

Like
1) OUT OF MEMORY EXCEPTION
2) SYSTEM FORMAT EXCEPTION
3) BITMAP EXCEPTION



Please reply me ASAP, I am Waiting..

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Fri Mar 16, 2018 6:09 am

Hello,

Thanks for your information. Please share us with your SAMPLE.pdf file.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Fri Mar 16, 2018 6:29 am

System.FormatException: The string 'on' is not a valid Boolean value.
at System.Xml.XmlConvert.ToBoolean(String s)
at spr?.?(XmlReader A_0)
at spr?.?(XmlReader A_0)
at spr?.?(Stream A_0)
at spr?.?(spr? A_0)
at spr?.?(Document A_0)
at spr?.?(Stream A_0, Document A_1)
at spr?.?(String A_0, Document A_1)
at Spire.Doc.Document.?(String A_0)
at Spire.Doc.Document.LoadFromFile(String fileName, FileFormat fileFormat, String password)
at Spire.Doc.Document..ctor(String fileName, FileFormat type)
at WAi.IRHub.Web.Controllers.ChatControllerBase.<MergeDocxFiles>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at lambda_method(Closure , Object )
at Microsoft.Extensions.Internal.ObjectMethodExecutorAwaitable.Awaiter.GetResult()
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__23.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ExceptionContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextResourceFilter>d__22.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeFilterPipelineAsync>d__17.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Builder.RouterMiddleware.<Invoke>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Builder.Extensions.MapMiddleware.<Invoke>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.Owin.Mapping.MapMiddleware.<Invoke>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Owin.WebSocketAcceptAdapter.<>c__DisplayClass6_0.<<AdaptWebSockets>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.<Invoke>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
at WAi.IRHub.Web.Startup.Startup.<>c.<<Configure>b__4_1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Abp.AspNetZeroCore.Web.Authentication.JwtBearer.JwtTokenMiddleware.<>c__DisplayClass0_0.<<UseJwtTokenMiddleware>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.<Invoke>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware.<Invoke>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Server.IISIntegration.IISMiddleware.<Invoke>d__11.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.AspNetCore.Hosting.Internal.RequestServicesContainerMiddleware.<Invoke>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.Frame`1.<ProcessRequestsAsync>d__2.MoveNext()
INFO 2018-03-16 11:58:17,594 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 142190.5999ms 0

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Fri Mar 16, 2018 7:01 am

Hello,

I can't find your attachment. Please first zip them and upload it.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Fri Mar 16, 2018 7:15 am

I have send you an EMAIL please check on SUPPORT ID

SAMPLE FILES FOR MERGE from user SURAJ92

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Fri Mar 16, 2018 7:18 am

i have also download latest HOT FIX copy for PDF and DOC.

still facing same problem..

may be my coding way is wrong..please help..

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Fri Mar 16, 2018 8:58 am

Hello,

Thanks for your sharing. I have reproduced the issue while converting the result Pdf file to docx and posted it to our DEV team. Once it's fixed or any update, we will let you know.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Fri Mar 16, 2018 10:09 am

Thanx, if possible please try to provide ASAP. 8)

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Mon Mar 19, 2018 1:45 pm

I am using Trial VERSION, could i used it to run on SERVER?

suraj92
 
Posts: 12
Joined: Thu Mar 15, 2018 9:57 am

Tue Mar 20, 2018 1:28 am

Hello,

Thanks for you inquiry.
Yes, you could. Please go ahead.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Return to Spire.XLS

cron