c# - Convert Text file to Excel -
i have text files convert excel copy/pasting them excel go data -> text columns. then choose delimited. then select delimiters tab , semicolon. in last step choose text fields. now want automate making program in c#. i editing on data in excel file. make new excel file if specific column have specific name , on. 1 text file end 3 or 4 excel files. what relative merits of: read text file string/list check data write data different excel files? or use texttocolumn() method in c# start editing write new excel file? if there other, better ways accomplish such thing please suggest. edit: see lot of 3rd party suggestions, myself can learn. epplus start. helps create excel files programmatically. our company using long time , has proven work well. you might want try older version 3.1.3, if encounter crashes/bugs. had issues current version, tip. otherwise, can export csv if don't want libraries reason. should no problem implement.