RS232 to Excel

Discussion in 'Programmer's Corner' started by shijomts, Dec 10, 2008.

  1. shijomts

    Thread Starter New Member

    Dec 10, 2008
    1
    0
    How we can access com port and display data from com port usin Microsoft Excel
     
  2. beenthere

    Retired Moderator

    Apr 20, 2004
    15,815
    282
    I don't believe Excel will input a file from the COM port, but a comma delineated text file transferred into the computer can be read and understood by the application. Just recall which folder has the file and open it with Excel.
     
  3. HellDesk

    New Member

    Dec 8, 2008
    2
    0
    You can add Visual Basic code to Excel sheets. Use that to interface with the computer's serial port.

    Won't be easy afaik, because you don't have direct access to the ports in XP/Vista and need extra software for that.
     
  4. vivekanantha7

    Member

    Dec 1, 2008
    27
    0
  5. KL7AJ

    AAC Fanatic!

    Nov 4, 2008
    2,040
    287
    B&B Electronics makes some low cost serial bus DAQ modules that give you delimited data. Once you have that it's a snap to import it into Excel

    eric
     
  6. leftyretro

    Active Member

    Nov 25, 2008
    394
    2
  7. vivekanantha7

    Member

    Dec 1, 2008
    27
    0
    What you have given is a Complete application, that looks after the Serial port but If we need to design the Basic controls of our own wish, we can go for VC++ or VB with ODBC links.
     
  8. Alberto

    Active Member

    Nov 7, 2008
    169
    36
    If I understand correctly, what is needed is to tranfer on an excel sheet some data coming through the serial port. This is not difficult to do if you know visual basic. But you also need to know what kind of string you receive from the serial port, and how you want to order them in the excel sheet.

    Alberto
     
Loading...