예제 #1
0
        /// <summary>
        /// 把TreeList内容保存到Excel中
        /// </summary>
        /// <param name="TL">TreeList控件</param>
        public static void SaveTreeListControlExportToExcel(DevExpress.XtraTreeList.TreeList TL)
        {
            SaveFileDialog dlg = new SaveFileDialog();

            dlg.Filter           = "Excel files (*.xlsx)|*.xlsx";
            dlg.FilterIndex      = 0;
            dlg.RestoreDirectory = true;
            //dlg.Title = "保存为Excel文件";
            dlg.Title = new FileHandler().f.tsmiBcwexc.Text;

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                string fileName = dlg.FileName;
                //GV.ExportToExcelOld(Filename);
                TL.ExportToXlsx(fileName);

                //MessageHandler.ShowMessageBox("导出成功");
                MessageHandler.ShowMessageBox(new FileHandler().f.tsmiDccg.Text);
            }
        }