private void Btn_Excel_Save_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
saveFile.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
saveFile.FilterIndex = 1;
if (saveFile.ShowDialog() == DialogResult.OK)
{
fpSpread1.SaveExcel(saveFile.FileName, FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders);
MessageBox.Show("저장이 완료 되었습니다.");
}
}
catch (Exception)
{
MessageBox.Show("Excel Save Error");
}
}
private void Btn_Excel_Load_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog openFile = new OpenFileDialog();
openFile.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
openFile.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
openFile.FilterIndex = 1;
if (openFile.ShowDialog() == DialogResult.OK)
{
fpSpread1.OpenExcel(openFile.FileName);
MessageBox.Show("파일을 불러왔습니다.");
}
}
catch (Exception)
{
MessageBox.Show("Excel Load Error");
}
}