We are trying to render an Excel file in a web application using the Aspose.Cells viewer. When there is a chart along with textual data, Aspose.Cells does not render the chart in some of our Excel files. I tried your demo app as well @ View Excel Files Free Online. It also does the same (does not render the chart). I have attached the file for reference
excel with single img .zip (1.0 MB)
It seems that you are experiencing issues with the Aspose.Cells viewer not rendering charts in your Excel files. This can happen for various reasons, including the specific features used in the Excel file or limitations in the viewer itself.
To troubleshoot this issue, consider the following steps:
-
Check Chart Compatibility: Ensure that the charts in your Excel file are compatible with the Aspose.Cells viewer. Some complex chart types or features may not be fully supported.
-
Update Aspose.Cells: Make sure you are using the latest version of Aspose.Cells. Updates often include bug fixes and improvements that could resolve rendering issues.
-
Test with Different Files: Try rendering other Excel files with charts to see if the issue is specific to the file you are using. This can help determine if the problem lies with the file itself or the viewer.
-
Review Documentation: Check the Aspose.Cells documentation for any notes on chart rendering limitations or specific requirements that need to be met for charts to display correctly.
-
Contact Support: If the issue persists, consider reaching out to Aspose support with your specific file and details about the charts that are not rendering. They may provide insights or solutions tailored to your situation.
If you have a specific chart type or feature in your Excel file that you suspect might be causing the issue, please provide more details, and I can assist you further.
For more information on rendering charts with Aspose.Cells, you can refer to the official documentation here.
If you have any other questions or need further assistance, feel free to ask!
I am attaching one more file where rendering of images inside an Excel does not happen. Please take a look and let us know what is wrong here as well.
Thanks,
Arvinth
excel with diff imgage.zip (9.5 MB)
I tested your scenario/case using both your Excel files with latest version of Aspose.Cells for .NET v24.12 and it works fine. Aspose.Cells does render worksheet to image with all the data, binary objects and images just fine. I used the following sample code using your template Excel files.
e.g.,
Sample code:
//string excelFilePath = "e:\\test2\\excel with single img .xlsx";//first Excel file
string excelFilePath = "e:\\test2\\excel with diff imgage.xlsx";//second Excel file
// Load the Excel file
Workbook workbook = new Workbook(excelFilePath);
// Get the first worksheet (you can modify the index as needed)
Worksheet worksheet = workbook.Worksheets[0];
// Set the image options to export the chart as EMF
ImageOrPrintOptions options = new ImageOrPrintOptions
{
ImageType = ImageType.Png,
OnePagePerSheet = true
};
options.OnePagePerSheet = true;
SheetRender sr = new SheetRender(worksheet, options);
//sr.ToImage(0, "e:\\test2\\sheet_out1.png");//for first Excel file
sr.ToImage(0, "e:\\test2\\sheet_out2.png");//for second Excel file
Please find attached the output images for both files for your reference.
sheet_out1.png (13.6 KB)
sheet_out2.png (105.4 KB)
Do you use Aspose.Excel viewer to view the Excel files or are you using Aspose.Cells for .NET APIs to render worksheet or chart to images? If you are using Aspose.Cells for .NET APIs, kindly do share your code snippet that you are using. We will check and fix your code accordingly.
You need to only use Aspose Excel viewer app for viewing the Excel files? After your confirmation, we will move your thread to respective forum where the relevant team evaluate your issue and fix it.
We want our users to have an interactive Excel like experience (like expanding column width, searching and highlighting). we use Aspose.Cells Viewer
I have moved the thread to respective category. Hopefully your issue will be addressed by concerned team soon.
Just to be more clear, I am using Aspose.Cells Viewer. I tried Aspose’s excel viewer online to open both of my Excels and was not able to see charts/images in my files that I have attached above
@arvinthc
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSAPP-4151
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.