Capturing EEPROM data into excel spreadsheet?


Closed Thread
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Location
    Colorado
    Posts
    378

    Default Capturing EEPROM data into excel spreadsheet?

    I am using Pickit2 programmer which also lets me capture the data written into EEPROM memory by a PicBasicPro routine into a user designated file. To enable debugging of the application in the field, we need to use this technique to capture the written EEPROM data from the MCU into an EXCEL spreadsheet on the laptop that is running PicKit2. All that works fine. Our problem is how to get the data imported into EXCEL so that each cell of the spreadsheet shows the hex data for one EEPROM memory location. The data that is captured by the Pickit2 looks like below and we need to somehow parse this data into individual hex memory cells. Has anyone ever done this or can anyone refer me to a source to do this? I presume what is needed is some kind of EXCEL macro that will separate each line of the data into separate memory locations showing the hex value in each location in a separate spreadsheet cell. I don't have a clue as to how to do this and would appreciate anyone's advice.

    :10420000FF00FF00FF00FF00FF00FF00FF000100B4
    :10421000FF00FF00FF007C00FF0000003100FF00F6
    :10422000FF003000FF000100FF00FF00FF00FF0063
    :10423000FF00FF00FF00FF00FF00FF00FF00FF0086
    :10424000FF00FF00FF00FF00FF00FF00FF00FF0076
    :10425000FF00FF00FF00FF00FF00FF00FF00FF0066
    :10426000FF00FF00FF00FF00FF00FF00FF00FF0056
    :10427000FF00FF00FF00FF00FF00FF00FF00FF0046
    :10428000FF00FF00FF00FF00FF00FF00FF00FF0036
    :10429000FF00FF00FF00FF00FF00FF00FF00FF0026
    :1042A000FF00FF00FF00FF00FF00FF00FF00FF0016
    :1042B000FF00FF00FF00FF00FF00FF00FF00FF0006
    :1042C000FF00FF00FF00FF00FF00FF00FF00FF00F6
    :1042D000FF00FF00FF00FF00FF00FF00FF00FF00E6
    :1042E000FF00FF00FF00FF00FF00FF00FF00FF00D6
    :1042F000FF00FF00FF00FF00FF00FF00FF00FF00C6
    :10430000FF00FF00FF00FF00FF00FF00FF00FF00B5
    :10431000FF00FF00FF00FF00FF00FF00FF00FF00A5
    :10432000FF00FF00FF00FF00FF00FF00FF00FF0095
    :10433000FF00FF00FF00FF00FF00FF00FF00FF0085
    :10434000FF00FF00FF00FF00FF00FF00FF00FF0075
    :10435000FF00FF00FF00FF00FF00FF00FF00FF0065
    :10436000FF00FF00FF00FF00FF00FF00FF00FF0055
    :10437000FF00FF00FF00FF00FF00FF00FF00FF0045
    :10438000FF00FF00FF00FF00FF00FF00FF00FF0035
    :10439000FF00FF00FF00FF00FF00FF00FF00FF0025
    :1043A000FF00FF00FF00FF00FF00FF00FF00FF0015
    :1043B000FF00FF00FF00FF00FF00FF00FF00FF0005
    :1043C000FF00FF00FF00FF00FF00FF00FF00FF00F5
    :1043D000FF00FF00FF00FF00FF00FF00FF00FF00E5
    :1043E000FF00FF00FF00FF00FF00FF00FF00FF00D5
    :1043F000FF00FF00FF00FF00FF00FF00FF00FF00C5
    :02400E00D430AC
    :08400000FF3FFF3FFF3FFF3FC0
    :00000001FF

  2. #2
    Join Date
    Feb 2006
    Location
    Gilroy, CA
    Posts
    1,530


    Did you find this post helpful? Yes | No

    Default

    Great question! I too will wait for a better answer. But here goes.....

    The pickit2 also has a uart tool. If you can spare the pre-defined pin, you could have the pic device read out its own eeprom data in coma delimited form (using serout), then click the log to file button, then open up the comma delimited file in excel.

    Not too bad, but would be nice not to have to add serout. Might need to write a visual basic program to parse it?
    http://www.scalerobotics.com

Similar Threads

  1. Data EEPROM gets clobbered during programming
    By BrianT in forum mel PIC BASIC Pro
    Replies: 5
    Last Post: - 18th July 2008, 02:46
  2. Big characters on HD44780 4x20
    By erpalma in forum mel PIC BASIC Pro
    Replies: 23
    Last Post: - 7th January 2007, 02:21
  3. LCD + bar graph
    By DynamoBen in forum mel PIC BASIC Pro
    Replies: 13
    Last Post: - 5th October 2005, 14:50
  4. Internal EEPROM Read/write Addressing Errors with 18F PIC's
    By Melanie in forum FAQ - Frequently Asked Questions
    Replies: 18
    Last Post: - 12th July 2005, 19:42
  5. Sinus calculating !
    By Don Mario in forum mel PIC BASIC Pro
    Replies: 29
    Last Post: - 28th November 2004, 23:56

Members who have read this thread : 0

You do not have permission to view the list of names.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts