Search code examples
windowsexcelscriptingwindows-scripting

Scripting in Windows to create excel sheets

I have a txt file that contains data which I need to input to Excel.

The problem is I have several of those files and I want to create an excel file for each. So I was thinking of scripting. Can anyone point me to how to start atleast the tool needed and language to use

Thanks

EDIT: turns out naming the extension .csv can directly open it in excel. Now looking on how to open .csv , change format to autofit width and then save to excel

Solution

  • Why don't you just write CSV files... They open on Excel and require no effort.

    http://en.wikipedia.org/wiki/Comma-separated_values