- #region"Excel出力"
- if (MessageBox.Show ("Excel输出?","Excel输出",MessageBoxButtons.YesNo ,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2 )!=DialogResult.Yes )
- {
- return;
- }
- else
- {
- try
- {
- SaveFileDialog sa = new SaveFileDialog();
- sa.DefaultExt = "xls";
- sa.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*";
- sa.Title = "Excel 输出";
- sa.FileName = cboBranchCD.SelectedValue.ToString() +txtBranchName.Text.ToString()+"_"+this.txtYearMonth.Text.Remove(4,1);
- sa.RestoreDirectory = true;
- if (sa.ShowDialog() == DialogResult.Cancel)
- {
- return;
- }
- bool ret;
- ret = sprGrossPRDayDpt.SaveExcel( sa.FileName,FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly);
- if (!ret)
- {
- MessageBox.Show("ERROR");
- }
- }
- catch (System.Exception ex)
- {
- MessageBox.Show (ex.Message );
- return;
- }
- }
- }
- #endregion
excel输出
最新推荐文章于 2024-08-19 15:29:40 发布