import?re
import?xlwt


length_of_BO?=?5
str_of_BO?=?‘BO_‘
str_of_SG?=?‘SG_‘
location_of_bo_type?=?0
location_of_bo_id?=?1
location_of_bo_message_name?=?2
location_of_bo_dlc?=?3
location_of_bo_transmitter?=?4

location_of_sg_type?=?0
location_of_sg_name?=?1
location_of_sg_s_bit_size?=?3
location_of_sg_factor?=?4
location_of_sg_max_min?=?5
location_of_sg_unit?=?6
location_of_sg_receiver?=?7

if_show_global?=?0

excel_page_name?=?“Matrix“
tittle_row?=?0
signal_name_col?=?6

excel_tittle?=?（‘Msg?Name\n報文名稱‘?‘Msg?Type\n報文類型‘?‘Msg?ID\n報文標識符‘?‘Msg?Send?Type\n報文發送類型‘
????????????????‘Msg?Cycle?Time?（ms）\n報文周期時間‘?‘Msg?Length?（Byte）\n報文長度‘?‘Signal?Name\n信號名稱‘
????????????????‘Signal?Description\n信號描述‘?“Byte?Order\n排列格式（Intel/Motorola）“?“Start?Byte\n起始字節“
????????????????“Start?Bit\n起始位“?“Signal?Send?Type\n信號發送類型“?“Bit?Length?（Bit）\n信號長度“?“Date?Type\n數據類型“
????????????????“Resolution\n精度“?“Offset\n偏移量“?“Signal?Min.?Value?（phys）\n物理最小值“?“Signal?Max.?Value?（phys）\n物理最大值“
????????????????“Signal?Min.?Value?（Hex）\n總線最小值“?“Signal?Max.?Value?（Hex）\n總線最大值“?“Initial?Value?（Hex）\n初始值“
????????????????“Invalid?Value（Hex）\n無效值“?“Inactive?Value?（Hex）\n非使能值“?“Unit\n單位“?“Signal?Value?Description\n信號值描述“
????????????????“Msg?Cycle?Time?Fast（ms）\n報文發送的快速周期（ms）“?“Msg?Nr.?Of?Reption\n報文快速發送的次數“?“Msg?Delay?Time（ms）\n報文延時時間（ms）“
????????????????）


def?SortFun（x）:
????for?i?in?x:
????????if?“message_id“?in?i:
????????????return?i[“message_id“]
????????????break

def?set_style（?color?=?0?bold?=?Falseitalic?=?False）:
????style?=?xlwt.XFstyle（）??#?初始化樣式
????font?=?xlwt.Font（）??#?為樣式創建字體
????#?字體類型：比如宋體、仿宋也可以是漢儀瘦金書繁
????font.name?=?‘Arial‘
????#?是否為粗體
????font.bold?=?bold
????#?設置字體顏色
????font.colour_index?=?0
????#?字體大小
????font.height?=?200
????#?字體是否斜體
????font.italic?=?italic
????#?字體下劃當值為11時。填充顏色就是藍色
????font.underline?=?0
????#?字體中是否有橫線struck_out
????font.struck_out?=False
????#?定義格式
????style.font?=?font

????##
????borders?=?xlwt.Borders（）
????borders.left?=?0
????borders.right?=?0
????borders.top?=?0
????borders.bottom?=?0
????borders.left?=?xlwt.Borders.THIN
????borders.right?=?xlwt.Borders.THIN
????borders.top?=?xlwt.Borders.THIN
????borders.bottom?=?xlwt.Borders.THIN
????style.borders?=?borders
????##

????alignment?=?xlwt.Alignment（）??#?創建居中
????alignment.horz?=?xlwt.Alignment.HORZ_CENTER??#?可取值:?HORZ_GENERAL?HORZ_LEFT?HORZ_CENTER?HORZ_RIGHT?HORZ_FILLED?HORZ_JUSTIFIED?HORZ_CENTER_ACROSS_SEL?HORZ_DISTRIBUTED
????alignment.vert?=?xlwt.Alignment.VERT_CENTER??#?可取值:?VERT_TOP?VERT_CENTER?VERT_BOTTOM?VERT_JUSTIFIED?VERT_DISTRIBUTED
????alignment.wrap?=?xlwt.Alignment.WRAP_AT_RIGHT??#?自動換行
????style.alignment?=?alignment??#?給樣式添加文字居中屬性

????#?設置背景顏色
????pattern?=?xlwt.Pattern（）
????#?設置背景顏色的模式
????pattern.pattern?=?xlwt.Pattern.SOLID_PATTERN
????#?背景顏色
????pattern.pattern_fore_colour?=?color
????style.pattern?=?pattern

????return?style


#DBC?LOAD?CLASS
class?DbcLoad（object）:
????def?__init__（self?dbc_name_in）:
????????self.dbc_fd

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-14?08:13??dbc2excel-master\
?????文件????????1203??2018-11-14?08:13??dbc2excel-master\.gitignore
?????目錄???????????0??2018-11-14?08:13??dbc2excel-master\.idea\
?????文件?????????185??2018-11-14?08:13??dbc2excel-master\.idea\misc.xml
?????文件?????????260??2018-11-14?08:13??dbc2excel-master\.idea\modules.xml
?????文件?????????180??2018-11-14?08:13??dbc2excel-master\.idea\vcs.xml
?????文件???????17388??2018-11-14?08:13??dbc2excel-master\.idea\workspace.xml
?????文件?????????499??2018-11-14?08:13??dbc2excel-master\.idea\wx02.iml
?????文件??????190616??2018-11-14?08:13??dbc2excel-master\Dbc2Excel使用說明.docx
?????文件???????30208??2018-11-14?08:13??dbc2excel-master\Huanghonglei_dbc.xls
?????文件?????????175??2018-11-14?08:13??dbc2excel-master\README.md
?????目錄???????????0??2018-11-14?08:13??dbc2excel-master\backup\
?????文件???????32935??2018-11-14?08:13??dbc2excel-master\backup\dbc2excel.py
?????文件????????5235??2018-11-14?08:13??dbc2excel-master\backup\dbc2excel_main.py
?????文件????????4286??2018-11-14?08:13??dbc2excel-master\bitbug_favicon.ico
?????文件???????35199??2018-11-14?08:13??dbc2excel-master\dbc2excel.py
?????文件????11882901??2018-11-14?08:13??dbc2excel-master\dbc2excel_main.exe
?????文件????????6699??2018-11-14?08:13??dbc2excel-master\dbc2excel_main.py
?????文件??????????58??2018-11-14?08:13??dbc2excel-master\makefile.txt
?????目錄???????????0??2018-11-14?08:13??dbc2excel-master\source\
?????文件??????148854??2018-11-14?08:13??dbc2excel-master\source\a.bmp
?????文件?????????162??2018-11-14?08:13??dbc2excel-master\~$c2Excel使用說明.docx