Skip to main content

Java program to compare 2 excel files and find out the difference using apache poi

 Here is the java function to compare 2 excel files and find out the difference using apache poi

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-6267207135477922"

     crossorigin="anonymous"></script>

First add the following dependencies into maven project as we are using the testNG framework and maven project or if you are not using maven project then add respective JAR files into your project.


<dependency>


<groupId>org.apache.poi</groupId>


<artifactId>poi-ooxml</artifactId>


<version>5.0.0</version>


</dependency>


<dependency>


<groupId>org.apache.poi</groupId>


<artifactId>poi</artifactId>


<version>4.1.2</version>


</dependency>


<dependency>


<groupId>org.testng</groupId>


<artifactId>testng</artifactId>


<version>7.4.0</version>


<scope>test</scope>


</dependency>


package excelcompare;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Collections;

import java.util.List;


import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class CompareExcel {


public static void main(String[] args) throws IOException {

String Excel1="excelfile1";

String Excel2 ="excelfile1";

String Sheet1 = "sheet1_of_file_1";

String Sheet2= "Sheet2_of_file_2";

List<String> unMatchedData = new ArrayList<String>();

List<String> MatchedData = new ArrayList<String>();

ReadExcel ex = new ReadExcel();

List<String> Excel1 = ex.ExcelRead(Excel1, Sheetaws);

Collections.sort(Excel1);

List<String> Excel2 = ex.ExcelRead(Excel2, Sheetdb);

Collections.sort(Excel2);

for (int i=0;i<Excel2.size();i++)

{

boolean matched = false;

for(int j=0;j<Excel1.size();j++)

{

if(Excel2.get(i).equalsIgnoreCase(Excel1.get(j)))

{

MatchedData.add(Excel2.get(i));

matched= true;

break;

}

}

if(matched)

{

continue;

}

else

{

unMatchedData.add(Excel2.get(i));

}

}

WriteExcel we = new WriteExcel();

String name1 = "unmatched_data";

String name2 = "matched_data";

we.writeunmatchedData(unMatchedData, name1);

we.writeunmatchedData(MatchedData, name2);

}


}

The Readexcel and writeexcel functions will be found on this blog. Use them to read and write the excel files.

Comments

Popular posts from this blog

Add, remove, search an item in listview in C#

Below is the C# code which will help you to add, remove and search operations on listview control in C#. Below is the design view of the project: Below is the source code of the project: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Treeview_control_demo {     public partial class Form2 : Form     {         public Form2()         {             InitializeComponent();             listView1.View = View.Details;                   }         private void button1_Click(object sender, EventArgs e)         {             if (textBox1.Text.Trim().Length == 0)...

Add worklog in Jira using Python

 Below is the Python code to add the worklog in Jira. You need to install a request library for this. Here is the code: import requests from requests.auth import HTTPBasicAuth import json url = "https://your jira address here/rest/api/2/issue/ticket_number/worklog" auth = HTTPBasicAuth("username", "jira access token") headers = {     "Accept": "application/json",     "Content-Type": "application/json" } payload = json.dumps({     "comment": {         "content": [             {                 "content": [                     {                         "text": "This is for QA Testing",                         "type": "text"                     } ...

Some GUI examples in Python using customtkinter

 Some GUI examples in Python using customtkinter import customtkinter import os from PIL import Image class ScrollableCheckBoxFrame(customtkinter.CTkScrollableFrame):     def __init__(self, master, item_list, command=None, **kwargs):         super().__init__(master, **kwargs)         self.command = command         self.checkbox_list = []         for i, item in enumerate(item_list):             self.add_item(item)     def add_item(self, item):         checkbox = customtkinter.CTkCheckBox(self, text=item)         if self.command is not None:             checkbox.configure(command=self.command)         checkbox.grid(row=len(self.checkbox_list), column=0, pady=(0, 10))         self.checkbox_list.append(checkbox)     def remove_item(self, it...