Change Tick Label Direction with JavaScript via C++
Contents
[
Hide
]
Change Tick Label Direction
Aspose.Cells provides you with the ability to change the chart tick label direction by using the TickLabels.directionType property. The TickLabels.directionType property accepts the ChartTextDirectionType enumeration value. The ChartTextDirectionType enumeration provides the following members:
- Horizontal
- Vertical
- Rotate90
- Rotate270
- Stacked
The following image compares the source and output files
Source file image
Output file image
The following code snippet changes the tick label direction from Rotate90 to Horizontal.
Sample Code
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Change Tick Label Direction Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;"></a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, ChartTextDirectionType } = 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 result = document.getElementById('result');
if (!fileInput.files.length) {
result.innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
const workbook = new Workbook(new Uint8Array(arrayBuffer));
const worksheet = workbook.worksheets.get(0);
const chart = worksheet.charts.get(0);
chart.categoryAxis.tickLabels.directionType = ChartTextDirectionType.Horizontal;
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'outputChangeChartDataLableDirection.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
result.innerHTML = '<p style="color: green;">Tick label direction changed. Click the download link to get the modified file.</p>';
});
</script>
</html>
The source and output files can be downloaded from the following links.