+xlsxToCSV

1 files changed, 80 insertions, 0 deletions

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