Excel Data Comparison

Overview

This app lets you read and compare the contents of two local Excel files. It identifies common and unique data, then exports the comparison results to a specified file path. This tool is perfect for users looking to analyze differences and similarities in their datasets.

How to Use

1. Download the app from Octoparse AI app store.

2. Launch the app in your list.

   

   1. Parameter Description

      

      1. ExcelFile1Path: Select or enter the absolute file path of the first Excel file you want to compare.

      2. ExcelFile2Path: Select or enter the absolute file path of the second Excel file you want to compare.

         

      3. ExportFilePath: Select or enter the absolute file path for the exported Excel file.

      4. ExcelFile1SheetName: Enter the sheet name of the worksheet that contains the data in the first file.

      5. ExcelFile2SheetName: Enter the sheet name of the worksheet that contains the data in the second file.

   2. Click "Run application"

3. Output

   The application will the compare the files and export the results to the specified file path.

   

Notes

• The app reads data from the first row of the Excel files by default, so ensure that the input Excel files do not contain headers.

• All launch parameters are required. Note the letter case of the sheet names.

Support

Encounter obstacles but don't know how to resolve them when executing the app?

Please contact our support team at [email protected] to find the way out!