Sheet to image

Aspose.Cells Product Family
41

It works perfectly, many thanks once more!

Cruz

42

Hi again… found another issue… notice the cells marked with shrink to fit and no wrap text and their result in the image.

Please try this code with the attached files:

Workbook book = new Workbook();
book.Open(“c:\test.xls”);
book.Worksheets[0].SheetToImage(“c:\test.emf”, System.Drawing.Imaging.ImageFormat.Emf);

Thanks again,
Cruz

43

Hi,

Thanks for the template files,

We found the issue and will figure it out.

Thank you.

44

Hi there,

I’d like to know if you have any timings on this issue.

Keep up the good work.
Cruz

45

Hi Cruz,

Thanks for following up.

Hopefully, we can provide a fix soon.

Thank you.

46

Hi Cruz,

Thanks for your patience.

Please try this fix.

And this fix also support to sort the data from left to right.

47

I think I tried all the workarounds in this thread, but still SheetToImage() Returns Nothing and if I use any of the other functions to save directly to a file it throws a NULL pointer exception.

I tried setting PrintArea but that didn’t work

We are creating a Worksheet with many Merged cell, both rows and columns. Also we have a lot of formatted and vertical text.

I can’t publish a sample on the public forum, but if you give me an email address and I send you an example XLS.

We generate the worksheet on-the-fly, so hopefully the XLS will give the same problems as the on-the-fly worksheet.

Is there anything else I need to set?

I am using version 4.5.0.0 of Cells and VS2008.

48

Dear John,

You can send Email to Aspose Staff Members using Forums too. With any post made by any user, you can see many buttons on the post. Find Contact button and click it. Then select Send an email option and then you can send email to that user directly. You can even attach file with your email. Just make sure that you are emailing to the right user.

I hope, it would help.

Have a good time.

49

Hi John,

Yes please, as Salman suggested you can directly mail me with your template file as an attachment. We will check and try to figure out your issue soon.

Thank you.

50

Hi John,

We have received your template file,
We found the issue after an initial test, we will figure it out soon.
Thank you.
51

Hi,

Please try this fix.

We have fixed the bug of null pointer exception.

We have supported to export the picture to image in Sheet2Image.

There is still a bug in Cell "I21" and "I24".We are looking into this issue if the rotation is 90 .

52

Hi there,

I detected an issue with the SheetToImage method that is related to the ShrinkToFit property of the cells.

Please regard the sample files attached.

Thanks in advance,
Cruz

53

Hi Cruz,

Thanks for providing us the template file with output image file.

We found the issue after an initial test, we will figure it out soon.

Thank you.

54

Hi there, I was wondering if you have any updates for this issue.

Cruz

55

Hi Cruz,

Sorry for a bit delay,

We will get back to you soon.

Thank you.

56

Hi Cruz,

Please try this fix.

57

Hi there,

Yes, the shrink to fit is fixed but now the tables have a strange format. Please regard the attached files and run this code:

Workbook book = new Workbook();
book.Open(“c:\test.xls”);
book.Worksheets[0].SheetToImage(“c:\test.emf”, System.Drawing.Imaging.ImageFormat.Emf);

Thanks again,
Cruz

58

Hi Cruz,

Thanks for providing us the template file.

Yes, we found some formattng issues in the generated image. Hopefully, we will look into it in the next week because most of us (developers) are on holidays for their National Day celebrations.

Thanks for your time and understanding.

59

Hi there,



Do you already have any feedback for this issue?



Thanks,

Cruz

60

Hi Cruz,

We have evaluated your issue and will update you soon.

Thanks for your patience.