/某个范围
Sheet.Range['A'+IntToStr(1), 'B'+IntToStr(1)].Select
Excel.Selection.NumberFormatLocal = "@"
//c列
Sheet.Cols['c'+':'+'c'].Select;
Excel.Selection.NumberFormatLocal = "yyyy-m-d"
//7行
Sheet.Rows[inttostr(7)+':'+inttostr(7)].Select;
Excel.Selection.NumberFormatLocal = "yyyy-m-d"
Excel.Selection.NumberFormatLocal = "@" 是设置文本格
Selection.NumberFormatLocal = "0.00%"百分比
Excel.Selection.NumberFormatLocal = "yyyy-m-d"日期
Excel.Selection.NumberFormatLocal = "h:mm;@"时间
Excel.Selection.NumberFormatLocal = "0.00_ "数值
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。