안녕하세요. 

spread 를 엑셀로 내보내기를 할때에 현재 아래와 같이 하나의 파일로 

내보내기를 하고 있습니다. 하나의 엑셀파일에 spread 2개를 시트별로 나눠서 

저장할수 있는 방법을 확인 부탁드립니다. 

예를 들어 , fpspeard1 는 sheet1에 , fpspeard2 는  sheet2에 저장을 하고 싶습니다. 

SaveFileDialog mDlg = new SaveFileDialog();
          fpSpread1.Sheets[0].Protect = false;
          
          mDlg.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
          mDlg.InitialDirectory = "C:\\Users\\Administrator\\Desktop\\";
          mDlg.FileName = this.Text + "_" + DateTime.Now.ToString("yyyyMMddHHmmss");
          mDlg.FilterIndex = 1;
 
          if (mDlg.ShowDialog() == DialogResult.OK)
          {
              try
              {
                  int rowCnt = fpSpread1.ActiveSheet.RowCount;
                  if (fpSpread1.ActiveSheet.RowCount <= 4) fpSpread1.ActiveSheet.RowCount = 5;
 
 
                      fpSpread1.SaveExcel
                      (
                          mDlg.FileName,
                          FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat
                          | FarPoint.Excel.ExcelSaveFlags.UseCustomPaletteForColorApproximations
                          | FarPoint.Excel.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders
                          | FarPoint.Excel.ExcelSaveFlags.SaveAsFiltered
                          | FarPoint.Excel.ExcelSaveFlags.SaveAsViewed
                      );
 
 
                  fpSpread1.ActiveSheet.RowCount = rowCnt;
 
                  if (DialogResult.OK == ComLib.Confirm_MessageBox("바로 여시겠습니까?", "Do you want to open right?"))
                  {
                      Process process = new Process();
                      process.StartInfo.FileName = mDlg.FileName.ToString();
                      process.Start();
                  }
              }
              catch (Exception xe)
              {
                  MessageBox.Show(xe.Message + "\n" + xe.Data);
 
 
              }  
 
          }
 
          fpSpread1.Sheets[0].Protect = true;