Let’s assume that you have 2 excel files :
product_data_excel.xlsx (99 rows x 5 columns, A2: E100)
product_data_excel_2.xlsx (107 rows x 5 columns, A2:E108)
The 5 columns of the two excel files are : product_id, product_description, quantity, regular_price and category.
product_data_excel.xlsx
You have changed quantity and price values for existing product_ids : “A0001” and “A0003” (column : “product_id”) and you have added 8 new products in excel file : product_data_excel_2.xlsx.
product_data_excel_2.xlsx
Now you want to compare product_data_excel.xlsx and product_data_excel_2.xlsx and create a new excel file : product_data_excel_changed_and_new_records.xlsx and csv file : product_data_excel_changed_and_new_data.csv with the 2 existing products you have changed and the 8 new ones you have added.
product_data_excel_changed_and_new_records.xlsx
Download
product_data_excel_changed_and_new_records.xlsx, product_data_excel_changed_and_new_records.csv
Click comparing_data_values_between_2_excel_files to see the code (html format) . . .
Comments are closed.