Inserire lo slicer
Contents
[
Hide
]
Possibili Scenari di Utilizzo
Una taglierina viene usata per filtrare i dati rapidamente. Può essere usata per filtrare i dati sia in una tabella che in una tabella pivot. Microsoft Excel permette di creare una taglierina selezionando una tabella o tabella pivot e cliccando quindi su Inserisci > Taglierina. Aspose.Cells for JavaScript tramite C++ consente anche di creare la taglierina usando il metodo Worksheet.slicers.add().
Creare un selettore per una tabella pivot
Vedi il seguente esempio di codice. Carica il file Excel di esempio (sample Excel file) che contiene la tabella pivot. Poi crea la taglierina basata sul primo campo pivot di base. Infine, salva il workbook nei formati output XLSX e output XLSB. La schermata seguente mostra la taglierina creata da Aspose.Cells for JavaScript tramite C++ nel file Excel di output.
Codice di Esempio
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Create Slicer to PivotTable</title>
</head>
<body>
<h1>Create Slicer to PivotTable Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.xlsb,.csv" />
<button id="runExample">Run Example</button>
<br/><br/>
<a id="downloadXlsxLink" style="display: none;">Download XLSX Result</a>
<br/>
<a id="downloadXlsbLink" style="display: none;">Download XLSB 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 (e.g., sampleCreateSlicerToPivotTable.xlsx).</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object from the uploaded file
const wb = new Workbook(new Uint8Array(arrayBuffer));
// Access first worksheet.
const ws = wb.worksheets.get(0);
// Access first pivot table inside the worksheet.
const pt = ws.pivotTables.get(0);
// Add slicer relating to pivot table with first base field at cell B22.
const idx = ws.slicers.add(pt, "B22", pt.baseFields.get(0));
// Access the newly added slicer from slicer collection.
const slicer = ws.slicers.get(idx);
// Save the workbook in output XLSX format.
const outputDataXlsx = wb.save(SaveFormat.Xlsx);
const blobXlsx = new Blob([outputDataXlsx]);
const downloadXlsxLink = document.getElementById('downloadXlsxLink');
downloadXlsxLink.href = URL.createObjectURL(blobXlsx);
downloadXlsxLink.download = 'outputCreateSlicerToPivotTable.xlsx';
downloadXlsxLink.style.display = 'inline';
downloadXlsxLink.textContent = 'Download outputCreateSlicerToPivotTable.xlsx';
// Save the workbook in output XLSB format.
const outputDataXlsb = wb.save(SaveFormat.Xlsb);
const blobXlsb = new Blob([outputDataXlsb]);
const downloadXlsbLink = document.getElementById('downloadXlsbLink');
downloadXlsbLink.href = URL.createObjectURL(blobXlsb);
downloadXlsbLink.download = 'outputCreateSlicerToPivotTable.xlsb';
downloadXlsbLink.style.display = 'inline';
downloadXlsbLink.textContent = 'Download outputCreateSlicerToPivotTable.xlsb';
document.getElementById('result').innerHTML = '<p style="color: green;">Slicer created and files are ready for download.</p>';
});
</script>
</html>
Creare un selettore per tabella di Excel
Si prega di vedere il seguente codice di esempio. Carica il file Excel di esempio che contiene una tabella. Crea quindi lo slicer in base alla prima colonna. Infine, salva il libro di lavoro nel formato XLSX di output.
Codice di Esempio
<!DOCTYPE html>
<html>
<head>
<title>Create Slicer to Excel Table Example</title>
</head>
<body>
<h1>Create Slicer to Excel Table 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 } = AsposeCells;
let asposeReady = false;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
asposeReady = true;
});
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;
}
if (!asposeReady) {
document.getElementById('result').innerHTML = '<p style="color: red;">Aspose.Cells is not initialized yet. Please wait and try again.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object by opening the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access first worksheet.
const worksheet = workbook.worksheets.get(0);
// Access first table inside the worksheet.
const table = worksheet.listObjects.get(0);
// Add slicer
const idx = worksheet.slicers.add(table, 0, "H5");
// Saving the modified Excel file
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'outputCreateSlicerToExcelTable.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Slicer added successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>