Hey guys,
I am looking for advice on how to write a simple script to convert a txt file to xlsx. The data output in the text file looks like the following:
06/11/2015 15:29:00,091.6,100.4,100.0,100.5
06/11/2015 15:30:00,091.6,100.4,100.0,100.5
06/11/2015 15:31:00,091.6,100.4,099.9,100.4
06/11/2015 15:32:00,091.7,100.2,099.9,100.4
06/11/2015 15:33:00,091.7,100.2,099.9,100.4
06/11/2015 15:34:00,091.7,100.1,099.9,100.2
I would like to write something that takes each data entry (6 in total), and separates them into separate columns in an excel file. Any help with this is much appreciated. Thanks
I am looking for advice on how to write a simple script to convert a txt file to xlsx. The data output in the text file looks like the following:
06/11/2015 15:29:00,091.6,100.4,100.0,100.5
06/11/2015 15:30:00,091.6,100.4,100.0,100.5
06/11/2015 15:31:00,091.6,100.4,099.9,100.4
06/11/2015 15:32:00,091.7,100.2,099.9,100.4
06/11/2015 15:33:00,091.7,100.2,099.9,100.4
06/11/2015 15:34:00,091.7,100.1,099.9,100.2
I would like to write something that takes each data entry (6 in total), and separates them into separate columns in an excel file. Any help with this is much appreciated. Thanks