본문 바로가기

C# 개인 공부 기록용/정리--메모--필기--출처 모음

Excel 파일 저장하기 & 불러오기

    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");
            }
        }