我要交excel中的第一列的单元格格式分类设置为特殊中的邮政编码格式,请教高手应怎样设置
oExcel.ActiveSheet.Columns(1).NumberFormatLocal = " ??? "
------解决方案--------------------------------------------------------
NumberFormatLocal = " 000000"
------解决方案--------------------------------------------------------
oExcel.ActiveSheet.Columns(1).NumberFormatLocal = "'"
------解决方案--------------------------------------------------------
oExcel.ActiveSheet.Columns(1).NumberFormatLocal = " 000000"
或
oExcel.ActiveSheet.Columns(1).NumberFormatLocal = "@"