Converti Excel in Pdf, immagine e altri formati
Contents
[
Hide
]
Aspose.Cells supporta la conversione tra molti formati. Tecnicamente, la conversione significa caricare una cartella di lavoro in un formato di file e salvarla in un altro.
Converti il foglio di lavoro di Excel in PDF
I file PDF sono ampiamente utilizzati per lo scambio di documenti tra organizzazioni, settori governativi e individui. È un formato di documento standard e spesso agli sviluppatori software viene chiesto di trovare un modo per convertire i file Microsoft Excel in documenti PDF.
Aspose.Cells supporta la conversione di file Excel in PDF e mantiene un’elevata fedeltà visiva nella conversione.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Save As PDF Example</title>
</head>
<body>
<h1>Save Excel as PDF Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to PDF</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.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();
// Instantiating a Workbook object by opening the Excel file through the file stream
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save the document in PDF format
const outputData = workbook.save(SaveFormat.Pdf);
const blob = new Blob([outputData], { type: 'application/pdf' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output.pdf';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download PDF File';
resultDiv.innerHTML = '<p style="color: green;">Conversion completed successfully! Click the download link to get the PDF file.</p>';
});
</script>
</html>
Converti cartella di lavoro Excel in JPG
Aspose.Cells supporta la conversione di file Excel in JPG. L’esempio di codice sotto mostra come salvare un workbook come JPG.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Convert Workbook to JPG Example</title>
</head>
<body>
<h1>Convert Workbook to JPG Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to JPG</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.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();
// Instantiate Workbook from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Convert workbook to JPG image
const outputData = workbook.save(SaveFormat.Jpeg);
const blob = new Blob([outputData], { type: 'image/jpeg' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'Image1.jpg';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download JPG Image';
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed. Click the download link to get the JPG image.</p>';
});
</script>
</html>
Converti cartella di lavoro Excel in immagine
Aspose.Cells supporta la conversione di file Excel in immagini. L’esempio di codice sottostante mostra come salvare un workbook come immagini.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells: Convert Workbook to Images</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to Images</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
<div id="downloads"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat } = 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;
}
document.getElementById('result').innerHTML = '<p>Converting workbook to images...</p>';
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiating a Workbook object from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Define desired image formats
const formats = [
{ fmt: SaveFormat.Bmp, name: 'Image1.bmp', mime: 'image/bmp' },
{ fmt: SaveFormat.Jpeg, name: 'Image1.jpg', mime: 'image/jpeg' },
{ fmt: SaveFormat.Png, name: 'Image1.png', mime: 'image/png' },
{ fmt: SaveFormat.Emf, name: 'Image1.emf', mime: 'image/emf' },
{ fmt: SaveFormat.Gif, name: 'Image1.gif', mime: 'image/gif' }
];
const downloadsDiv = document.getElementById('downloads');
downloadsDiv.innerHTML = '';
// Convert and create download links for each image format
for (const f of formats) {
const outputData = workbook.save(f.fmt);
const blob = new Blob([outputData], { type: f.mime });
const url = URL.createObjectURL(blob);
const a = document.createElement('a');
a.href = url;
a.download = f.name;
a.textContent = 'Download ' + f.name;
a.style.display = 'block';
downloadsDiv.appendChild(a);
}
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed. Click the links below to download the images.</p>';
});
</script>
</html>
Conversione della cartella di lavoro Excel in XPS
Il formato del documento XPS consiste in markup XML strutturato che definisce la disposizione di un documento e l’aspetto visuale di ogni pagina, insieme alle regole di rendering per distribuire, archiviare, rendere, elaborare e stampare documenti.
Il linguaggio di markup per XPS è un sottoinsieme di XAML che consente di incorporare elementi grafici vettoriali nei documenti, utilizzando XAML per contrassegnare i primitivi della Windows Presentation Foundation (WPF). Gli elementi utilizzati sono descritti in termini di percorsi e altri primitivi geometrici.
Un file XPS è, in realtà, un archivio ZIP unicode utilizzando le Convenzioni per l’Imballaggio Aperto, contenente i file che compongono il documento. Questi includono un file di markup XML per ogni pagina, testo, font integrati, immagini raster, grafica vettoriale 2D, nonché le informazioni sulla gestione dei diritti digitali. Il contenuto di un file XPS può essere esaminato semplicemente aprendolo in un’applicazione che supporta file ZIP.
A partire da Aspose.Cells 6.0.0, è supportata la conversione di Microsoft Excel in XPS.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Render to XPS</title>
</head>
<body>
<h1>Render Worksheet / Workbook to XPS</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx" />
<button id="runExample">Run Example</button>
<div>
<a id="downloadLinkSheet" style="display: none; margin-right: 10px;">Download Sheet XPS</a>
<a id="downloadLinkWorkbook" style="display: none;">Download Workbook XPS</a>
</div>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, XpsSaveOptions, SheetSet } = 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');
const downloadLinkSheet = document.getElementById('downloadLinkSheet');
const downloadLinkWorkbook = document.getElementById('downloadLinkWorkbook');
if (!fileInput.files.length) {
resultDiv.innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
// Read file from input
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Open workbook from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get the first worksheet
const sheet = workbook.worksheets.get(0);
// Render the sheet to XPS
const options = new XpsSaveOptions();
const sheetSet = new SheetSet([sheet.index]);
options.sheetSet = sheetSet;
const outputDataSheet = workbook.save(SaveFormat.Xps, options);
const blobSheet = new Blob([outputDataSheet], { type: 'application/vnd.ms-xps' });
downloadLinkSheet.href = URL.createObjectURL(blobSheet);
downloadLinkSheet.download = 'out_printingxps.out.xps';
downloadLinkSheet.style.display = 'inline-block';
downloadLinkSheet.textContent = 'Download Sheet XPS';
// Export the whole workbook to XPS
const outputDataWorkbook = workbook.save(SaveFormat.Xps, new XpsSaveOptions());
const blobWorkbook = new Blob([outputDataWorkbook], { type: 'application/vnd.ms-xps' });
downloadLinkWorkbook.href = URL.createObjectURL(blobWorkbook);
downloadLinkWorkbook.download = 'out_whole_printingxps.out.xps';
downloadLinkWorkbook.style.display = 'inline-block';
downloadLinkWorkbook.textContent = 'Download Workbook XPS';
resultDiv.innerHTML = '<p style="color: green;">XPS files generated. Use the links above to download the sheet and workbook XPS files.</p>';
});
</script>
</html>
Converti Excel in Ods, Sxc e Fods (OpenOffice / LibreOffice Calc)
Aspose.Cells supporta la conversione di file Excel in Ods, Sxc e Fods. L’esempio di codice sotto mostra come convertire il modello in file Ods, Sxc e Fods.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Save As Multiple Formats Example</title>
<meta charset="utf-8" />
</head>
<body>
<h1>Save As ODS / SXC / FODS Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert and Download</button>
<div style="margin-top: 10px;">
<a id="downloadLinkOds" style="display: none; margin-right: 10px;">Download ODS</a>
<a id="downloadLinkSxc" style="display: none; margin-right: 10px;">Download SXC</a>
<a id="downloadLinkFods" style="display: none; margin-right: 10px;">Download FODS</a>
</div>
<div id="result" style="margin-top: 10px;"></div>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat } = 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();
// Instantiating a Workbook object from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save as ods file
const outputOds = workbook.save(SaveFormat.Ods);
const blobOds = new Blob([outputOds]);
const downloadLinkOds = document.getElementById('downloadLinkOds');
downloadLinkOds.href = URL.createObjectURL(blobOds);
downloadLinkOds.download = 'Out.ods';
downloadLinkOds.style.display = 'inline-block';
downloadLinkOds.textContent = 'Download ODS File';
// Save as sxc file
const outputSxc = workbook.save(SaveFormat.Sxc);
const blobSxc = new Blob([outputSxc]);
const downloadLinkSxc = document.getElementById('downloadLinkSxc');
downloadLinkSxc.href = URL.createObjectURL(blobSxc);
downloadLinkSxc.download = 'Out.sxc';
downloadLinkSxc.style.display = 'inline-block';
downloadLinkSxc.textContent = 'Download SXC File';
// Save as fods file
const outputFods = workbook.save(SaveFormat.Fods);
const blobFods = new Blob([outputFods]);
const downloadLinkFods = document.getElementById('downloadLinkFods');
downloadLinkFods.href = URL.createObjectURL(blobFods);
downloadLinkFods.download = 'Out.fods';
downloadLinkFods.style.display = 'inline-block';
downloadLinkFods.textContent = 'Download FODS File';
result.innerHTML = '<p style="color: green;">Files converted successfully! Click the download links to get the converted files.</p>';
});
</script>
</html>
Conversione della cartella di lavoro Excel in file MHTML
MHTML combina HTML normale con risorse esterne (cioè contenuti che di solito sono collegati, come immagini, animazioni, audio, e così via) in un unico file. Sono utilizzati per le email con l’estensione del file .mht.
Aspose.Cells supporta la lettura e la scrittura dei file MHTML.
L’esempio di codice sotto mostra come salvare un workbook come file MHTML.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Convert Excel to MHT 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, HtmlSaveOptions } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
window.asposeCellsReady = true;
});
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;
}
if (!window.asposeCellsReady) {
resultDiv.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();
// Instantiate a workbook and open the uploaded XLSX file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Specify the HTML Saving Options
const sv = new HtmlSaveOptions(SaveFormat.MHtml);
// Save the MHT file (returns binary data)
const outputData = workbook.save(SaveFormat.MHtml, sv);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = `${file.name}.out.mht`;
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download MHT File';
resultDiv.innerHTML = '<p style="color: green;">MHT file generated successfully. Click the download link to get the file.</p>';
});
</script>
</html>
Conversione di un Workbook Excel in HTML
L’API Aspose.Cells supporta l’esportazione di fogli di calcolo in formato HTML. Per questo scopo, Aspose.Cells utilizza la classe HtmlSaveOptions per fornire la flessibilità di controllare vari aspetti dell’HTML di output.
L’esempio di codice sotto mostra come salvare un workbook come file HTML.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Converting Excel to HTML</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to HTML</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.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 your sample excel file in a workbook object
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save it in HTML format
const outputData = workbook.save(SaveFormat.Html);
const blob = new Blob([outputData], { type: 'text/html' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'ConvertingToHTMLFiles_out.html';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download HTML File';
resultDiv.innerHTML = '<p style="color: green;">Conversion completed successfully! Click the download link to get the HTML file.</p>';
});
</script>
</html>
Impostazione delle Preferenze Immagine per HTML
A partire dalla versione 8.0.2, Aspose.Cells ha esposto imageOptions per la classe HtmlSaveOptions, consentendo agli sviluppatori di specificare le preferenze di immagine durante il salvataggio dei fogli di calcolo in formato HTML.
Di seguito sono riportati i dettagli di alcune delle impostazioni delle immagini che possono essere applicate,
- ImageType: Specifica il tipo di immagine. Si noti che tutte le forme, inclusi grafici, vengono rappresentati come immagini nell’HTML di output.
- quality: Specifica la qualità dell’immagine tra 0 e 100, quando ImageType è specificato come Jpeg.
- verticalResolution: Ottiene o imposta la risoluzione verticale dell’immagine in punti per pollice.
- horizontalResolution: Ottiene o imposta la risoluzione orizzontale dell’immagine in punti per pollice.
- TiffCompression: Ottiene o imposta il tipo di compressione per le immagini quando ImageType è specificato come Tiff.
- transparent: Indica se lo sfondo di un’immagine deve essere trasparente quando ImageFormat è specificato come Png.
Converti Workbook Excel in Markdown
L’API Aspose.Cells offre supporto per esportare fogli di calcolo in formato Markdown. Per esportare il foglio attivo in Markdown, passa SaveFormat.Markdown come secondo parametro del metodo Workbook.save(string, SaveOptions). Puoi anche usare la classe MarkdownSaveOptions per specificare impostazioni aggiuntive per l’esportazione del foglio in Markdown.
Il seguente esempio di codice dimostra l’esportazione del foglio attivo in Markdown usando il membro di enumerazione SaveFormat.Markdown. Si prega di consultare il file Markdown di output generato dal codice per riferimento.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Save as Markdown</title>
</head>
<body>
<h1>Save Excel as Markdown Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to Markdown</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.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();
// Instantiating a Workbook object by opening the uploaded Excel file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Saving as Markdown
const outputData = workbook.save(SaveFormat.Markdown);
const blob = new Blob([outputData], { type: 'text/markdown' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'Book1.md';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Markdown File';
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed successfully! Click the download link to get the Markdown file.</p>';
});
</script>
</html>
Converti Workbook Excel in JSON
Aspose.Cells supporta la conversione di un workbook in file Json (JavaScript Object Notation).
Il seguente esempio di codice dimostra l’esportazione del foglio attivo in Json usando il membro di enumerazione SaveFormat.Json. Si prega di consultare il codice per convertire il file sorgente nel file Json di output generato dal codice di riferimento.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Convert Workbook to JSON</title>
</head>
<body>
<h1>Convert Workbook to JSON</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to JSON</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();
// Instantiating a Workbook object from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Convert the workbook to JSON format
const outputData = workbook.save(SaveFormat.Json);
// Create a downloadable blob for the JSON result
const blob = new Blob([outputData], { type: 'application/json' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'book1.json';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download JSON File';
document.getElementById('result').innerHTML = '<p style="color: green;">Workbook converted to JSON successfully! Click the download link to get the JSON file.</p>';
});
</script>
</html>
Converti Excel in XML
Aspose.Cells supporta la conversione di un workbook in Excel 2003 Spreadsheet XML e dati XML semplici.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Convert Workbook to XML Examples</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<br/><br/>
<a id="downloadLink1" style="display: none; margin-right: 10px;">Download Spreadsheet XML</a>
<a id="downloadLink2" style="display: none;">Download Data XML</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat, XmlSaveOptions } = 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();
// Instantiating a Workbook object from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save as Excel 2003 Spreadsheet XML
const spreadsheetData = workbook.save(SaveFormat.Excel2003Xml);
const blob1 = new Blob([spreadsheetData]);
const downloadLink1 = document.getElementById('downloadLink1');
downloadLink1.href = URL.createObjectURL(blob1);
downloadLink1.download = 'Spreadsheet.xml';
downloadLink1.style.display = 'inline-block';
downloadLink1.textContent = 'Download Spreadsheet XML';
// Save as plain XML data with XmlSaveOptions
const xmlSaveOptions = new XmlSaveOptions();
const dataXml = workbook.save(SaveFormat.SpreadsheetML, xmlSaveOptions);
const blob2 = new Blob([dataXml]);
const downloadLink2 = document.getElementById('downloadLink2');
downloadLink2.href = URL.createObjectURL(blob2);
downloadLink2.download = 'data.xml';
downloadLink2.style.display = 'inline-block';
downloadLink2.textContent = 'Download Data XML';
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed successfully! Use the links above to download the generated XML files.</p>';
});
</script>
</html>
Converti Workbook di Excel in TIFF
Aspose.Cells supporta la conversione di un workbook in file TIFF.
Il frammento di codice seguente mostra come convertire Excel in TIFF:
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Convert Excel to TIFF</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;
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();
// Instantiating a Workbook object by opening the Excel file from the file input
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save workbook to TIFF format
const outputData = workbook.save(SaveFormat.Tiff);
const blob = new Blob([outputData], { type: 'image/tiff' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'out.tiff';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download TIFF File';
resultDiv.innerHTML = '<p style="color: green;">File converted to TIFF successfully! Click the download link to get the TIFF file.</p>';
});
</script>
</html>
Converti Workbook di Excel in DOCX
L’API Aspose.Cells supporta la conversione di fogli di calcolo in formato DOCX. Per esportare il workbook in DOCX, passa SaveFormat.Docx come secondo parametro del metodo Workbook.save(string, SaveOptions). Puoi anche usare la classe DocxSaveOptions per specificare impostazioni aggiuntive per l’esportazione in DOCX.
Il seguente esempio di codice dimostra l’esportazione del foglio attivo in DOCX usando il membro di enumerazione SaveFormat.Docx. Si prega di consultare il file DOCX di output generato dal codice.
<!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 } = 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();
// Instantiate Workbook from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save as DOCX (Markdown/Docx conversion per original code)
const outputData = workbook.save(SaveFormat.Docx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'Book1.docx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Docx File';
document.getElementById('result').innerHTML = '<p style="color: green;">File converted successfully! Click the download link to get the DOCX file.</p>';
});
</script>
</html>
Converti Workbook di Excel in PPTX
L’API Aspose.Cells supporta la conversione di fogli di calcolo in formato PPTX. Per esportare il workbook in PPTX, passa SaveFormat.Pptx come secondo parametro del metodo Workbook.save(string, SaveOptions). Puoi anche usare la classe PptxSaveOptions per specificare impostazioni aggiuntive per l’esportazione in PPTX.
Il seguente esempio di codice dimostra l’esportazione del foglio attivo in PPTX usando il membro di enumerazione SaveFormat.Pptx. Si prega di consultare il file PPTX di output generato dal codice.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Save as PPTX Example</title>
</head>
<body>
<h1>Save Excel as PPTX Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to PPTX</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();
// Instantiating a Workbook object by opening the uploaded Excel file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save as PPTX
const outputData = workbook.save(SaveFormat.Pptx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
const baseName = file.name.replace(/\.[^/.]+$/, "");
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = baseName + '.pptx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Converted PPTX File';
document.getElementById('result').innerHTML = '<p style="color: green;">File converted successfully! Click the download link to get the PPTX file.</p>';
});
</script>
</html>
Converti cartella di lavoro Excel in EPUB
L’API Aspose.Cells supporta la conversione di fogli di calcolo in formato EPUB. Per esportare il workbook in EPUB, passa SaveFormat.Epub come secondo parametro del metodo Workbook.save(string, SaveOptions). Puoi anche usare la classe EBookSaveOptions per specificare impostazioni aggiuntive per l’esportazione in Epub.
Il seguente esempio di codice dimostra l’esportazione del foglio attivo in EPUB usando il membro di enumerazione SaveFormat.Epub.
<!DOCTYPE html>
<html>
<head>
<title>Converting To EPUB Files</title>
</head>
<body>
<h1>Converting To EPUB Files</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Convert to EPUB</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.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();
// Load your sample excel file in a workbook object
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Save it in EPUB format
const outputData = workbook.save(SaveFormat.Epub);
const blob = new Blob([outputData], { type: 'application/epub+zip' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'ConvertingToEPUBFiles_out.epub';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download EPUB File';
result.innerHTML = '<p style="color: green;">File converted to EPUB successfully! Click the download link to get the EPUB file.</p>';
});
</script>
</html>
Converti cartella di lavoro Excel in AZW3
L’API Aspose.Cells supporta la conversione di fogli di calcolo in formato AZW3. Per esportare il workbook in AZW3, passa SaveFormat.Azw3 come secondo parametro del metodo Workbook.save(string, SaveOptions). Puoi anche usare la classe EBookSaveOptions per specificare impostazioni aggiuntive per l’esportazione in AZW3.
Il seguente esempio di codice dimostra l’esportazione del foglio attivo in AZW3 usando il membro di enumerazione SaveFormat.Azw3.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Convert to AZW3 Example</title>
</head>
<body>
<h1>Convert Excel to AZW3 (EPUB) Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx" />
<button id="runExample">Convert to AZW3</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.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();
// Load your sample excel file in a workbook object
const wb = new Workbook(new Uint8Array(arrayBuffer));
// Save it in AZW3 format
const outputData = wb.save(SaveFormat.Azw3);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'ConvertingToEPUBFiles_out.azw3';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download AZW3 File';
document.getElementById('result').innerHTML = '<p style="color: green;">Conversion completed successfully! Click the download link to get the AZW3 file.</p>';
});
</script>
</html>