Loading and managing Excel, OpenOffice, Json, Csv and Html files
Contents
[
Hide
]
With Aspose.Cells, it is simple to create, open, and manage Excel files, for example, to retrieve data, or to use a designer template to speed up the development process.
Creating a New Workbook
The following example creates a new workbook from scratch.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells Example - Create Workbook and Set Cell Value</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Create Workbook</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 } = AsposeCells;
AsposeCells.onReady({
license: "/lic/Aspose.Cells.lic",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
// Instantiate a Workbook object (new blank workbook)
const wb = new Workbook();
// Access the first worksheet in the workbook
const sheet = wb.worksheets.get(0);
// Access the "A1" cell in the sheet
const cell = sheet.cells.get("A1");
// Input the "Hello World!" text into the "A1" cell
cell.value = "Hello World!";
// Save the Excel file and prepare download link
const outputData = wb.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'MyBook_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Workbook created and cell updated. Click the download link to get the modified file.</p>';
});
</script>
</html>
Opening and saving a File
With Aspose.Cells, it is simple to open, save and manage Excel files.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells 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 } = 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 file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Creating a Workbook object and opening an Excel file using its file stream
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Adding new sheet
const sheetIndex = workbook.worksheets.add("MySheet");
const sheet = workbook.worksheets.get(sheetIndex);
// Setting active sheet
workbook.worksheets.activeSheetIndex = 1;
// Setting values.
const cells = sheet.cells;
// Setting text
cells.get("A1").putValue("Hello!");
// Setting number
cells.get("A2").putValue(1000);
// Setting Date Time
const cell = cells.get("A3");
cell.putValue(new Date());
const style = cell.style;
style.number = 14;
cell.style = style;
// Setting formula
cells.get("A4").formula = "=SUM(A1:A3)";
// Saving the workbook and providing download link
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'dest.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Operation completed successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
Advanced Topics
- Different Ways to Open Files
- Filter Defined Names while loading Workbook
- Filter Objects while loading Workbook or Worksheet
- Filtering the kind of data while loading the workbook from template file
- Get Warnings while Loading Excel File
- Load Source Excel File Without Charts
- Load Specific Worksheets in a Workbook
- Load Workbook with specified Printer Paper Size
- Opening Different Microsoft Excel Versions Files
- Opening Files with Different Formats
- Optimizing Memory Usage while Working with Big Files having Large Datasets
- Read Numbers Spreadsheet Developed by Apple Inc. using Aspose.Cells
- Stop conversion or loading using InterruptMonitor when it is taking too long
- Using LightCells API
- Convert CSV to JSON
- Convert Excel to JSON
- Convert JSON to CSV
- Convert JSON to Excel
- Convert Excel to Html