コード例 #1
0
        public void ExtractBaseMegTest()
        {
            string type = "高风险";           //基金类型
            string scale = "37.13";  //规模

            FundQueryRT target = new FundQueryRT();
            target.GetFundPage("000031");//华夏复兴基金代码
            target.ExtractBaseMeg();

            Assert.AreEqual(type, target.FundType);
            Assert.AreEqual(scale, target.Scale);
        }
コード例 #2
0
        public void SaveBaseMessage(List<FundMsgDownload.BaseMsg> funds)
        {
            ApplicationClass xlsApp = new ApplicationClass();  //创建Excel应用程序对象的一个实例
            Debug.Assert(xlsApp != null);

            //创建Excel对象
            Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application();
            objExcel.Visible = false;

            Object missing = System.Reflection.Missing.Value;    //定义缺省值

            //创建一个新的工作薄,并引用缺省的工作表  创建Excel后不会自动创建新的工作薄(文件)
            Workbook objBook = objExcel.Workbooks.Add(missing);
            Worksheet objSheet = (Worksheet)objBook.Worksheets.get_Item(1);

            //Range对象用于选择一个或多个单元格
            Range objRange;

            //基金信息开始行
            int stateRow = 3;

            objRange = objSheet.get_Range("A1", "F1");
            //合并单元格
            objRange.Merge(0);
            objRange.HorizontalAlignment = XlHAlign.xlHAlignCenter;
            // objRange = objSheet.get_Range("A1", missing);
            objRange.Value2 = "基金基本信息";
            objRange.Font.Size = 20;
            objRange.Font.Bold = true;

            //循环放入列名
            int titleIndex = 1;
            objSheet.Cells[stateRow - 1, titleIndex++] = "基金代码";
            objSheet.Cells[stateRow - 1, titleIndex++] = "基金名称缩写";
            objSheet.Cells[stateRow - 1, titleIndex++] = "基金名称";
            objSheet.Cells[stateRow - 1, titleIndex++] = "基金类型";

            //后期加入的代码f
            objSheet.Cells[stateRow - 1, titleIndex++] = "风险类型";
            objSheet.Cells[stateRow - 1, titleIndex++] = "规模";
            FundQueryRT fqRT = new FundQueryRT();

            //循环放入所有数据
            int iRow = stateRow;
            foreach (var fund in funds)
            {
                int icel = 1;//列号

                //向单元格中插入数据
                objSheet.Cells[iRow, icel++] = "'" + fund.code;//为了实现左对齐
                objSheet.Cells[iRow, icel++] = fund.abbreviation;
                objSheet.Cells[iRow, icel++] = fund.name;
                objSheet.Cells[iRow, icel++] = fund.type;

                //后期加入的代码
                fqRT.GetFundPage(fund.code);
                fqRT.ExtractBaseMeg();
                objSheet.Cells[iRow, icel++] = fqRT.FundType;
               // objSheet.Cells[iRow, icel++] = fqRT.Custodian;
                objSheet.Cells[iRow, icel++] = fqRT.Scale;

                iRow++;
            }

            objRange = objSheet.get_Range("a2", "d2");

            objRange.EntireColumn.AutoFit();   //自动调整表格大小
            objRange.HorizontalAlignment = XlHAlign.xlHAlignLeft;//将所有单元格左对齐

            //在表格底部添加时间
            objRange = objSheet.get_Range("a" + (iRow + 2).ToString(), "d" + (iRow + 2).ToString());//选中单元格
            objRange.Merge(0);//合并
            objRange.Value2 = DateTime.Now.ToString();//把时间赋值给单元格
            objRange.HorizontalAlignment = XlHAlign.xlHAlignCenter;//中间对齐
            objRange.Cells.Interior.Color = System.Drawing.Color.FromArgb(255, 204, 153).ToArgb();

            this.excelBaseMsgBook = objBook;

            objBook.Saved = true;//保存表格
            DateTime dtime = DateTime.Now;//获取当前时间

            string fileName = dtime.ToString("yyyy-MM-dd hh-mm") + ".xls";
            string fileWay = System.IO.Directory.GetCurrentDirectory() + "\\..\\..\\" + fileName;
            objBook.SaveCopyAs(fileWay);//将表格拷贝到指定路径

            objBook.Close(true, Type.Missing, Type.Missing);//关闭表格
            objExcel = null;//清空Excel
            xlsApp.Quit();//释放资源
            xlsApp = null;
        }