You need to sign in to do that
Don't have an account?

Removal of Duplicate rows in the excel sheet ?
Hi All,
I developed a VF Page which contains details of some data as tables,and it has a "Export To Excel" Button.Actually on click of that button we need to export all those details in to excel sheet. It is done.After these things exorting to an excel some duplicate Rows occured . How can we remove that duplicate rows in that excel sheet after exporting it?
After exporting the data into excel you can use excel property to remove duplicates :
Data-> select column in which you want to remove dulpicate -> remove duplicate options -> check the checkbox for current selection -> remeove duplicate button.
Hope this helps.