C# 导出CSV 然后用excel打开,主要是用逗号来分割开每一列,导出时间格式的时候必须要经过字符替换,否则出现乱码。
//文件导出
private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.DefaultExt = "*.csv";
saveFileDialog.AddExtension = true;
saveFileDialog.Filter = "csv files|*.csv";
saveFileDialog.OverwritePrompt = true;
saveFileDialog.CheckPathExists = true;
saveFileDialog.FileName = "Alarm_" + ReplaceChars(DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss"));
DialogResult result = saveFileDialog.ShowDialog();
if (saveFileDialog.FileName != null) //打开保存文件对话框
{
string fileName = save