function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
REKREK 

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? 

Pradeep_NavatarPradeep_Navatar

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.