Aspose cells : Unable to see the xlsx file that contains charts

Aspose.Cells Product Family
1

Hi Team ,
I am unable to see the charts file in the viewer.
Please find the attachment.
charts.zip (16.6 KB)

2

@sarathepiq

Cause

The charts in your XLSX file are not being displayed in the viewer. This issue could arise from several factors, including the viewer’s lack of support for certain chart types, problems with the file format, or potential corruption within the file.

Solution

To troubleshoot this issue, please follow these steps:

  1. Check Chart Types: Verify that the charts you are using are supported by the viewer. Some viewers may not support advanced chart types.

  2. Open in Excel: Open the XLSX file in Microsoft Excel to confirm that the charts are displayed correctly there. If they are not visible in Excel, the issue may be with the file itself.

  3. Recreate Charts: If the charts are not displaying correctly in Excel, consider recreating them. Charts can sometimes become corrupted, and starting fresh may resolve the issue.

  4. Update Viewer: Ensure that you are using the latest version of the viewer. Updates often include bug fixes and improvements that could resolve display issues.

  5. Test with a Simple File: Create a new simple XLSX file with a basic chart and check if it displays correctly in the viewer. This can help determine if the issue is specific to your original file.

Code

If you need to create a simple chart programmatically, here’s a basic example using Aspose.Cells:

// Create a new workbook
Workbook workbook = new Workbook();
// Add a new worksheet
int sheetIndex = workbook.Worksheets.Add();
// Get the worksheet
Worksheet worksheet = workbook.Worksheets[sheetIndex];

// Add sample data
worksheet.Cells["A1"].PutValue("Category");
worksheet.Cells["B1"].PutValue("Value");
worksheet.Cells["A2"].PutValue("A");
worksheet.Cells["B2"].PutValue(10);
worksheet.Cells["A3"].PutValue("B");
worksheet.Cells["B3"].PutValue(20);

// Add a chart
int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 5);
Chart chart = worksheet.Charts[chartIndex];
chart.NSeries.Add("B2:B3", true);
chart.NSeries.CategoryData = "A2:A3";

// Save the workbook
workbook.Save("SimpleChart.xlsx");

Next Steps

Please try the above solutions to see if they resolve the issue with your charts not displaying. If the problem persists, provide more details about the specific chart types you are using and any error messages you encounter.

I look forward to your update!

3

@sarathepiq
Since the chart you created has no associated data, what you see is a blank chart. Please add data first, then right-click on the chart and select Data. The data will be presented in the chart. Of course, you can also change the style to meet your own needs. Please refer to the attachment. chart xlsx.zip (17.7 KB)

4

Can’t we add empty charts?

5

@sarathepiq,

Sure, you can do. When you want to create a new blank chart, just add the chart (type) but don’t set data (source). See the sample code below for your reference.
e.g.,
Sample code:

// Create a new workbook
Workbook workbook = new Workbook();

// Add a new worksheet
int sheetIndex = workbook.Worksheets.Add();
// Get the worksheet
Worksheet worksheet = workbook.Worksheets[sheetIndex];
// Add a blank chart
int chartIndex = worksheet.Charts.Add(ChartType.LineWithDataMarkers, 5, 0, 15, 5);
Chart chart = worksheet.Charts[chartIndex];
// Save the workbook
workbook.Save("e:\\test2\\blankchart1.xlsx");