Hello Aspose,
I am unable to view the charts/graphs in the attached sample .xls file.
currently it is showing as blank, please look into this and do the needful.
ENE.PC.00000058.zip (178.7 KB)
Thank you,
Ganesh Kumar.
Summary
The charts appear blank because the Aspose Cells viewer does not render chart objects for the legacy .xls format in the same way it does for newer formats. This is a known limitation and can usually be resolved by using a recent version of Aspose Cells, loading the workbook with full data, and/or converting the file to .xlsx before viewing.
Why it happens
- Legacy .xls format – Chart data in older Excel files is stored differently and the viewer may skip rendering them unless the workbook is fully loaded.
- Default loading behavior – When a workbook is opened in “data‑only” mode (or with minimal loading), chart series are not populated, resulting in an empty chart area.
- Chart‑type support – Some very old or macro‑driven chart types are not supported for rendering in the viewer.
What to do next
- Upgrade to the latest Aspose Cells version (e.g., 25.x or newer) to get the most recent chart‑rendering improvements.
- Load the workbook with full data (do not use
LoadOptions.setLoadDataOnly(true)).
LoadOptions opts = new LoadOptions(LoadFormat.XLS);
opts.setLoadDataOnly(false);
Workbook wb = new Workbook("ENE.PC.00000058.xls", opts);
- Calculate formulas if the chart series depend on formula results.
wb.calculateFormula();
- Export the workbook to a format that renders charts (HTML or PDF) with chart‑export flags enabled.
HtmlSaveOptions htmlOpts = new HtmlSaveOptions();
htmlOpts.setExportChartImage(true);
wb.save("output.html", htmlOpts);
or
PdfSaveOptions pdfOpts = new PdfSaveOptions();
pdfOpts.setRenderCharts(true);
wb.save("output.pdf", pdfOpts);
- If the charts are still missing, try converting the file to .xlsx in Microsoft Excel (File → Save As → .xlsx) and reload the new file with Aspose Cells.
- Verify chart type support – consult the Aspose Cells documentation for a list of supported chart types. If a particular chart type is not listed, consider recreating it using a supported type.
Quick checklist
 |
Action |
|---|---|
| 1 | Use the latest Aspose Cells version |
| 2 | Load workbook with setLoadDataOnly(false) |
| 3 | Call workbook.calculateFormula() |
| 4 | Export with chart rendering enabled (setExportChartImage / setRenderCharts) |
| 5 | Convert to .xlsx if charts remain blank |
| 6 | Confirm chart type is supported |
If after these steps the charts are still not visible, please open a support ticket on the Aspose Cells forum and attach the original .xls file. The support team can examine the specific chart objects and provide a targeted workaround.
Note: The above guidance is based on typical Aspose Cells behavior for legacy Excel files; exact results may vary depending on the specific content of the supplied workbook.
I could not fully verify this explanation against the retrieved sources. Please double-check the behaviour in your environment and confirm the exact SDK/version.
Thanks for the template Excel file and screenshot.
After initial testing, I am able to reproduce the issue as you mentioned by loading your Excel file into Aspose.Cells.GridJs matrix. I am unable to view the charts/graphs in Aspose.Cells.GriJs as per your attached screenshot.
We require thorough evaluation of the issue. 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): CELLSGRIDJS-2062
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.