D dadabox Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-22 #2 ExcelDE_Worksheet.range[a:a].select; ExcelDE_app.selection.numberFormatLocal := '@';/设置成文本 ExcelDE_app.selection.wraptext := true; //自动换行 ExcelDE_app.selection.VerticalAlignment := xlTop;//文字顶格 ExcelDE_app.Selection.EntireColumn.AutoFit; //列自动调整
ExcelDE_Worksheet.range[a:a].select; ExcelDE_app.selection.numberFormatLocal := '@';/设置成文本 ExcelDE_app.selection.wraptext := true; //自动换行 ExcelDE_app.selection.VerticalAlignment := xlTop;//文字顶格 ExcelDE_app.Selection.EntireColumn.AutoFit; //列自动调整
P pt_email Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-22 #3 设置NumberFormat := '@',其实最好在Excel里录制宏看一看