EEPROM HEX File to Excel & Excel To EEPROM HEX File

[easy electronics]

i want to write EEPROM like 24c16 , 24c32 , 24c64 from Microsoft EXeL Data.

i am going to use Exel software to take data from user then i want to make a hex file from Exel file to write eeprom with user entered data.

I want to know hex file format.
i have googled but confused about hex file protocol (format).

 

[ads-ee]

re: EEPROM HEX File to Excel & Excel To EEPROM HEX File

Seems like a very good description with all the bit fields defined if you read the wiki page on the format.

A record (line of text) consists of six fields (parts) that appear in order from left to right:

1.Start code, one character, an ASCII colon ':'.
2. Byte count, two hex digits, indicating the number of bytes (hex digit pairs) in the data field. The maximum byte count is 255 (0xFF). 16 (0x10) and 32 (0x20) are commonly used byte counts.
3. Address, four hex digits, representing the 16-bit beginning memory address offset of the data. The physical address of the data is computed by adding this offset to a previously established base address, thus allowing memory addressing beyond the 64 kilobyte limit of 16-bit addresses. The base address, which defaults to zero, can be changed by various types of records. Base addresses and address offsets are always expressed as big endian values.
4. Record type (see record types below), two hex digits, 00 to 05, defining the meaning of the data field.
5. Data, a sequence of n bytes of data, represented by 2n hex digits. Some records omit this field (n equals zero). The meaning and interpretation of data bytes depends on the application.
6. Checksum, two hex digits, a computed value that can be used to verify the record has no errors.