Created
May 2, 2018 15:15
-
-
Save maacpiash/dfb4e83516bbfca74133047ede7601a5 to your computer and use it in GitHub Desktop.
FuzzyExcelMerger
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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]; | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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