13 files changed, 556 insertions, 0 deletions
diff --git a/Tools/XlsxToCsv/.gitignore b/Tools/XlsxToCsv/.gitignore
new file mode 100644
index 0000000..57a1574
--- /dev/null
+++ b/Tools/XlsxToCsv/.gitignore
@@ -0,0 +1,196 @@
+## Ignore Visual Studio temporary files, build results, and
+## files generated by popular Visual Studio add-ons.
+
+# User-specific files
+*.suo
+*.user
+*.userosscache
+*.sln.docstates
+
+# User-specific files (MonoDevelop/Xamarin Studio)
+*.userprefs
+
+# Build results
+[Dd]ebug/
+[Dd]ebugPublic/
+[Rr]elease/
+[Rr]eleases/
+x64/
+x86/
+build/
+bld/
+[Bb]in/
+[Oo]bj/
+
+# Visual Studo 2015 cache/options directory
+.vs/
+
+# MSTest test Results
+[Tt]est[Rr]esult*/
+[Bb]uild[Ll]og.*
+
+# NUNIT
+*.VisualState.xml
+TestResult.xml
+
+# Build Results of an ATL Project
+[Dd]ebugPS/
+[Rr]eleasePS/
+dlldata.c
+
+*_i.c
+*_p.c
+*_i.h
+*.ilk
+*.meta
+*.obj
+*.pch
+*.pdb
+*.pgc
+*.pgd
+*.rsp
+*.sbr
+*.tlb
+*.tli
+*.tlh
+*.tmp
+*.tmp_proj
+*.log
+*.vspscc
+*.vssscc
+.builds
+*.pidb
+*.svclog
+*.scc
+
+# Chutzpah Test files
+_Chutzpah*
+
+# Visual C++ cache files
+ipch/
+*.aps
+*.ncb
+*.opensdf
+*.sdf
+*.cachefile
+
+# Visual Studio profiler
+*.psess
+*.vsp
+*.vspx
+
+# TFS 2012 Local Workspace
+$tf/
+
+# Guidance Automation Toolkit
+*.gpState
+
+# ReSharper is a .NET coding add-in
+_ReSharper*/
+*.[Rr]e[Ss]harper
+*.DotSettings.user
+
+# JustCode is a .NET coding addin-in
+.JustCode
+
+# TeamCity is a build add-in
+_TeamCity*
+
+# DotCover is a Code Coverage Tool
+*.dotCover
+
+# NCrunch
+_NCrunch_*
+.*crunch*.local.xml
+
+# MightyMoose
+*.mm.*
+AutoTest.Net/
+
+# Web workbench (sass)
+.sass-cache/
+
+# Installshield output folder
+[Ee]xpress/
+
+# DocProject is a documentation generator add-in
+DocProject/buildhelp/
+DocProject/Help/*.HxT
+DocProject/Help/*.HxC
+DocProject/Help/*.hhc
+DocProject/Help/*.hhk
+DocProject/Help/*.hhp
+DocProject/Help/Html2
+DocProject/Help/html
+
+# Click-Once directory
+publish/
+
+# Publish Web Output
+*.[Pp]ublish.xml
+*.azurePubxml
+# TODO: Comment the next line if you want to checkin your web deploy settings 
+# but database connection strings (with potential passwords) will be unencrypted
+*.pubxml
+*.publishproj
+
+# NuGet Packages
+*.nupkg
+# The packages folder can be ignored because of Package Restore
+**/packages/*
+# except build/, which is used as an MSBuild target.
+!**/packages/build/
+# Uncomment if necessary however generally it will be regenerated when needed
+#!**/packages/repositories.config
+
+# Windows Azure Build Output
+csx/
+*.build.csdef
+
+# Windows Store app package directory
+AppPackages/
+
+# Others
+*.[Cc]ache
+ClientBin/
+[Ss]tyle[Cc]op.*
+~$*
+*~
+*.dbmdl
+*.dbproj.schemaview
+*.pfx
+*.publishsettings
+node_modules/
+bower_components/
+
+# RIA/Silverlight projects
+Generated_Code/
+
+# Backup & report files from converting an old project file
+# to a newer Visual Studio version. Backup files are not needed,
+# because we have git ;-)
+_UpgradeReport_Files/
+Backup*/
+UpgradeLog*.XML
+UpgradeLog*.htm
+
+# SQL Server files
+*.mdf
+*.ldf
+
+# Business Intelligence projects
+*.rdl.data
+*.bim.layout
+*.bim_*.settings
+
+# Microsoft Fakes
+FakesAssemblies/
+
+# Node.js Tools for Visual Studio
+.ntvs_analysis.dat
+
+# Visual Studio 6 build log
+*.plg
+
+# Visual Studio 6 workspace options file
+*.opt
diff --git a/Tools/XlsxToCsv/App.config b/Tools/XlsxToCsv/App.config
new file mode 100644
index 0000000..74ade9d
--- /dev/null
+++ b/Tools/XlsxToCsv/App.config
@@ -0,0 +1,6 @@
+<?xml version="1.0" encoding="utf-8"?>
+<configuration>
+    <startup> 
+        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
+    </startup>
+</configuration>
diff --git a/Tools/XlsxToCsv/Excel.dll b/Tools/XlsxToCsv/Excel.dll
new file mode 100644
index 0000000..6dfba44
--- /dev/null
+++ b/Tools/XlsxToCsv/Excel.dll
diff --git a/Tools/XlsxToCsv/ExcelConvert.cs b/Tools/XlsxToCsv/ExcelConvert.cs
new file mode 100644
index 0000000..129bb66
--- /dev/null
+++ b/Tools/XlsxToCsv/ExcelConvert.cs
@@ -0,0 +1,80 @@
+using Excel;
+using System.Collections.Generic;
+using System.Data;
+using System.IO;
+using System.Text.RegularExpressions;
+
+namespace xlsxToCsv
+{
+    public class ExcelConvert
+    {
+        private DataSet result = new DataSet();
+
+        public bool Convert(string src, string tar)
+        {
+            GetExcelData(src);
+            return ConverToCSV(tar);
+        }
+
+        private void GetExcelData(string file)
+        {
+            if (file.EndsWith(".xlsx"))
+            {
+                // Reading from a binary Excel file (format; *.xlsx)
+                FileStream stream = File.Open(file, FileMode.Open, FileAccess.Read);
+                IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
+                result = excelReader.AsDataSet();
+                excelReader.Close();
+            }
+
+            if (file.EndsWith(".xls"))
+            {
+                // Reading from a binary Excel file ('97-2003 format; *.xls)
+                FileStream stream = File.Open(file, FileMode.Open, FileAccess.Read);
+                IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
+                result = excelReader.AsDataSet();
+                excelReader.Close();
+            }
+
+            List<string> items = new List<string>();
+            for (int i = 0; i < result.Tables.Count; i++)
+                items.Add(result.Tables[i].TableName.ToString());
+        }
+
+        private bool ConverToCSV(string toFilePath)
+        {
+            int index = 0;
+            // sheets in excel file becomes tables in dataset
+            // result.Tables[0].TableName.ToString(); // to get sheet name (table name)
+
+            string a = "";
+            int row_no = 0;
+            if (result.Tables.Count == 0)
+            {
+                return false;
+            }
+            while (row_no < result.Tables[index].Rows.Count)
+            {
+                for (int i = 0; i < result.Tables[index].Columns.Count; i++)
+                {
+                    if (i - 1 < result.Tables[index].Columns.Count)
+                    {
+                        a += result.Tables[index].Rows[row_no][i].ToString() + ",";
+                    } else
+                    {
+                        a += result.Tables[index].Rows[row_no][i].ToString();
+                    }
+                }
+                row_no++;
+                a = Regex.Replace(a, ",*$", "");
+                a += "\n";
+            }
+            string output = toFilePath;
+            StreamWriter csv = new StreamWriter(@output, false);
+            csv.Write(a);
+            csv.Close();
+
+            return true;
+        }
+    }
+}
+\ No newline at end of file
diff --git a/Tools/XlsxToCsv/ICSharpCode.SharpZipLib.dll b/Tools/XlsxToCsv/ICSharpCode.SharpZipLib.dll
new file mode 100644
index 0000000..e829ebf
--- /dev/null
+++ b/Tools/XlsxToCsv/ICSharpCode.SharpZipLib.dll
diff --git a/Tools/XlsxToCsv/ILMerge.bat b/Tools/XlsxToCsv/ILMerge.bat
new file mode 100644
index 0000000..4c94669
--- /dev/null
+++ b/Tools/XlsxToCsv/ILMerge.bat
@@ -0,0 +1,3 @@
+@rem exe���Ͽ� dll�� ��ġ��
+@rem Download http://www.microsoft.com/en-us/download/confirmation.aspx?id=17630
+"C:\Program Files (x86)\Microsoft\ILMerge\ILMerge.exe" bin\release\xlsxToCsv.exe Excel.dll ICSharpCode.SharpZipLib.dll /out:xlsxToCsv.exe /lib:"C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0" /targetplatform:v4,"C:\Windows\Microsoft.NET\Framework64\v4.0.30319"
+\ No newline at end of file
diff --git a/Tools/XlsxToCsv/Program.cs b/Tools/XlsxToCsv/Program.cs
new file mode 100644
index 0000000..29968e1
--- /dev/null
+++ b/Tools/XlsxToCsv/Program.cs
@@ -0,0 +1,101 @@
+using System;
+using System.Collections.Generic;
+using System.Diagnostics;
+using System.IO;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace xlsxToCsv
+{
+    class Program
+    {
+        static ExcelConvert excelConvert = new ExcelConvert();
+
+        static int fileList()
+        {
+            var allfiles = System.IO.Directory.GetFiles(".", "*.*", System.IO.SearchOption.AllDirectories).Where(s => s.EndsWith(".xls") || s.EndsWith(".xlsx"));
+            if ( allfiles.Count() == 0)
+            {
+                Console.WriteLine("File not found..");
+                return 1;
+            }
+            foreach (string src in allfiles)
+            {
+                var tar = Path.ChangeExtension(src, "csv");
+                Console.WriteLine(src + " => " + tar);
+                try {
+                    if(excelConvert.Convert(src, tar) == false)
+                    {
+                        Console.WriteLine("ERROR : ["+src+"] can't read excel file.");
+                    }
+                } catch( InvalidCastException e)
+                {
+                    Console.WriteLine(e.ToString());
+                }
+            }
+            return 0;
+        }
+
+        static void printHelp()
+        {
+            string filename = Process.GetCurrentProcess().ProcessName;
+            Console.WriteLine("Excel to CSV(UTF-8).  \n\r");
+            Console.WriteLine("USING 1.");
+            Console.WriteLine("\t"+ filename);
+            Console.WriteLine("\n\rUSING 2.");
+            Console.WriteLine("\t"+ filename +" [Source FilePath] [Target FilePath] [-h]\n\r");
+            Console.WriteLine("\t  -h\t Display help");
+        }
+
+        static int Main(string[] args)
+        {
+            foreach(string a in args )
+            {
+                if( String.Compare(a, "-h", true) == 0)
+                {
+                    printHelp();
+                    return 0;
+                }
+            }
+
+            if (args.Length != 0 && args.Length != 2)
+            {
+                printHelp();
+                return 1;
+            }
+
+            // 폴더를 검색해서 변경
+            if (args.Length == 0)
+            {
+                return fileList();
+            }
+            
+            // cli file change
+            string srcFile = args[0];
+            string tarFile = args[1];
+
+            if(!File.Exists(srcFile))
+            {
+                Console.WriteLine("File not found. [" + srcFile + "]");
+                return 1;
+            }
+
+            string tarPath = Path.GetDirectoryName(tarFile);
+            if (!Directory.Exists(tarPath) && tarPath.Length > 0)
+            {
+                Console.WriteLine("Target Folder not exist.");
+                return 1;
+            }
+
+            Console.WriteLine(srcFile + " => " + tarFile);
+            if (excelConvert.Convert(srcFile, tarFile) == false)
+            {
+                Console.WriteLine("ERROR : [" + srcFile + "] can't read excel file.");
+                return 1;
+            }
+
+            return 0;
+        }
+    }
+}
diff --git a/Tools/XlsxToCsv/Properties/AssemblyInfo.cs b/Tools/XlsxToCsv/Properties/AssemblyInfo.cs
new file mode 100644
index 0000000..a90ad9e
--- /dev/null
+++ b/Tools/XlsxToCsv/Properties/AssemblyInfo.cs
@@ -0,0 +1,36 @@
+using System.Reflection;
+using System.Runtime.CompilerServices;
+using System.Runtime.InteropServices;
+
+// 어셈블리에 대한 일반 정보는 다음 특성 집합을 통해 
+// 제어됩니다. 어셈블리와 관련된 정보를 수정하려면
+// 이러한 특성 값을 변경하세요.
+[assembly: AssemblyTitle("xlsxToCsv")]
+[assembly: AssemblyDescription("")]
+[assembly: AssemblyConfiguration("")]
+[assembly: AssemblyCompany("")]
+[assembly: AssemblyProduct("xlsxToCsv")]
+[assembly: AssemblyCopyright("Copyright ©  2015")]
+[assembly: AssemblyTrademark("")]
+[assembly: AssemblyCulture("")]
+
+// ComVisible을 false로 설정하면 이 어셈블리의 형식이 COM 구성 요소에 
+// 표시되지 않습니다.  COM에서 이 어셈블리의 형식에 액세스하려면 
+// 해당 형식에 대해 ComVisible 특성을 true로 설정하세요.
+[assembly: ComVisible(false)]
+
+// 이 프로젝트가 COM에 노출되는 경우 다음 GUID는 typelib의 ID를 나타냅니다.
+[assembly: Guid("ac689d65-e66d-4883-9b03-a9cbaf3702f4")]
+
+// 어셈블리의 버전 정보는 다음 네 가지 값으로 구성됩니다.
+//
+//      주 버전
+//      부 버전 
+//      빌드 번호
+//      수정 버전
+//
+// 모든 값을 지정하거나 아래와 같이 '*'를 사용하여 빌드 번호 및 수정 번호가 자동으로 
+// 지정되도록 할 수 있습니다.
+// [assembly: AssemblyVersion("1.0.*")]
+[assembly: AssemblyVersion("1.0.0.0")]
+[assembly: AssemblyFileVersion("1.0.0.0")]
diff --git a/Tools/XlsxToCsv/README.md b/Tools/XlsxToCsv/README.md
new file mode 100644
index 0000000..6752b80
--- /dev/null
+++ b/Tools/XlsxToCsv/README.md
@@ -0,0 +1,42 @@
+# Xlsx To Csv
+Convert excel file to csv file.
+
+csv file encoding : utf-8
+
+## Requirements
+* .net framework 4.0 more
+* Visual Studio 2015
+
+## Support file
+* Excel format : `xlsx`
+* Excel 97-2003 format : `xls`
+
+## How to use
+Convert Excel files to csv read all of the subfolders
+```
+xlsxToCsv.exe
+```
+
+Convert specified Excel files to csv.
+```
+xlsxToCsv.exe [Source file path] [Target file path]
+```
+
+display this help
+```
+xlsxToCsv.exe -h
+```
+
+
+## ILMerge
+ILMerge is a utility for merging multiple .NET assemblies into a single .NET assembly. It works on executables and DLLs alike and comes with several options for controlling the processing and format of the output.
+
+### Requirements
+Download and install ILMerge
+
+>http://www.microsoft.com/en-us/download/details.aspx?id=17630
+
+### Run
+```
+ILMerge.bat
+```
diff --git a/Tools/XlsxToCsv/test.xlsx b/Tools/XlsxToCsv/test.xlsx
new file mode 100644
index 0000000..70d1a20
--- /dev/null
+++ b/Tools/XlsxToCsv/test.xlsx
diff --git a/Tools/XlsxToCsv/xlsxToCsv.csproj b/Tools/XlsxToCsv/xlsxToCsv.csproj
new file mode 100644
index 0000000..50d5de1
--- /dev/null
+++ b/Tools/XlsxToCsv/xlsxToCsv.csproj
@@ -0,0 +1,70 @@
+<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="14.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
+  <PropertyGroup>
+    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+    <ProjectGuid>{AC689D65-E66D-4883-9B03-A9CBAF3702F4}</ProjectGuid>
+    <OutputType>Exe</OutputType>
+    <AppDesignerFolder>Properties</AppDesignerFolder>
+    <RootNamespace>xlsxToCsv</RootNamespace>
+    <AssemblyName>xlsxToCsv</AssemblyName>
+    <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>
+    <FileAlignment>512</FileAlignment>
+    <AutoGenerateBindingRedirects>true</AutoGenerateBindingRedirects>
+    <TargetFrameworkProfile />
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+    <PlatformTarget>AnyCPU</PlatformTarget>
+    <DebugSymbols>true</DebugSymbols>
+    <DebugType>full</DebugType>
+    <Optimize>false</Optimize>
+    <OutputPath>bin\Debug\</OutputPath>
+    <DefineConstants>DEBUG;TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+    <PlatformTarget>AnyCPU</PlatformTarget>
+    <DebugType>pdbonly</DebugType>
+    <Optimize>true</Optimize>
+    <OutputPath>bin\Release\</OutputPath>
+    <DefineConstants>TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <ItemGroup>
+    <Reference Include="Excel">
+      <HintPath>.\Excel.dll</HintPath>
+    </Reference>
+    <Reference Include="ICSharpCode.SharpZipLib">
+      <HintPath>.\ICSharpCode.SharpZipLib.dll</HintPath>
+    </Reference>
+    <Reference Include="System" />
+    <Reference Include="System.Core" />
+    <Reference Include="System.Xml.Linq" />
+    <Reference Include="System.Data.DataSetExtensions" />
+    <Reference Include="Microsoft.CSharp" />
+    <Reference Include="System.Data" />
+    <Reference Include="System.Xml" />
+  </ItemGroup>
+  <ItemGroup>
+    <Compile Include="ExcelConvert.cs" />
+    <Compile Include="Program.cs" />
+    <Compile Include="Properties\AssemblyInfo.cs" />
+  </ItemGroup>
+  <ItemGroup>
+    <None Include="App.config" />
+  </ItemGroup>
+  <ItemGroup>
+    <WCFMetadata Include="Service References\" />
+  </ItemGroup>
+  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
+  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 
+       Other similar extension points exist, see Microsoft.Common.targets.
+  <Target Name="BeforeBuild">
+  </Target>
+  <Target Name="AfterBuild">
+  </Target>
+  -->
+</Project>
+\ No newline at end of file
diff --git a/Tools/XlsxToCsv/xlsxToCsv.exe b/Tools/XlsxToCsv/xlsxToCsv.exe
new file mode 100644
index 0000000..3813431
--- /dev/null
+++ b/Tools/XlsxToCsv/xlsxToCsv.exe
diff --git a/Tools/XlsxToCsv/xlsxToCsv.sln b/Tools/XlsxToCsv/xlsxToCsv.sln
new file mode 100644
index 0000000..0f18b94
--- /dev/null
+++ b/Tools/XlsxToCsv/xlsxToCsv.sln
@@ -0,0 +1,22 @@
+
+Microsoft Visual Studio Solution File, Format Version 12.00
+# Visual Studio 14
+VisualStudioVersion = 14.0.23107.0
+MinimumVisualStudioVersion = 10.0.40219.1
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "xlsxToCsv", "xlsxToCsv.csproj", "{AC689D65-E66D-4883-9B03-A9CBAF3702F4}"
+EndProject
+Global
+	GlobalSection(SolutionConfigurationPlatforms) = preSolution
+		Debug|Any CPU = Debug|Any CPU
+		Release|Any CPU = Release|Any CPU
+	EndGlobalSection
+	GlobalSection(ProjectConfigurationPlatforms) = postSolution
+		{AC689D65-E66D-4883-9B03-A9CBAF3702F4}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{AC689D65-E66D-4883-9B03-A9CBAF3702F4}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{AC689D65-E66D-4883-9B03-A9CBAF3702F4}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{AC689D65-E66D-4883-9B03-A9CBAF3702F4}.Release|Any CPU.Build.0 = Release|Any CPU
+	EndGlobalSection
+	GlobalSection(SolutionProperties) = preSolution
+		HideSolutionNode = FALSE
+	EndGlobalSection
+EndGlobal