Com.Aote.ObjectTools.ExcelObj.Export C# (CSharp) 메소드

        public void Export()
        {
            IsBusy = true;
            rowIndex = 1;
            coulmnIndex = 1;
            index = 0;
            try
            {
                dynamic excel = AutomationFactory.CreateObject("Excel.Application");
                excel.workbooks.Add();
                dynamic sheet = excel.ActiveSheet;
                //加载Excel表头数据
                for (int i = 0; i < Source.Columns.Count; ++i)
                {
                    dynamic headerCell = sheet.Cells[rowIndex, coulmnIndex + i];
                    //把当前Grid中表头信息赋值给Excel表头.
                    headerCell.Value = Source.Columns[i].Header;
                    headerCell.Font.Bold = true;//加粗
                    //headerCell.Interior.Color = 0xFF00;//设置背景颜色
                }
                char[] c = new char[] {','};
                string[] objs = Bind.Split(c);
                PagedObjectList pol = (PagedObjectList)Source.ItemsSource;
                pol.DataLoaded += (o, e) =>
                {
                    //加载展示数据
                    Load(objs, sheet, pol, excel);
                };
                //加载第一页
                pol.PageIndex = 0;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error generating excel: " + ex.Message);
            }
        }