Convertir Excel a Pdf, imagen y otros formatos
Contents
[
Hide
]
Aspose.Cells admite la conversión entre muchos formatos. Técnicamente, la conversión significa cargar un libro de trabajo en un formato de archivo y guardarlo en otro.
Convertir libro de trabajo de Excel a PDF
Los archivos PDF son ampliamente utilizados para intercambiar documentos entre organizaciones, sectores gubernamentales e individuos. Es un formato de documento estándar y a menudo se pide a los desarrolladores de software que encuentren una forma de convertir archivos de Microsoft Excel en documentos PDF.
Aspose.Cells admite la conversión de archivos de Excel a PDF y mantiene una alta fidelidad visual en la conversión.
<!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>
Convertir Libro de Excel a JPG
Aspose.Cells soporta la conversión de archivos Excel a JPG. El ejemplo de código a continuación muestra cómo guardar un libro de trabajo como 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>
Convertir Libro de Excel a Imagen
Aspose.Cells soporta convertir archivos Excel a imágenes. El ejemplo de código a continuación muestra cómo guardar un libro de trabajo como imágenes.
<!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>
Convirtiendo Libro de Excel a XPS
El formato de documento XPS consta de marcado XML estructurado que define el diseño de un documento y la apariencia visual de cada página, junto con reglas de renderizado para distribuir, archivar, renderizar, procesar e imprimir documentos.
El lenguaje de marcado para XPS es un subconjunto de XAML que le permite incorporar elementos de gráficos vectoriales en documentos, utilizando XAML para marcar las primitivas de la Fundación de Presentación de Windows (WPF). Los elementos utilizados se describen en términos de rutas y otras primitivas geométricas.
Un archivo XPS es, de hecho, un archivo ZIP unicode que utiliza las Convenciones de Empaquetado Abierto, que contiene los archivos que componen el documento. Estos incluyen un archivo de marcado XML para cada página, texto, fuentes incrustadas, imágenes rasterizadas, gráficos vectoriales 2D, así como la información de gestión de derechos digitales. El contenido de un archivo XPS se puede examinar simplemente abriéndolo en una aplicación que admite archivos ZIP.
A partir de Aspose.Cells 6.0.0, se admite la conversión de Microsoft Excel a 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>
Convertir Excel a Ods, Sxc y Fods (OpenOffice / LibreOffice Calc)
Aspose.Cells soporta la conversión de archivos Excel a archivos Ods, Sxc y Fods. El ejemplo de código a continuación muestra cómo convertir la plantillas en archivos Ods, Sxc y 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>
Convirtiendo Libro de Excel a Archivos MHTML
MHTML combina HTML normal con recursos externos (es decir, contenido que suele estar vinculado, como imágenes, animaciones, audio, etc.) en un solo archivo. Se utilizan para correos electrónicos con la extensión de archivo .mht.
Aspose.Cells admite la lectura y escritura de archivos MHTML.
El ejemplo de código a continuación muestra cómo guardar un libro como un archivo 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>
Convirtiendo Libro de Excel a HTML
La API de Aspose.Cells ofrece soporte para exportar hojas de cálculo a formato HTML. Para esto, Aspose.Cells usa la clase HtmlSaveOptions para ofrecer flexibilidad en el control de varios aspectos del HTML de salida.
El ejemplo de código a continuación muestra cómo guardar un libro como un archivo 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>
Configuración de las Preferencias de Imagen para HTML
A partir de la versión 8.0.2, Aspose.Cells ha expuesto imageOptions para la clase HtmlSaveOptions, permitiendo a los desarrolladores especificar preferencias de imagen al guardar hojas de cálculo en formato HTML.
A continuación se detallan algunas de las configuraciones de imagen que se pueden aplicar:
- ImageType: Especifica el tipo de imagen. Por favor, tenga en cuenta que todas las formas, incluidos los gráficos, se renderizan como imágenes en el HTML de salida.
- quality: Especifica la calidad de la imagen de 0 a 100, cuando ImageType se especifica como Jpeg.
- verticalResolution: Obtiene o establece la resolución vertical de la imagen en puntos por pulgada.
- horizontalResolution: Obtiene o establece la resolución horizontal de la imagen en puntos por pulgada.
- TiffCompression: Obtiene o establece el tipo de compresión para las imágenes cuando ImageType se especifica como Tiff.
- transparent: Indica si el fondo de una imagen debe ser transparente cuando se especifica ImageFormat como Png.
Convertir Libro de Excel a Markdown
La API de Aspose.Cells soporta exportar hojas de cálculo a formato Markdown. Para exportar la hoja activa a Markdown, pase SaveFormat.Markdown como el segundo parámetro del método Workbook.save(string, SaveOptions). También puede usar la clase MarkdownSaveOptions para especificar configuraciones adicionales para exportar la hoja a Markdown.
El siguiente ejemplo de código demuestra cómo exportar la hoja activa a Markdown usando el miembro de enumeración SaveFormat.Markdown. Consulte el archivo Markdown generado para referencia.
<!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>
Convertir Libro de Excel a JSON
Aspose.Cells soporta la conversión de un libro a JSON (JavaScript Object Notation).
El siguiente ejemplo de código demuestra cómo exportar la hoja activa a Json usando el miembro de enumeración SaveFormat.Json. Consulte el código para convertir el archivo fuente al archivo Json resultado generado por el código para referencia.
<!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>
Convertir Excel a XML
Aspose.Cells admite la conversión de un libro de trabajo a XML de Hoja de Cálculo Excel 2003 y datos XML sin formato.
<!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>
Convertir libro de Excel a TIFF
Aspose.Cells admite la conversión de un libro de trabajo a un archivo TIFF.
El fragmento de código a continuación muestra cómo convertir Excel a 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>
Convertir libro de Excel a DOCX
La API de Aspose.Cells soporta convertir hojas de cálculo a formato DOCX. Para exportar el libro a DOCX, pase SaveFormat.Docx como el segundo parámetro del método Workbook.save(string, SaveOptions). También puede usar la clase DocxSaveOptions para especificar configuraciones adicionales para exportar la hoja a DOCX.
El siguiente ejemplo de código demuestra cómo exportar la hoja activa a DOCX usando el miembro de enumeración SaveFormat.Docx. Consulte el archivo DOCX generado para referencia.
<!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>
Convertir libro de Excel a PPTX
La API de Aspose.Cells soporta convertir hojas de cálculo a formato PPTX. Para exportar el libro a PPTX, pase SaveFormat.Pptx como el segundo parámetro del método Workbook.save(string, SaveOptions). También puede usar la clase PptxSaveOptions para especificar configuraciones adicionales para exportar la hoja a PPTX.
El siguiente ejemplo de código demuestra cómo exportar la hoja activa a PPTX usando el miembro de enumeración SaveFormat.Pptx. Consulte el archivo PPTX generado para referencia.
<!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>
Convertir Libro de Excel a EPUB
La API de Aspose.Cells soporta convertir hojas de cálculo a formato EPUB. Para exportar el libro a EPUB, pase SaveFormat.Epub como el segundo parámetro del método Workbook.save(string, SaveOptions). También puede usar la clase EBookSaveOptions para especificar configuraciones adicionales para exportar la hoja a Epub.
El siguiente ejemplo de código demuestra cómo exportar la hoja activa a EPUB usando el miembro de enumeración 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>
Convertir Libro de Excel a AZW3
La API de Aspose.Cells soporta convertir hojas de cálculo a formato AZW3. Para exportar el libro a AZW3, pase SaveFormat.Azw3 como el segundo parámetro del método Workbook.save(string, SaveOptions). También puede usar la clase EBookSaveOptions para especificar configuraciones adicionales para exportar la hoja a AZW3.
El siguiente ejemplo de código demuestra cómo exportar la hoja activa a AZW3 usando el miembro de enumeración 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>