Mar 6, 2004, 6:52 AM
Post #1 of 1
converting .xls file to .csv
i m building a program to merge two excel files which have some common entries. the merged file (in .xls format) should show all the entries but the common entries only once. i have thought of converting these two files to .csv 7 then using split to separate the fields & then using regular expressions to compare & again build a .csv file containing all the entries which can easily be converted to .xls by just changing the file extension type.
But i m havin problem in converting .xls to .csv. So could u all can help.
Or u can provide me a all together differant idea to do the above work.