保存Excel文件

         /// <summary>
        /// 保存Excel文件
        /// </summary>
        public void SaveExcel()
        {
            if (string.IsNullOrEmpty(strFilePathAndFileName))
            {
                MessageBox.Show("操作有误,请联系管理员!");
            }
            else
            {
                try
                {

                    wbb.SaveAs(strFilePathAndFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

                }
                catch (Exception)
                {

                    MessageBox.Show("操作有误,请联系管理员!");
                }

            }
        }

posted @ 2009-09-21 13:44  汉城  阅读(437)  评论(0编辑  收藏  举报