zhyongquan / dbc2excel

Convert DBC to Excel by VBA

DBC2Excel

Convert DBC to Excel by VBA

password:6lm3crlZu!RLFubaCiSt

Feature

• Add auto filter and merge cells
• Auto group by message
• Highlight transmitter and receiver
• Sort by message name and startbit
• Support both windows and unix file

To do

Performance

File	ECU Nodes	Messages	Signals	Elapsed time(s)
1	8	25	244	22
2	9	72	754	60
3	9	76	1126	67

dbc2excel's Issues

Issue found in DBC2Excel when "Factor" in dbc file is a floating point number

Hello,

I found an Issue in DBC2Excel when the "Factor" in dbc file is a floating point number.
See attached file.
Could you have a look and provide a fix for DBC2Excel please ?
Thanks

long ID display

when ID>0x8000000, only display value after 8

Error when Attempting to convert ~3 MB DBC File

I obtained a runtime error when I tried to convert this ~3 MB dbc. I believe it was this: Overflow (Error 6) [ https://learn.microsoft.com/en-au/office/vba/Language/Reference/User-Interface-Help/overflow-error-6 ].

I was able to quickly overcome this issue by replacing all Integer data type definitions with Long definitions in the VBA module. While this was an easy fix, it did not feel elegant and I did not verify whether making all Integer values Long values instead had any further consequences to it.

I can attempt to recreate this error if needed.

转换单位时出错Ω

dbc文件中原始文本内容为：
"SG_ Res : 1|1@0+ (1,0) [0|1] "Ω" TEL"
用脚本转换时报错，调试发现rline内容为：
"SG_ Res : 1|1@0+ (1,0) [0|1] "娆? TEL"

用的是WPS 2016