Read Chart Subtitle from ODS File using JavaScript via C++
Contents
[
Hide
]
Read Chart Subtitle from ODS File
Aspose.Cells provides you with the ability to read chart subtitles in ODS files by using the Chart.subTitle property. The following sample code loads the sample ODS file and reads the chart subtitle using the Chart.subTitle property and prints it in the Console Window. Please see the console output of the code given below for reference.
Sample Code
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Get Chart Subtitle</title>
</head>
<body>
<h1>Get Chart Subtitle Example</h1>
<input type="file" id="fileInput" accept=".ods,.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, 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');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel or ODS file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Accessing the first worksheet in the workbook
const worksheet = workbook.worksheets.get(0);
// Accessing the first chart inside the worksheet
const chart = worksheet.charts.get(0);
// Accessing chart subtitle text (converted from getSubTitle().getText())
const subtitleText = chart.subTitle.text;
console.log("Chart Subtitle: " + subtitleText);
document.getElementById('result').innerHTML = '<p>Chart Subtitle: ' + (subtitleText ?? '') + '</p>';
});
</script>
</html>
Console Output
Chart Subtitle: Sample Chart Subtitle