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