Python Forum
Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
.dat file to xlsxl
#29
Mm, so i cant get it to work with Excel outputfile.
While it works ok with a .dat file:
import time
import schedule    
     
def task1():  
    existingLines = set(line.strip() for line in open("C:\\Users\\Makada\\Desktop\\CR1000_Table1 - kopie.dat"))
    outfile = open("C:\\Users\\Makada\\Desktop\\CR1000_Table1 - kopie.dat", "a+")
    for content in open("C:\\Campbellsci\\LoggerNet\\CR1000_Table1.dat", "r"):
        if content.strip() not in existingLines: # to void duplicate lines
            outfile.write(content)
            existingLines.add(content)
    outfile.close()
     
schedule.every().minute.at(":01").do(task1)  
 
while True:
    schedule.run_pending()
    time.sleep(1)
refresh()
I really like the possibilities of Excel for simple data correction and graphing.
Reply


Messages In This Thread
.dat file to xlsxl - by Makada - Apr-07-2020, 07:39 PM
RE: .dat file to xlsxl - by Makada - Apr-07-2020, 09:20 PM
RE: .dat file to xlsxl - by bowlofred - Apr-07-2020, 10:14 PM
RE: .dat file to xlsxl - by Makada - Apr-08-2020, 05:21 AM
RE: .dat file to xlsxl - by Makada - Apr-08-2020, 07:53 AM
RE: .dat file to xlsxl - by Makada - Apr-08-2020, 04:03 PM
RE: .dat file to xlsxl - by Makada - Apr-09-2020, 04:52 PM
RE: .dat file to xlsxl - by Makada - Apr-17-2020, 05:59 AM
RE: .dat file to xlsxl - by buran - Apr-17-2020, 07:06 AM
RE: .dat file to xlsxl - by Makada - Apr-23-2020, 08:26 AM
RE: .dat file to xlsxl - by buran - Apr-23-2020, 08:58 AM
RE: .dat file to xlsxl - by Makada - Apr-23-2020, 09:12 AM
RE: .dat file to xlsxl - by Makada - Apr-23-2020, 04:37 PM
RE: .dat file to xlsxl - by buran - Apr-23-2020, 04:39 PM
RE: .dat file to xlsxl - by buran - Apr-23-2020, 04:46 PM
RE: .dat file to xlsxl - by Makada - Apr-23-2020, 04:54 PM
RE: .dat file to xlsxl - by buran - Apr-23-2020, 05:06 PM
RE: .dat file to xlsxl - by Makada - Apr-23-2020, 06:11 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 08:03 AM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 10:27 AM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 10:43 AM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 10:56 AM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 12:30 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 12:42 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 03:43 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 04:00 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 05:00 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 05:16 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 05:25 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 05:56 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 06:16 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 06:21 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 06:42 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 07:20 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 07:24 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 07:36 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 07:46 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 07:52 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 07:52 PM
RE: .dat file to xlsxl - by buran - Apr-24-2020, 07:55 PM
RE: .dat file to xlsxl - by Makada - Apr-24-2020, 07:59 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020