Free Support Forum - groupdocs.com

Excel file to PNG

Hi,


We try to convert the excel file to PNG format. We found we can convert the xls file, but we cannot convert xlsx file to PNG.


We got the error message as below

at .(Int32 , )

at . (Int32 , )

at . (Int32 )

at . (Int32 )

at . [T](LoadOptions , SaveOptions )

at GroupDocs.Conversion.Handler.ConversionHandler.[T](String , LoadOptions , SaveOptions )

at GroupDocs.Conversion.Handler.ConversionHandler.Convert[T](String guid, LoadOptions loadOptions, SaveOptions saveOptions)

at GroupDocs.Conversion.Handler.ConversionHandler.Convert[T](String guid, SaveOptions saveOptions)

at GroupDocsPOC.Conversion.ConvertToImageAsPath(String fileName, String inputPath, String outputPath) in D:\GroupDocs\3.0\Conversion for .NET\GroupDocsPOC\GroupDocsPOC\Conversion.cs:line 39

at GroupDocsPOC.Program.Main(String[] args) in D:\GroupDocs\3.0\Conversion for .NET\GroupDocsPOC\GroupDocsPOC\Program.cs:line 74 <o:p></o:p>

Following is the sample code

String licensePath = Path.Combine(Environment.CurrentDirectory, @“GroupDocs.Conversion.lic”);
if (ConfigurationManager.AppSettings[“licensePath”] != null)
{
licensePath = ConfigurationManager.AppSettings[“licensePath”];
}

ConversionConfig conversionConfig = new ConversionConfig { StoragePath = inputPath, OutputPath = outputPath };

conversionConfig.UseCache = false;

ConversionHandler conversionHandler= new ConversionHandler(conversionConfig);

GroupDocs.Conversion.License license = new GroupDocs.Conversion.License();
license.SetLicense(licensePath);


ImageSaveOptions imageSaveOptions = new ImageSaveOptions();
imageSaveOptions.OutputType = OutputType.String;
imageSaveOptions.ConvertFileType = ImageSaveOptions.ImageFileType.Png;
var conversionDocumentPath = conversionHandler.Convert(fileName, imageSaveOptions);


And the sample files have been attached in this post

Hello,

Thank you for giving a try to the GroupDocs.Conversion API.


We have tested this scenario with updated version 3.2.0 and found no issues with XLX and XLSX conversion to PNG Image format.


We can see that you have attached sample excel files which have some unreadable text and cause an exception, if you try to use valid excel documents then there will be no issues in conversion.


We have also attached a sample excel file for testing and also PNG output files.


Please find below some useful resources for GroupDocs.Conversion API.


If you will need any help or you will have any other questions please feel free to ask.


Warm Regards

The issues you have found earlier (filed as CONVERSIONNET-890) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by groupdocs.notifier.

Hi,


Thank you for your reply.

We have found a interesting issue about this.

Case1:
if there are 3 sheets in a xlsx file, sheet 2 and sheet 3 are empty. Sheet 1 has some content. It will fail to convert.

Case2:
If there is a xlsx file includes 1 sheet. And no content in the sheet. It will be fail.

Case 3:
If there is a xlsx file includes 1 sheet. Some words in the sheet. It will be success.

We have tested the version 3.2.0 and 1.10.0.

3.2.0
Case 1 : Fail
Case 2: Fail
Case 3: Fail

1.10.0
Case 1/2/3: Success

Please help to verify this issue. Thank you a lot.

Hello ,

Thank you for your Detailed feedback.
we have successfully reproduced these issues and we are also looking for other scenarios may have.We also notified it to the product team for solution.
Once we have any update from product team we will update you here.

Thank you for your patience.

Warm Regards,

Hi,


Could you provide a date when this issue will be fixed? Thank you!

Hi,

We have notified it to the product team for solution, once we have any update from product team we will update you here.

Thank you for your patience.

Warm Regards,

Hi,


We found another interesting issue.

Please extract the attachment.


Source File: 6.xlsx

Converted by Groupdocs 1.8.x:
- Sheet 1 --> 60.PNG (Should as “1.PNG”)
- Sheet 3 --> 61.PNG (Should separate to 4 PNG files)


We also tested on version 3.2.0. It’s the same situation…

Hi Beary ,


Thank you for sharing your findings with us. we are working on it and other similar issues as well. We will come back to you as soon as soon as we get any updates from our product team regarding your findings and issue.

Thank you for your patience.


Warm Regards,