C# 将数据导出到 Excel 时格式化列

Question

我知道这个话题已经被讨论过，但我认为它有一些差异。我的数据库中存储了日期。所以当我将数据表导出到EXCEL时，它显示如下图。

这是 EXCEL 文件的图像:

我只需要添加日期。不包括 HH:MM:SS。我的代码粘贴在下面:

Microsoft.Office.Interop.Excel._Application app = new 
Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel._Worksheet worksheet = null;
worksheet = workbook.Sheets["Sheet1"];
worksheet = workbook.ActiveSheet;
worksheet.Name = "InternDetails";

for (int i = 1; i < dataGridView3.Columns.Count + 1; i++){
    worksheet.Cells[1, i] = dataGridView3.Columns[i - 1].HeaderText;
}

for (int i = 0; i < dataGridView3.Rows.Count; i++){
    for (int j = 0; j < dataGridView3.Columns.Count; j++){
        worksheet.Cells[i + 2, j + 1] = dataGridView3.Rows[i].Cells[j].Value.ToString();
    }
}

var saveFileDialog = new SaveFileDialog();
saveFileDialog.FileName = "Interns";
saveFileDialog.DefaultExt = ".xlsx";

if (saveFileDialog.ShowDialog() == DialogResult.OK){
    workbook.SaveAs(saveFileDialog.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}

感谢您的帮助。

Answer 1

好的，如果您只想显示日期而不显示时间，您应该设置数字格式。看看这样的代码:SomeCell.NumberFormat="yyyy-mm-dd"

它将显示例如:“2018-05-20”