Hi
I am not a programmer but need to do the following:
Read the excel file and look at column L and remove all duplicates. Once all dupicates are removed need to pull the data from column J & L and place into another excel sheet.
Any help would be greatly appriciated.
Thanks
[php]
<?php function read_data($mapfile) { #Open $mapfile, read columns J & L #return array of results #Parameters: #$mapfile - filename to open #Throw exception if cannot open file. #Throw exception if no data } function dedupe($mapdata) { #dedupe $mapdata #return array of unique values #Parameters: #$mapdata - map data #Throw exception if no data } function write_dataload7($deduped,$dl7file) { #write deduped project-wo data in dataload7 format #Parameters: #$deduped - workorder-project data #$dl7file - csv to open and write file to #Throw exception if cannot open file. #Throw exception if no data } $map_file = "W:\\Mapping(07-17).xlsx $mapdata = read_data($map_file); $deduped = dedupe($mapdata); $dl7_file = "proj-wo_load.csv"; write_dataload7($deduped,$dl7_file); ?>[/php]