#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Location
    Delhi
    Posts
    35
    Rep Power
    2

    Column with spefic name in python


    Dear all.

    I wanna write simple code.

    Where i wanna create excel file with specific column with names. like slno,dateand time, mode , etc. and i wanna write the data received from Serial monitor in indivual columns.

    let me know the following
    1) how to create excel file with column labeling
    2)how to write into indivual column
    3)how to give delay in the program.
  2. #2
  3. Contributing User
    Devshed Demi-God (4500 - 4999 posts)

    Join Date
    Aug 2011
    Posts
    4,837
    Rep Power
    480
    Must you write directly to excel? An alternative: create a csv file you'd later load into excel.

    You can delay using

    import time
    time.sleep(floating_point_seconds)
    [code]Code tags[/code] are essential for python code and Makefiles!
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Location
    Delhi
    Posts
    35
    Rep Power
    2
    can you explain with simple code for writing into excel sheet with label specified


    Originally Posted by b49P23TIvg
    Must you write directly to excel? An alternative: create a csv file you'd later load into excel.

    You can delay using

    import time
    time.sleep(floating_point_seconds)
  6. #4
  7. Contributing User
    Devshed Demi-God (4500 - 4999 posts)

    Join Date
    Aug 2011
    Posts
    4,837
    Rep Power
    480
    No. I recommend:
    Python Programming on Win32 by Mark Hammond
    "com objects" were the method you needed. Maybe Microsoft uses something else now.
    [code]Code tags[/code] are essential for python code and Makefiles!

IMN logo majestic logo threadwatch logo seochat tools logo