I have a concern regarding the output SVG image which is varying in its size by a margin, even though it’s dependent Named renges in Excel files are almost of the same number of rows and columns. The same concern is regarding the images saved in Excel File.
My Concern is described as follows:
Variation of size (width and height) of the output SVG image out of Image saved in Excel File:
When I have an Image stored in Excel file, with the name as ‘CoverTable_1’, and I m trying to read that image using Aspose.Cells and converting that into SVG image file, it’s size in terms of height and width is varying image by image.
Attaching two Excel files for your reference.
ExcelFile1.zip (685.3 KB)
ExcelFile2.zip (424.5 KB)
and also the c# code to convert the named ranges and images into SVG
AsposeCode.zip (1.5 KB)
The attached file “Copy of Siemens - 4QFY18 - exhibits.xlsx” has image with name ‘CoverTable_1’ and two named ranges ‘Ex_1’ and ‘Ex_2’.
The problem is that, the output SVG image of CoverTable_1 has very small size(in terms of width and height) as compared to the size of the Image ‘CoverTable_1’ in the other Excel file (“UTCEM_2QFY19.xlsx”) attached herewith.
Variation in the size (height and width) of output SVG image out of named ranges of Excel file:
The attached file “Copy of Siemens - 4QFY18 - exhibits.xlsx” has two named ranges “Ex_1” and “Ex_2”. Both have almost the same number of rows and columns. But, when I am using the attached code that uses Aspose.Cells to read the named ranges and convert them into SVG image, they are varying in the size by a margin in terms of height and width.
So, I am expecting the consistent size of all the images, charts and named ranges for the output SVG image (depending upon the size of the relevant images, named ranges and charts in Excel).
To be specific, Ex_2 has the proper readable size and the same I am expecting to be implemented for Ex_1.
Also, CoverTable_1 from “UTCEM_2QFY19.xlsx” has the proper readable size, but CoverTable_1 from “Copy of Siemens - 4QFY18 - exhibits.xlsx” has very small size, which is supposed to be equivalent to the image in Excel.
Kindly, provide me the solution as soon as possible.
Thanks and Regards