Convert ZIP Files to EXCEL in Java or Online ZIP Converter

ZIP to EXCEL Conversion in Java

Create ZipInputStream with input ZIP file
Setup output directory where unzipped files will be stored
Loop through each file in input ZIP file and extract to output directory
Temporary List to hold names of extracted files from unzipped folder
Get the list of all files (with full paths) from unzipped folder
Loop through each unzipped file and convert each file to EXCEL
Merge EXCEL files using GroupDocs.Merger API
Instantiate Merger with first input EXCEL document in temporary List
Loop through list of converted EXCEL documents starting from second file
Call Save method of Merger class instance to save merged EXCEL document

Free App for ZIP to EXCEL Conversion

	// Supported file formats: https://docs.groupdocs.com/conversion/java/supported-document-formats/
	// Works with OpenJDK 17

	package com.mycompany.asposejavatest;

	import java.io.*;
	import java.util.ArrayList;
	import org.apache.commons.compress.archivers.*;
	import org.apache.commons.compress.compressors.*;
	import com.groupdocs.conversion.*;
	import com.groupdocs.conversion.Converter;
	import com.groupdocs.conversion.options.convert.PdfConvertOptions;
	import com.groupdocs.conversion.contracts.PossibleConversions;
	import com.groupdocs.conversion.options.convert.ConvertOptions;
	import com.groupdocs.merger.*;
	import com.groupdocs.merger.Merger;

	public class AsposeJavaTest {

	public static void main(String[] args) {

	try {
	InputStream inputfile = new BufferedInputStream(new FileInputStream("input.zip"));

	// For those formats that are separately archived and compressed. Like tar.gz tar.bz tar.xz Use
	// CompressorInputStream and than use ArchiveInputStream to load the input file.
	//CompressorInputStream cis = new CompressorStreamFactory().createCompressorInputStream(inputfile);
	//ArchiveInputStream ais = new ArchiveStreamFactory().createArchiveInputStream(cis);

	// For formats that have builtin support for compression. Like Zip RAR JAR 7zip
	// ArchiveInputStream to load the input file without CompressorInputStream
	//ArchiveInputStream ais = new ArchiveStreamFactory().createArchiveInputStream(inputfile);

	ArchiveEntry entry = ais.getNextEntry();

	File outputDir = new File("/tmp/output");
	if (!outputDir.exists()) {
	outputDir.mkdirs();
	}

	while (entry != null) {
	String filePath = outputDir.getAbsolutePath() + File.separator + entry.getName();
	BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(filePath));
	byte[] bytesIn = new byte[1024];
	int read;

	while ((read = ais.read(bytesIn)) != -1) {
	bos.write(bytesIn, 0, read);
	}

	ais.close();
	bos.close();
	entry = ais.getNextEntry();
	}

	// Temporary List to hold names of extracted files from unzipped folder
	ArrayList<String> filesList = new ArrayList<>();

	// Get the list of all files (with full paths) from unzipped folder
	File[] files = outputDir.listFiles();

	// Loop through each unzipped file and convert each file to PDF
	for (File file : files) {
	// Load the extracted file
	Converter converter = new Converter(file.getAbsolutePath());
	// Set the convert options for PDF format
	PdfConvertOptions convertOptions = new PdfConvertOptions();
	// Convert to PDF format
	String outPath = outputDir.getAbsolutePath() + File.separator + file.getName()+ ".pdf";
	converter.convert(outPath, convertOptions);
	// Add the file names to temporary List after converting to PDF
	filesList.add(outPath);
	}

	// Merge PDF files using GroupDocs.Merger API
	// Instantiate Merger with first input PDF document in temporary List
	Merger merger = new Merger(filesList.get(0));

	// Loop through list of converted PDF documents starting from second file
	for (int i = 1; i < filesList.size(); i++) {
	// Call Join method of Merger class instance and pass remaining source files one by one
	merger.join(filesList.get(i));
	}

	// Call Save method of Merger class instance to save merged PDF document
	merger.save("/tmp/output.pdf");
	} catch (Exception e) {
	e.printStackTrace();
	}
	}
	}

