Tribon Vitesse程序的乱码错误信息

Tribon Vitesse程序进行Excel操作或者连接数据库，有时候返回的错误信息是由Excel或者SQL Server发出的，而这些错误显示为乱码。最近使用管支架材料表程序的几个朋友就遇到了这个问题，Log中的现象如下：

 

Script: F:\study\Tribon\pipeProgr\Code\PipeSupportMaterial.py started
[Function] kcs_util.TB_environment_get
[Parameters] ('SB_PROJECT',)
[Return value] M3SP
[Python error] Traceback (most recent call last):
      File "F:\study\Tribon\pipeProgr\Code\PipeSupportMaterial.py", line 86, in ?
          test()
      File "F:\study\Tribon\pipeProgr\Code\PipeSupportMaterial.py", line 75, in test
          mim.Output()
      File "F:\study\Tribon\pipeProgr\Code\PipeSupportMaterial.py", line 58, in Output
          xl = easyExcel.easyExcel('D:/PIPE SUPPORT MATERIAL LIST.xls') # template
      File "F:/study/Tribon/pipeProgr/Code\easyExcel.py", line 18, in __init__
          self.xlBook = self.xlApp.Workbooks.Open(filename)
      File "<COMObject &lt;unknown>&gt;", line 8, in Open
  com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft Office Excel', '\xd5\xd2\xb2\xbb\xb5\xbd\xa1\xb0D:/PIPE SUPPORT MATERIAL LIST.xls\xa1\xb1\xa1\xa3\xc7\xeb\xbc\xec\xb2\xe9\xce\xc4\xbc\xfe\xc3\xfb\xb5\xc4\xc6\xb4\xd0\xb4\xa3\xac\xb2\xa2\xd1\xe9\xd6\xa4\xce\xc4\xbc\xfe\xce\xbb\xd6\xc3\xca\xc7\xb7\xf1\xd5\xfd\xc8\xb7\xa1\xa3\n\n\xc8\xe7\xb9\xfb\xc4\xfa\xd5\xfd\xca\xd4\xcd\xbc\xb4\xd3\xd7\xee\xbd\xfc\xca\xb9\xd3\xc3\xb5\xc4\xce\xc4\xbc\xfe\xc1\xd0\xb1\xed\xd6\xd0\xb4\xf2\xbf\xaa\xb8\xc3\xce\xc4\xbc\xfe\xa3\xac\xc7\xeb\xc8\xb7\xb1\xa3\xb8\xc3\xce\xc4\xbc\xfe\xce\xb4\xb1\xbb\xd6\xd8\xc3\xfc\xc3\xfb\xa1\xa2\xd2\xc6\xb6\xaf\xbb\xf2\xc9\xbe\xb3\xfd\xa1\xa3', 'C:\\Program Files\\Microsoft Office\\Office12\\2052\\XLMAIN11.CHM', 0, -2146827284), None)

 

乱码的字符串可以使用Python的print命令打印出来：

 

&gt;&gt;&gt; print '\xd5\xd2\xb2\xbb\xb5\xbd\xa1\xb0D:/PIPE SUPPORT MATERIAL LIST.xls\xa1\xb1\xa1\xa3\xc7\xeb\xbc\xec\xb2\xe9\xce\xc4\xbc\xfe\xc3\xfb\xb5\xc4\xc6\xb4\xd0\xb4\xa3\xac\xb2\xa2\xd1\xe9\xd6\xa4\xce\xc4\xbc\xfe\xce\xbb\xd6\xc3\xca\xc7\xb7\xf1\xd5\xfd\xc8\xb7\xa1\xa3\n\n\xc8\xe7\xb9\xfb\xc4\xfa\xd5\xfd\xca\xd4\xcd\xbc\xb4\xd3\xd7\xee\xbd\xfc\xca\xb9\xd3\xc3\xb5\xc4\xce\xc4\xbc\xfe\xc1\xd0\xb1\xed\xd6\xd0\xb4\xf2\xbf\xaa\xb8\xc3\xce\xc4\xbc\xfe\xa3\xac\xc7\xeb\xc8\xb7\xb1\xa3\xb8\xc3\xce\xc4\xbc\xfe\xce\xb4\xb1\xbb\xd6\xd8\xc3\xfc\xc3\xfb\xa1\xa2\xd2\xc6\xb6\xaf\xbb\xf2\xc9\xbe\xb3\xfd\xa1\xa3'

找不到"D:/PIPE SUPPORT MATERIAL LIST.xls"。请检查文件名的拼写，并验证文件位置是否正确。
如果您正试图从最近使用的文件列表中打开该文件，请确保该文件未被重命名、移动或删除。

 

看到这些文字问题也就显而易见了。