Let me explain what I am doing.
I am doing this conversion on a server(WCF application) having a running print2flash service. I made a request of conversion from my client running on another machine.
Conversion of Excel file with empty sheet fails
Re: Conversion of Excel file with empty sheet fails
If actually you don't develop a plug-in for MS Excel but rather a desktop application,then it is better to use ConvertFile method as previously.
Can you convert documents successfully when SkipEmptySheets is false? If so, what does not satisfy you in this case?
Can you convert documents successfully when SkipEmptySheets is false? If so, what does not satisfy you in this case?
Re: Conversion of Excel file with empty sheet fails
Thanks for reply.
Excel file converts successfully, If
Reminding you that if i pass 'batchProcessing' to 'ConvertFile' call, it does not give a reply.
Waiting for your kind reply.
Excel file converts successfully, If
- if i pass null in third parameter of following line of code
- There is no empty sheet in the excel file.
Reminding you that if i pass 'batchProcessing' to 'ConvertFile' call, it does not give a reply.
Waiting for your kind reply.
Re: Conversion of Excel file with empty sheet fails
So when you pass null parameter, you get no empty sheets, right? Is it not what you want?ahsan wrote: Excel file converts successfully, If
p2fServer.ConvertFile(inputPath, outputPath, settingProfile, batchProcessing, null);
- if i pass null in third parameter of following line of code
- There is no empty sheet in the excel file.
We also reiterate that SkipEmptySheets property is not documented and you should not use it.
Re: Conversion of Excel file with empty sheet fails
staff wrote: So when you pass null parameter, you get no empty sheets, right? Is it not what you want?
We also reiterate that SkipEmptySheets property is not documented and you should not use it.
- When I pass null parameter and there are empty sheets in excel, It goes unresponsive and give issue of timeout.
When I pass null parameter and there are not sheets in excel, It works fine.
Re: Conversion of Excel file with empty sheet fails
We tried but could not duplicate this problem in our testing environment even with your sample Excel file. During our testing your document was always converted successfully. Which version of MS Excel do you have?
“Before printing timeout" error means that Print2Flash successfully instructed an application (in your case MS Excel) to print the document but the application did not start printing within the time period specified by BeforePrintingTimeout parameter. Print2Flash waits until BeforePrintingTimeout expires and returns that error in this situation. Print2Flash in itself can do nothing about this situation as it is a virtual printer and it cannot convert a document unless an application sends a printing job to it. Please see this forum topic for more information: viewtopic.php?f=19&t=5&p=5
“Before printing timeout" error means that Print2Flash successfully instructed an application (in your case MS Excel) to print the document but the application did not start printing within the time period specified by BeforePrintingTimeout parameter. Print2Flash waits until BeforePrintingTimeout expires and returns that error in this situation. Print2Flash in itself can do nothing about this situation as it is a virtual printer and it cannot convert a document unless an application sends a printing job to it. Please see this forum topic for more information: viewtopic.php?f=19&t=5&p=5
Re: Conversion of Excel file with empty sheet fails
Problem:
System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Office Excel cannot access the file 'D:\RadioSQA\NLR\WIP'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.
I found the following solution
Solution:
install suitable Hotfix for MS Excel 2010/2013
• http://support.microsoft.com/kb/2817576
• http://support.microsoft.com/kb/2817505
Then do the following
Create directory "C:\Windows\SysWOW64\config\systemprofile\Desktop " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile\Desktop " (for 32 bit Windows)
System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Office Excel cannot access the file 'D:\RadioSQA\NLR\WIP'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.
I found the following solution
Solution:
install suitable Hotfix for MS Excel 2010/2013
• http://support.microsoft.com/kb/2817576
• http://support.microsoft.com/kb/2817505
Then do the following
Create directory "C:\Windows\SysWOW64\config\systemprofile\Desktop " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile\Desktop " (for 32 bit Windows)