Page 2 of 2

Re: Conversion of Excel file with empty sheet fails

Posted: Fri Dec 06, 2013 9:46 am
by ahsan
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.

Re: Conversion of Excel file with empty sheet fails

Posted: Fri Dec 06, 2013 9:58 am
by staff
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?

Re: Conversion of Excel file with empty sheet fails

Posted: Mon Dec 09, 2013 2:21 am
by ahsan
Thanks for reply.

Excel file converts successfully, If
  • if i pass null in third parameter of following line of code
p2fServer.ConvertFile(inputPath, outputPath, settingProfile, batchProcessing, null);
  • There is no empty sheet in the excel file.
But i have to set 'SkipEmptySheets' to 'true' to skip empty sheets.

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

Posted: Mon Dec 09, 2013 3:08 am
by staff
ahsan wrote: Excel file converts successfully, If
  • if i pass null in third parameter of following line of code
p2fServer.ConvertFile(inputPath, outputPath, settingProfile, batchProcessing, null);
  • There is no empty sheet in the excel file.
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.

Re: Conversion of Excel file with empty sheet fails

Posted: Mon Dec 09, 2013 4:38 am
by ahsan
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

Posted: Mon Dec 09, 2013 5:27 am
by staff
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

Re: Conversion of Excel file with empty sheet fails

Posted: Tue Dec 10, 2013 2:58 am
by ahsan
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)