private void YamlToExcel(string[] fileNames) { if (fileNames == null) { return; } var fileBaseNames = fileNames.Select(fileName => Path.GetFileName(fileName)); var fileDirNames = fileNames.Select(fileName => Path.GetDirectoryName(fileName)); var fileDirName = fileDirNames.First(); if (!fileDirNames.All(_fileDirName => fileDirName == _fileDirName)) { MessageBox.Show("同じフォルダにあるxlsxファイルのみにして下さい", "エラー"); return; } var setting = LoadSetting(); if (setting == null) { return; } dataExcelFolderBrowserDialog.SelectedPath = DataExcelsDirectoryPath; if (dataExcelFolderBrowserDialog.ShowDialog() == DialogResult.OK) { DataExcelsDirectoryPath = dataExcelFolderBrowserDialog.SelectedPath; } else { return; } var options = new ToOptions(); options.files = fileBaseNames; options.seedInput = SeedPath; options.xlsxInput = fileDirName; options.output = DataExcelsDirectoryPath; options.columnNamesRow = setting.columnNamesRow; options.dataStartRow = setting.dataStartRow; options.engine = setting.engine; options.ignoreColumns = setting.ignoreColumns; options.ignore = setting.ignore; options.only = setting.only; options.subdivide = setting.subdivide; options.mapping = setting.mapping; options.versionColumn = setting.versionColumn; options.requireVersion = setting.requireVersion; options.delete = setting.delete; options.seedExtension = options.seedExtension; options.calcFormulas = setting.calcFormulas; var dialog = new YamlToExcelDialog(options); dialog.ShowDialog(); }
private void YamlToExcel(string[] fileNames) { if (fileNames == null) { return; } var fileBaseNames = fileNames.Select(fileName => Path.GetFileName(fileName)); var fileDirNames = fileNames.Select(fileName => Path.GetDirectoryName(fileName)); var fileDirName = fileDirNames.First(); if (!fileDirNames.All(_fileDirName => fileDirName == _fileDirName)) { MessageBox.Show("同じフォルダにあるxlsxファイルのみにして下さい", "エラー"); return; } var setting = LoadSetting(); if (setting == null) { return; } dataExcelFolderBrowserDialog.SelectedPath = DataExcelsDirectoryPath; if (dataExcelFolderBrowserDialog.ShowDialog() == DialogResult.OK) { DataExcelsDirectoryPath = dataExcelFolderBrowserDialog.SelectedPath; } else { return; } var options = setting.ToOptions( files: fileBaseNames, seedInput: SeedPath, xlsxInput: fileDirName, output: DataExcelsDirectoryPath ); var dialog = new YamlToExcelDialog(options); dialog.ShowDialog(); }