public void ValidateColumnNameUniquenessTest()
{
_excelDocPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + @"\Files\seiseki.xlsx";
_excelReader = new ExcelReader(_excelDocPath, 50);
Assert.IsFalse(_excelReader == null, "_excelReaderのインスタンスが作成されていません。");
Trace.WriteLine("ExcelReaderのコンストラクタが実行されました。");
string outputMessage;
bool unique = _excelReader.ValidateColumnNameUniqueness(out outputMessage, 2, "中2-1評価");
Assert.IsTrue(unique);
}
public void GetSheetsTest()
{
_excelDocPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + @"\Files\seiseki.xlsx";
_excelReader = new ExcelReader(_excelDocPath, 50);
Assert.IsFalse(_excelReader == null, "_excelReaderのインスタンスが作成されていません。");
Trace.WriteLine("ExcelReaderのコンストラクタが実行されました。");
List<string> sheets = _excelReader.GetSheets();
Debug.WriteLine("シートの数：{0}", sheets.Count);
Assert.IsTrue(sheets.Count > 0);
}
public void GetStudentNamesTest()
{
_excelDocPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + @"\Files\seiseki.xlsx";
_excelReader = new ExcelReader(_excelDocPath, 50);
Assert.IsFalse(_excelReader == null, "_excelReaderのインスタンスが作成されていません。");
Trace.WriteLine("ExcelReaderのコンストラクタが実行されました。");
Dictionary<int, string> students = _excelReader.GetIdNames("中2-1評価", 4);
foreach (var student in students)
{
Debug.WriteLine(student.Value);
}
Assert.IsTrue(students.Count > 0);
}
public DataValidator(ExcelToWordMapping data, ExcelReader excelReader)
{
_data = data;
_sheets = excelReader.GetSheets();
_excelReader = excelReader;
}
private void OpenMappingWindow()
{
try
{
if (String.IsNullOrEmpty(Settings.Default.WordDocTemplatePath))
{
DialogResult dr = MessageBox.Show("ワードの雛形が選択されていません。ワードの雛形を選択しますか？", Settings.Default.AppName, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
if ((_data.MappingFile.Count == 0) || (String.IsNullOrEmpty(_data.MappingFile[0].WordTemplateFilePath)))
{
LoadWordTemplate();
return;
}
}
else
{
return;
}
}
List<string> refSheets = (from Worksheet sheet in ExcelApp.Sheets select sheet.Name).ToList();
if (_excelReader == null)
{
_excelReader = new ExcelReader(ExcelApp.Application.ActiveWorkbook, Settings.Default.MaxScanColumnNumber);
Settings.Default.ExcelFilePath = ExcelApp.Application.ActiveWorkbook.FullName;
}
var frmMapping = new frmMapping(_excelReader, refSheets, _data);
frmMapping.ShowDialog();
if (frmMapping.DoSeisei)
{
SeiseiProcess();
}
}
catch (Exception exp)
{
ExceptionHandler.Handle(exp);
}
}
public void LoadInitialUi()
{
btnLoadWordTemplate.OnClick -= btnLoadWordTemplate_OnClick;
btnLoadWordTemplate.OnClick += btnLoadWordTemplate_OnClick;
btnLoadExistingMapping.OnClick -= btnLoadExistingMapping_OnClick;
btnLoadExistingMapping.OnClick += btnLoadExistingMapping_OnClick;
btnMapping.OnClick -= btnMapping_OnClick;
btnMapping.OnClick += btnMapping_OnClick;
btnSeisei.OnClick -= btnSeisei_OnClick;
btnSeisei.OnClick += btnSeisei_OnClick;
btnSettings.OnClick -= btnSettings_OnClick;
btnSettings.OnClick += btnSettings_OnClick;
btnViewLog.OnClick -= btnViewLog_OnClick;
btnViewLog.OnClick += btnViewLog_OnClick;
btnHelp.OnClick -= btnHelp_OnClick;
btnHelp.OnClick += btnHelp_OnClick;
btnRegister.OnClick -= btnRegister_OnClick;
btnRegister.OnClick += btnRegister_OnClick;
btnScriptList.OnClick -= btnScriptList_OnClick;
btnScriptList.OnClick += btnScriptList_OnClick;
//アプリが立ち上がったところなので、ワードへのパスは空にしておく。
//Settings.Default.WordDocTemplatePath = String.Empty;
if (_data == null)
_data = new ExcelToWordMapping();
_log.Info("ExcelReaderを読み込んでいます。");
if (ExcelApp != null)
{
if (ExcelApp.Application.ActiveWorkbook == null)
{
_log.Info("ActiveWorkbookはnull値を返しました。");
return;
}
if (_excelReader == null)
_excelReader = new ExcelReader(ExcelApp.Application.ActiveWorkbook, Settings.Default.MaxScanColumnNumber);
Settings.Default.ExcelFilePath = ExcelApp.Application.ActiveWorkbook.FullName;
}
Settings.Default.MappingDataFilePath = String.Empty;
}
public ReportingGenerator(ExcelToWordMapping mappingData, ExcelReader excelReader)
{
_mappingData = mappingData;
_excelReader = excelReader;
Initialize();
}
