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
Bookmarks