Skip to content

Instantly share code, notes, and snippets.

@maacpiash
Created May 2, 2018 15:15
Show Gist options
  • Save maacpiash/dfb4e83516bbfca74133047ede7601a5 to your computer and use it in GitHub Desktop.
Save maacpiash/dfb4e83516bbfca74133047ede7601a5 to your computer and use it in GitHub Desktop.
FuzzyExcelMerger
<Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<OutputType>Exe</OutputType>
<TargetFramework>netcoreapp2.0</TargetFramework>
</PropertyGroup>
<ItemGroup>
<PackageReference Include="ExcelDataReader" Version="3.4.0" />
<PackageReference Include="ExcelDataReader.DataSet" Version="3.4.0" />
</ItemGroup>
</Project>
Microsoft Visual Studio Solution File, Format Version 12.00
# Visual Studio 2012
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "FuzzyExcelMerger", "FuzzyExcelMerger\FuzzyExcelMerger.csproj", "{6275BD77-3814-436D-B291-B5277D9BB4EE}"
EndProject
Global
GlobalSection(SolutionConfigurationPlatforms) = preSolution
Debug|Any CPU = Debug|Any CPU
Release|Any CPU = Release|Any CPU
EndGlobalSection
GlobalSection(ProjectConfigurationPlatforms) = postSolution
{6275BD77-3814-436D-B291-B5277D9BB4EE}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{6275BD77-3814-436D-B291-B5277D9BB4EE}.Debug|Any CPU.Build.0 = Debug|Any CPU
{6275BD77-3814-436D-B291-B5277D9BB4EE}.Release|Any CPU.ActiveCfg = Release|Any CPU
{6275BD77-3814-436D-B291-B5277D9BB4EE}.Release|Any CPU.Build.0 = Release|Any CPU
EndGlobalSection
EndGlobal
namespace FuzzyExcelMerger
{
public struct Location
{
public string Division, District, Thana, Union, Mauza, Area, GeoStatus, StreetAddr, Post;
}
public struct AgeData
{
public int u11, a11, a12, a13, a14, a15, u15;
}
public class Institute
{
public static string[] Guardian = {
"CULTIVATION", "WORKER_SIX", "BUSINESSMAN", "SMALL BUSINESS", "GOVERNMENT SERVICE",
"PRIVATE SERVICE", "DOCTOR", "LAWYER", "TEACHER", "FISHERMAN",
"TATI", "KAMAR-KUMER", "EXPATRIATE", "ENGINEER", "OTHERS"
};
// From info.xls
public string Name { get => name; set => name = value; }
public Location Address { get => address; set => address = value; }
public string StudentType { get => studenttype; set => studenttype = value; }
public string EduLevel { get => edulevel; set => edulevel = value; }
public bool Affiliation { get => affiliation; set => affiliation = value; }
public bool MPO { get => mpo; set => mpo = value; }
// From mpo.xls
public System.DateTime MPOdate { get => mpodate; set => mpodate = value; }
// From age.xls
public AgeData AgeData { get => ageData; set => ageData = value; }
// From guardian.xls
public int[,] GuardianTypes { get => guardiantypes; set => guardiantypes = value; }
// From m-f.xls
public int[] MF_ratio { get => mf_ratio; set => mf_ratio = value; }
// From ethnic.xls
public int Ethnic { get => ethnic; set => ethnic = value; }
#region private backing variables
private string name;
private Location address;
private string studenttype, edulevel;
private bool affiliation, mpo;
private System.DateTime mpodate;
private AgeData ageData;
private int[,] guardiantypes;
private int[] mf_ratio;
private int ethnic;
#endregion
public Institute()
{
guardiantypes = new int[15, 5];
mf_ratio = new int[4];
}
}
}
using System;
using System.IO;
using static System.Console;
using static System.IO.Directory;
namespace FuzzyExcelMerger
{
class Program
{
static void Main(string[] args)
{
string FolderPath = args.Length >= 1 ? args[0] : "/Users/piash/Code/NSU/CSE 470/FuzzyExcelMerger/Datasets";
FileInfo fileInfo = new FileInfo(Path.Combine(FolderPath, "info.xls"));
//using (var package = new ExcelPackage(fileInfo))
//{
// WriteLine(package.Workbook.Worksheets.Count);
//}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment