Determine which Axis exists in the Chart with JavaScript via C++
Contents
[
Hide
]
Sometimes, the user needs to know if a particular axis exists in the Chart. For example, they want to know if a Secondary Value Axis exists inside the chart or not. Some charts like Pie, PieExploded, PiePie, PieBar, Pie3D, Pie3DExploded, Doughnut, DoughnutExploded, etc. do not have an axis.
Aspose.Cells provides Chart.hasAxis(axisType, isPrimary) method to determine if the chart has a particular axis or not.
The following sample code demonstrates the use of Chart.hasAxis(axisType, isPrimary) to determine if the sample chart has Primary and Secondary Category and Value Axis.
JavaScript code to determine which axis exists in the chart
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Check Chart Axes Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, Worksheet, Cell, Utils } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
const fileInput = document.getElementById('fileInput');
const resultDiv = document.getElementById('result');
if (!fileInput.files.length) {
resultDiv.innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Create workbook object from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access the first worksheet
const worksheet = workbook.worksheets.get(0);
// Check if there are any charts before accessing
const charts = worksheet.charts;
if (charts.count === 0) {
resultDiv.innerHTML = '<p>No charts found in the worksheet.</p>';
return;
}
// Access the chart
const chart = charts.get(0);
// Determine which axis exists in chart
let outputs = [];
let ret = chart.hasAxis(AsposeCells.AxisType.Category, true);
outputs.push("Has Primary Category Axis: " + ret);
ret = chart.hasAxis(AsposeCells.AxisType.Category, false);
outputs.push("Has Secondary Category Axis: " + ret);
ret = chart.hasAxis(AsposeCells.AxisType.Value, true);
outputs.push("Has Primary Value Axis: " + ret);
ret = chart.hasAxis(AsposeCells.AxisType.Value, false);
outputs.push("Has Secondary Value Axis: " + ret);
resultDiv.innerHTML = '<p>' + outputs.join('</p><p>') + '</p>';
});
</script>
</html>
Console output generated by the sample code
The console output of the code is shown below, which displays true for Primary Category and Value Axis and false for Secondary Category and Value Axis.
Has Primary Category Axis: True
Has Secondary Category Axis: False
Has Primary Value Axis: True
Has Secondary Value Axis: False