I have a text file containing a memory dump from an embedded system, which I update after every run (the file is formatted in the Motorola SREC format, but this is not too important). I am using Excel to parse the file to meaningful values and verify the results.
Currently, I open the file in a text editor, select all, copy, then paste into a specified area in the spreadsheet. The formulas in the spreadsheet take care of the rest.
I want to skip the stage of the text editor. What I would like to have is a way to embed (or, more correctly, link) the file contents in the specified cell(s), and let Excel update the fields automatically when the dump file changes (or, at least, update upon a key-press).
Is there a way to do that?
Note: I know it can also be done with Data
/Get External Data
/From File
, but this is not an automatic process either.