Expanding text from right to left while exporting Excel file to HTML with JavaScript via C++
Contents
[
Hide
]
Aspose.Cells now supports expanding text from right to left while exporting Excel file to HTML. This feature has been implemented since the v8.9.0.0. Now if your source excel file contains any text which expands from right to left, then Aspose.Cells will export it to HTML correctly.
Expanding text from right to left while exporting Excel file to HTML
The following sample code converts the sample excel file into HTML. This screenshot shows how the sample excel looks like in Microsoft Excel 2013.
This screenshot shows the output HTML generated with older version.
This screenshot shows the output HTML generated with newer version.
As you can see in the screenshots, the newer version expands the right-aligned text to left correctly just like Microsoft Excel.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Expand Text From Right To Left 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, CellsHelper } = 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();
// Load source excel file inside the workbook object
const wb = new Workbook(new Uint8Array(arrayBuffer));
// Get CellsHelper version (converted from getVersion())
const version = CellsHelper.version;
// Save workbook in html format
const outputData = wb.save(SaveFormat.Html);
const blob = new Blob([outputData], { type: 'text/html' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = `ExpandTextFromRightToLeft_out_${version}.html`;
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download HTML File';
resultDiv.innerHTML = '<p style="color: green;">Workbook converted to HTML successfully. Click the download link to get the result.</p>';
});
</script>
</html>