在gridview的RowDataBound事件里添加。
如果是第一列,那么索引就是0protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
}
如果是第一列,那么索引就是0protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
}
但你可以在excel里先把那个列的属性设置成"文本"...这样就能保存你说的那些.
如果excel是你自己生成的,那我就不清楚了.你可以考虑放一个默认的excel,
set objExcelApp = server.CreateObject("Excel.Application")
objExcelApp.DisplayAlerts = false
objExcelApp.Application.Visible = false
objExcelApp.Workbooks.Open("aa.xls") '打开Excel模板
set objExcelBook = objExcelApp.ActiveWorkBook
set objExcelSheets = objExcelBook.Worksheets
set objExcelSheet = objExcelBook.Sheets(1)
' ac.NumberFormat = "0_"
response.Write("a1:"&objExcelSheet.Range("b1").value)
objExcelSheet.Range("A1").value="hello"
objExcelBook.Save
objExcelApp.Quit
set objExceApp=Nothing
RanValue.NumberFormatLocal = "#";
不好意思不能帮你解决!~
楼下go on!~
Range("F4").Select
ActiveCell.FormulaR1C1 = "00123"
Range("F4").Select