Transmitting the payload hex bytes as is to a excel sheet as it converts to dec

[mjafarin]

Attached is the modified NI-XNET subVI - CAN Frame to Table. Transferring the hex data stream to a file (.txt, .xcl) causes the stream to convert to decimal. How can it be saved in its original hex format? That is the issue. 

[mjafarin]

Excel data sheet for the same program.

[RTSLVU]

I can't see how you are writing to your file but try the %x format so numbers are written as hex numbers instead of the default (floating point decimal %f).

Or posibly the %S so they are writtne as strings, then maybe Excel will not reformat them to decimal.

Also you can highlight the cells and use "format cells" in Excel to change the format to Hex

[mjafarin]

CAN Frame to Table VI reads the data through write delimited spreadsheet VI. Write spreadsheet string is one of the subVIs in delimited speadsheet. I tried changing the formats to %x and %s but it changing back to %d when it starts running. That could be the problem. Now; I think, the issue is how can the default value can be changed and set in the Write delimiyted spreadsheet VI program. You advise is greatly appreciated.    

[crossrulz]

Where is the VI that calls the Write Delimited String?  Does the CAN VI have a format input?

[mjafarin]

Check the first message for 

J1939 - CAN Frame to Table FP.png ‏45 KB

J1939 - CAN Frame to Table BD.png ‏73 KB

[crossrulz]

Since you are already using a modified version, just add a constant to the CAN VI to set the format.  That format is then passed into the Write Delimited Text File.

[RTSLVU]

---

@mjafarin wrote:

CAN Frame to Table VI reads the data through write delimited spreadsheet VI. Write spreadsheet string is one of the subVIs in delimited speadsheet. I tried changing the formats to %x and %s but it changing back to %d when it starts running. That could be the problem. Now; I think, the issue is how can the default value can be changed and set in the Write delimiyted spreadsheet VI program. You advise is greatly appreciated.    

---

Are saying this does not work?

Once you have it in Excel formatting the colums as text makes them lineup left justified.

[RavensFan]

What do you mean it is turning it back to %d?

If you change the constant to %x, it stays, and works.  At least for me in LV 2015.  If it isn't for you, that would be the sign of a major LabVIEW bug.  Unless you are doing something different than what you are describing.

[mjafarin]

In fact this is exactly what is happening. Unless there are some hidden steps/configurations that I am not aware of.