view raw convert-zip-to-pdf.java hosted with ❤ by GitHub

Frequently Asked Questions

How do I start converting ZIP to EXCEL using Conholdate.Total for Java?

The Conholdate.Total for Java platform lets you try out different ways to convert archive files. Developers have two main options - they can use ready-made examples from GroupDocs for a straightforward approach, or go with Aspose examples for more control. You can also use these examples to work on both the front and back end of a project, or build your ZIP to EXCEL conversion feature from scratch using popular Java-supporting tools like Eclipse or Visual Studio Code.

Which Java APIs from Conholdate.Total are in the example code for converting ZIP to EXCEL?

Conholdate.Total for Java brings together all the Java APIs from Aspose and GroupDocs. Although developers have various APIs to choose from for converting ZIP to EXCEL, we chose to show easy-to-follow examples using GroupDocs.Conversion for Java in our code snippets.

Which file formats are supported by Conholdate.Total for Java?

Conholdate.Total for Java combines libraries from Aspose and GroupDocs, allowing Java programmers to work with many different file formats like Word, Excel, Visio, images and PDF in Java and J2SE apps. This means you can easily manipulate and manage these files in your Java projects.

What is ZIP file format?

The ZIP file format holds significant recognition and finds widespread application in file sharing and data storage. Its ability to compress files into smaller sizes makes it highly efficient for transferring and archiving large files. With broad support across various operating systems, ZIP files offer enhanced compatibility compared to other archive formats. Simplifying file management, ZIP files store all files and data within a single archive, eliminating the need for additional files or folders.

The versatility of ZIP files becomes particularly valuable when sharing multiple files or folders simultaneously. By compressing an entire folder into a ZIP file, users can easily distribute several files to others, simplifying the sharing process. Additionally, ZIP files provide an added layer of security by allowing users to protect their data with a password. This security feature proves particularly beneficial when sensitive information is involved, ensuring that only authorized individuals can access the files.

The benefits of ZIP files extend beyond their compression and security capabilities. ZIP files offer convenience by allowing for easy extraction of individual files from the archive, avoiding the need to extract the entire contents. This flexibility saves time and simplifies the retrieval of specific files from a compressed archive. Furthermore, ZIP files support various compression algorithms, enabling users to choose the level of compression based on their specific requirements.

Another advantage of the ZIP format is its ability to preserve file metadata, such as timestamps and permissions. This ensures that the archived files retain their original properties, making ZIP files ideal for data backup and preservation purposes. Moreover, ZIP files can be segmented into multiple volumes, facilitating the storage and transfer of large archives across different media or network connections.

Learn

What is EXCEL file format?

Excel is an immensely popular spreadsheet software program developed by Microsoft Corporation. Its file format, a binary file format, stores data in worksheets comprising cells organized into rows and columns. Excel files typically possess either a .xlsx or .xls file extension. Within these files, one can find an array of data types including numbers, text, formulas, charts, and images. The file format also supports a plethora of formatting options, ranging from font styles, colors, and borders to conditional formatting that permits users to apply distinct formatting based on specific criteria.

The multifaceted nature of Excel files renders them invaluable for various tasks, including financial analysis, budgeting, and data analysis. When faced with large amounts of data, Excel provides an efficient means of organization and manipulation. Additionally, it serves as a versatile tool for creating visually appealing charts and graphs that facilitate data visualization.

Apart from the standard Excel file format, several other formats are commonly employed alongside it. For instance, CSV (Comma Separated Values) files enable the seamless import and export of data between diverse software applications. XML (Extensible Markup Language) files, on the other hand, allow structured data storage and exchange.

Excel’s enduring popularity stems from its user-friendly interface and extensive range of features. Its functionalities empower users to perform complex calculations, generate reports, and automate repetitive tasks. Whether you’re a professional in finance, data analysis, or simply an individual looking to effectively organize information, Excel remains an indispensable tool for achieving these objectives.

Convert ZIP Files to EXCEL in Java