DataLoader.cs (C#) - Codedump.io

Anonymous - 8 months ago

937 0

No description

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

This code is part of multiple code. You can see all code over here.

C#	DataLoader.cs

Embed

using Excel;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Macro_Correlation_Divergence_Arbitrage {
    class DataLoader {
        public DataSet LoadData() {
            FileStream stream = File.Open(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/Stocks.xlsx", FileMode.Open, FileAccess.Read);
            IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
            excelReader.IsFirstRowAsColumnNames = true;
            DataSet result = excelReader.AsDataSet();
            excelReader.Close();
            return result;
        }
    }
}

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

DataLoader.cs

Sign up