반응형
#region Export to CSV
private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{
//Build the CSV file data as a Comma separated string.
string csv = string.Empty;
//Add the Header row for CSV file.
foreach (DataGridViewColumn column in dtgrdWorkingHoursList.Columns)
{
csv += column.HeaderText + ',';
}
//Add new line.
csv += "\r\n";
//Adding the Rows
foreach (DataGridViewRow row in dtgrdWorkingHoursList.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
//Add the Data rows.
csv += cell.Value.ToString().Replace(",", ";") + ',';
}
//Add new line.
csv += "\r\n";
}
//Exporting to CSV.
// string targetPath = "D:\\";
string fileName = "SalesReport_" + DateTime.Now.ToString("yyyy-MM-dd_hh-mm-ss") + ".csv";
string targetPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string destFile = System.IO.Path.Combine(targetPath, fileName);
// To copy a folder's contents to a new location:
// Create a new target folder, if necessary.
if (!System.IO.Directory.Exists(targetPath))
{
System.IO.Directory.CreateDirectory(targetPath);
}
// Get file name.
string name = saveFileDialog1.FileName;
System.IO.File.WriteAllText(name, csv);
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
//Exporting to xls.
saveFileDialog1.FileName = "WorkedHours_" + UserInfo.usernamWK + "_" + DateTime.Now.ToString("yyyy-MM-dd_HH-mm-ss") + ".csv";
saveFileDialog1.ShowDialog();
}
catch
{
}
}
#endregion
728x90
'Programming > C# - Window' 카테고리의 다른 글
C#/ 연락 이메일 보내기 이벤트 (0) | 2023.10.12 |
---|---|
C#/ [STAThread] (0) | 2023.10.12 |
C#/ 어셈블리(Assembly) 사용 (0) | 2023.10.12 |
C#/ KeyDown 이벤트 핸들러 (0) | 2023.10.12 |
C#/ namsespace(네임스페이스) (0) | 2023.10.12 |