@SREENIVASKALALI our support team investigated in INC-B17877 (Getting Extra 50 Empty Records while parsing the excel)  and closed the ticket with the following conclusion:

Resolution reason: Explanation provided   Issue primary reason description:

Issue : I have export and import functionality and i am able to export and same has been imported but Getting Extra 50 Empty Records while parsing the excel file.

Client reported issue where after running pxParseExcelFile activity, data was getting parsed and large numbe of recordes loaded in the clipboard as expected. Steps to reproduce:

1) Upload Excel File

2) Parse excel file using pxParseExcelFile in Activity

• The scenario currenty you are using is of custom requirement where you are using non-auto generated excel to display the records dynamically on UI.
• However, whenever we upload newexcel in binary file, the new file data is reflected immediately in the UI with empty data.
• To check that, we replicated the issue but in inhouse the issue is not seen.
• Based on your specific needs, we pinpointed this as a binary file problem. After eliminating the empty rows in the template, the Excel file was successfully generated without the additional 50 empty records.

Explanation type: 

Based on your specific needs, we pinpointed this as a binary file problem. After eliminating the empty rows in the template, the Excel file was successfully generated without the additional 50 empty records.