FlaminMad / researchProject

Level Control Research Project Repo
MIT License
0 stars 0 forks source link

Excel Write - Linux #11

Closed FlaminMad closed 8 years ago

FlaminMad commented 8 years ago

Openpyxl will not read excel files when run on linux.

Please fix! :dancer:

pet1330 commented 8 years ago

Can you provide error logs? Or what it outputs from the terminal or a description of what it does when it fails so I know where to start? :P

FlaminMad commented 8 years ago

Ok so if I run ./script/startDataLoggingTool on linux I get the following output:

[alex@archtop script]$ ./startDataLoggingTool 

Traceback (most recent call last):
  File "dataLoggingTool.py", line 67, in <module>
    if __name__ == '__main__':main()
  File "dataLoggingTool.py", line 63, in main
    rp = dataLoggingTool()
  File "dataLoggingTool.py", line 25, in __init__
    self.xls = xlsLogging4Vars()
  File "/home/alex/GitHub/researchProject/src/dataLoggingTool/xlsLogging4Vars.py", line 28, in __init__
    self.ws.cell(row = 0, column = 0).value = "Date: "
  File "/usr/lib/python2.7/site-packages/openpyxl/worksheet/worksheet.py", line 301, in cell
    raise ValueError("Row or column values must be at least 1")
ValueError: Row or column values must be at least 1

On windows no error is thrown (Though note the starting script does not work on windows you need to run python ./src/dataLoggingTool/dataLoggingTool.py).

I have setup the script in a simulation environment within the latest commit so you should be able to run it without any errors bar the excel one.

System details:

               +                OS: Arch Linux i686
               #                Hostname: archtop
              ###               Kernel Release: 4.3.3-2-ARCH
             #####              Uptime: 0:11
             ######             WM: Openbox
            ; #####;            DE: LXDE
           +##.#####            Packages: 435
          +##########           RAM: 196 MB / 498 MB
         #############;         Processor Type: Intel(R) Pentium(R) M processor 1.70GHz
        ###############+        $EDITOR: None
       #######   #######        Root: 3.2G / 9.8G (32%) (ext4)
     .######;     ;###;`".      
    .#######;     ;#####.       
    #########.   .########`     
   ######'           '######    
  ;####                 ####;   
  ##'                     '##   
 #'                         `#  
FlaminMad commented 8 years ago

@pet1330 - Read the above referenced issue too when thinking about this :)

FlaminMad commented 8 years ago

Closed as per description of commit 6e5e5f3