I use Workbook book = new Workbook(path); to open an existing Excel file.
I use book.Save(outpath); to save with the extension changed from xslx to pdf.
This results in a PDF file always on my dev machine, and fine in production until the Excel file contains images.
Then in DEV it works, and in PROD it throws an exception : “Shape to Image Error”.
I suspect it may be having access issues to some folder where it wants to write temporary files.
Can you tell me where it writes temp files and if I can change that ?
I guess you might not be using the same Aspose.Cells for .NET version on both environments (DEV and PROD). Please make sure that you are using same version (as per DEV) on PROD. On a safer side, kindly print out the version by adding a line to your code segment:
e.g Sample code:
Apparently it does not write any template file when rendering to PDF. Anyways, you should also make sure that you are running your application in full trust permissions set, see the document for your reference:
The DLLS are both 17.3.0.0
Its not running in an ASP .NET server its running as an Azure Web Job.
There’s plenty of disk available and the file isn’t that large,
Is there some way to diagnose this ?
I have a test project and file that demonstrates the issue.
To get it to fail you’ll need to set up an Azure Web Job to host it.
That requires an Azure App Service and a storage account.
You;ll need to edit the app.config file to point to your storage account, get a publish profile for your App Service and then publish the project as a Web Job using your publish profile.
At that point you can just run the WebJob from the Azure console and see the job succeeded since the code is catching the exception, but it will display the 'Shape to Image; exception in the Web Job Log files,
Project File Link : https://1drv.ms/u/s!AnyvjDo8SqXza-KxVd7R_C5MF54
Well, you may zip the text file or other file format and then upload in the forums. Anyways, thanks for the log file contents. This will help us to evaluate your issue precisely.
I have logged the results and findings against your issue “CELLSNET-45704” into our database. Our concerned developer from product team will evaluate your issue further soon.
Please try executing the following lines of code on Azure and check that the file ‘Result.emf’ is correct:
e.g Sample code:
RectangleF dstRectF = new RectangleF(0, 0, 673f, 360f);
Bitmap dummyBitmap = new Bitmap(1, 1);
Graphics dummyGfx = Graphics.FromImage(dummyBitmap);
hdc = dummyGfx.GetHdc();
MemoryStream msOut = new MemoryStream();
Metafile metafile = new Metafile(msOut, hdc, dstRectF, MetafileFrameUnit.Pixel, EmfType.EmfPlusDual);
Graphics g = Graphics.FromImage(metafile);
byte[] Data = SaveImage(path +"\\image1.emf");
Stream Ms = new MemoryStream(Data);
Image Ima = Image.FromStream(Ms,true);
g.DrawImage(Ima, dstRectF);
g.Dispose();
msOut.Seek(0, SeekOrigin.Begin);
Image img = Image.FromStream(msOut);
img.Save(path + "\\Result.emf", ImageFormat.Emf); //or img.Save(path + "\\Result.png", ImageFormat.Png);
Note: ‘image1.emf’ is the picture in Excel.
If no error is occurred. Please provide two files that you generated in debug run and network job(4k\151bytes).
We will check if we could provide you the exact lines of code written in “SaveImage” custom method, so you may compile the code segment seamlessly. But, the underlying method only gets the image file into byte array, so you may easily replace the following line with your own code to read the contents of the image file into array of bytes by yourself:
That might be the reason it fails for image/shape rendering. I have logged your log contents and findings against your issue “CELLSNET-45704” into our database. Our concerned developer from product team will evaluate it further and we will get back to you soon.
Well, Metafile(e.g. emf, wmf) images are widely used in Microsoft Excel. A solution is that we can add an option to let you set to draw metafile to bitmap, but this may cause the output image a little blurred in the output PDF.
Could you try to check whether the following code works on your Azure web job:
e.g Sample code:
using (Image srcImage = Image.FromFile("image1.emf"))
{
using (Bitmap destImage = new Bitmap(srcImage.Width, srcImage.Height))
{
destImage.SetResolution(srcImage.HorizontalResolution, srcImage.VerticalResolution);
using (Graphics g = Graphics.FromImage(destImage))
{
g.DrawImage(srcImage, new RectangleF(0, 0, srcImage.Width, srcImage.Height));
}
using (MemoryStream ms = new MemoryStream())
{
destImage.Save(ms, ImageFormat.Png);
//test save to file
using (FileStream fs = new FileStream("imageOut.png", FileMode.Create))
{
byte[] imageData = ms.ToArray();
fs.Write(imageData, 0, imageData.Length);
}
}
}
}
if the code works and you accept the solution, we will add an option for you.
Please note, “image1.emf” is extracted from your Excel file. image1.zip (21.1 KB)