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();
}
