VisualStudio\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u30de\u30cd\u30fc\u30b8\u30e3\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3078 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
\u5f15\u6570\u3067\u6e21\u3055\u308c\u305f\u30d1\u30b9\u306e\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u6587\u5b57\u5217\u306e\u914d\u5217\u3068\u3057\u3066\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002
\u30d8\u30c3\u30c0\u30fc\u7b49\u3092\u8aad\u307f\u98db\u3070\u305b\u308b\u3088\u3046\u306b\u884c\u3001\u5217\u3092\u305d\u308c\u305e\u308c\u4e0a\u3001\u5de6\u304b\u3089\u3044\u304f\u3064\u8aad\u307f\u98db\u3070\u3059\u304b\u3092\u5909\u6570”skip\uff5e\uff5e”\u3067\u6307\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
private static string[] ReadExcelData(string file_path)\n {\n List<string> lines = new List<string>();\n var file = new FileInfo(file_path);\n using (FileStream fs = file.Open(FileMode.Open))\n {\n\n IExcelDataReader reader;\n\n if (file.Extension.Equals(\".xls\"))\n {\n reader = ExcelDataReader.ExcelReaderFactory.CreateBinaryReader(fs);\n }\n else\n if (file.Extension.Equals(\".xlsx\"))\n {\n reader = ExcelDataReader.ExcelReaderFactory.CreateOpenXmlReader(fs);\n }\n else\n {\n throw new Exception(\"\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u62e1\u5f35\u5b50\");\n }\n\n var conf = new ExcelDataSetConfiguration\n {\n ConfigureDataTable = _ => new ExcelDataTableConfiguration\n {\n UseHeaderRow = false\n }\n };\n\n var dataSet = reader.AsDataSet(conf);\n var dataTable = dataSet.Tables[0];\n\n int rowsLen = dataTable.Rows.Count;\n int colsLen = dataTable.Columns.Count;\n\n for (int row = 0; row < rowsLen; row++)\n {\n if ((row < skipRows))\n {\n continue;\n }\n List<string> line = new List<string>();\n StringBuilder sb = new StringBuilder();\n sb.Clear();\n for (int col = 0; col < colsLen; col++)\n {\n if ((col < skipCols))\n {\n continue;\n }\n var data = dataTable.Rows[row][col];\n line.Add(data.ToString());\n }\n string lineStr = string.Join(\",\", line.ToArray());\n lines.Add(lineStr);\n }\n string[] linesArray = lines.ToArray();\n\n fs.Close();\n return linesArray;\n }\n }<\/code><\/pre>\n\n\n\n\u30e1\u30a4\u30f3\u95a2\u6570\u3067\u3059\u3002
\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u5f15\u6570\u3067\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b\u304b\u3001
.exe\u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u30c9\u30e9\u30c3\u30b0\u30a2\u30f3\u30c9\u30c9\u30ed\u30c3\u30d7\u3059\u308b\u3053\u3068\u3067
\u6307\u5b9a\u3057\u305f\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u3067\u51fa\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u51fa\u529b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3084\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u5909\u66f4\u3059\u308b\u305f\u3073\u306b
\u518d\u30b3\u30f3\u30d1\u30a4\u30eb\u3059\u308b\u5fc5\u8981\u304c\u7121\u3044\u3088\u3046\u306b\u3001
\u305d\u308c\u305e\u308c\u5916\u90e8\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u8a2d\u5b9a\u3092\u8aad\u307f\u8fbc\u307f\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002
\u53ef\u5909\u9577\u5f15\u6570\u306e\u6587\u5b57\u5217\u304b\u3089\u62e1\u5f35\u5b50\u3092\u30c1\u30a7\u30c3\u30af\u3057
\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u5f15\u6570\u3067\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3068\u3001
\u30c9\u30e9\u30c3\u30b0\u30a2\u30f3\u30c9\u30c9\u30ed\u30c3\u30d7\u3067\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306e\u4e21\u65b9\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
static void Main(string[] args)\n {\n\n string[] files = System.Environment.GetCommandLineArgs();\n\n \/\/ \u7dcf\u5408\u8a2d\u5b9a\n GeneralSetting generalSetting = loadGeneralSetting();\n skipRows = generalSetting.skip_rows;\n skipCols = generalSetting.skip_cols;\n\n if (files.Length > 0)\n {\n \n if (Directory.Exists(generalSetting.output_directry) == false)\n {\n Directory.CreateDirectory(generalSetting.output_directry);\n }\n\n int targetIndex = 0;\n if (files[targetIndex].EndsWith(\".exe\"))\n {\n targetIndex++;\n }\n if (files[targetIndex] != null)\n {\n mFilePath = files[targetIndex];\n string[] source = ReadExcelData(mFilePath);\n\n int len = source.Length;\n \n string outputPath = string.Concat(generalSetting.output_directry, generalSetting.output_file);\n using (StreamWriter writer = new StreamWriter(outputPath, false, Encoding.UTF8))\n {\n for (int i = 0; i < len; i++)\n {\n writer.WriteLine(source[i]);\n }\n }\n }\n }\n return;\n }<\/code><\/pre>\n\n\n\nExcelDataReader\u306e\u304a\u304b\u3052\u3067\u304b\u306a\u308a\u7c21\u5358\u306b
\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30bb\u30eb\u306e\u6587\u5b57\u5217\u3092\u8aad\u307f\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n
Excel\u306bCSV\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u51fa\u529b\u3059\u308b\u6a5f\u80fd\u304c\u3042\u308b\u306e\u3067\u3001
\u3053\u306e\u307e\u307e\u3060\u3068\u3042\u307e\u308a\u5229\u7528\u3059\u308b\u3053\u3068\u306f\u306a\u3055\u305d\u3046\u3067\u3059\u306d\u3002<\/p>\n\n\n\n
\u6c34\u66dc\u62c5\u5f53:Tanaka<\/p>\n
\n <\/g:plusone><\/div>\n
![\"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"](\"\/\/b.hatena.ne.jp\/images\/entry-button\/button-only@2x.png\")
<\/a>