//----------------------------------------------------------------------
// SubRoutine
//----------------------------------------------------------------------
private void editExcelSheet(string sheetName, TaskData td, TaskNoteData tnd, TaskIndData[] tid, PartnersData pd, TaskOp tod)
{
string tempFile = Folder.DefaultLocation() + @"\.~temp.xlsx";
Cursor.Current = Cursors.WaitCursor; // マウスカーソルを砂時計(Wait)
using (oWBook = new XLWorkbook(FileName))
{
// シートを開く
//oWSheet = oWBook.Worksheet(sheetName);
oWSheet = oWBook.Worksheet(1);
// 編集
//MessageBox.Show("Excel書込み開始");
editTaskDataPart(td);
editTaskNoteDataPart(tnd);
editTaskIndDataPart(tid);
editPartnersDataPart(pd);
editPersonsDataPart(tod);
// 保存
oWBook.SaveAs(tempFile); // Excel保存
}
Cursor.Current = Cursors.Default; // マウスカーソルを戻す
System.Diagnostics.Process.Start("Excel.exe", tempFile); // 表示用Excel
//if (File.Exists(tempFile)) File.Delete(tempFile);
}
private void editTaskNoteDataPart(TaskNoteData tnd)
{
if (tnd == null)
{
return;
}
if (tnd.Note == null || tnd.Note == "" || tnd.Note == " ")
{
return;
}
string[] nLine = tnd.Note.Split(new[] { Environment.NewLine }, StringSplitOptions.None);
int i = 0;
foreach (string item in nLine)
{
oWSheet.Cell(24 + i, 2).Value = item;
i++;
}
}
//---------------------------------------------------------/
// Method
//---------------------------------------------------------/
public void ExcelFile(TaskData td, TaskNoteData tnd, TaskIndData[] tid, PartnersData pd, TaskOp tod)
{
editExcelSheet("TaskTransfer", td, tnd, tid, pd, tod);
}
