public static void WorkWithMsWord(List<Data> data, Calculation calc) { object oMissing = System.Reflection.Missing.Value; object oEndOfDoc = "\\endofdoc"; /* \endofdoc is a predefined bookmark */ //Start Word and create a new document. Word._Application oWord; Word._Document oDoc; oWord = new Word.Application(); oWord.Visible = true; oDoc = oWord.Documents.Add(ref oMissing, ref oMissing, ref oMissing, ref oMissing); //Insert a paragraph at the beginning of the document. Word.Paragraph oPara1; oPara1 = oDoc.Content.Paragraphs.Add(ref oMissing); oPara1.Range.Text = "Внутрішньолабораторній контроль якості"; oPara1.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter; oPara1.Range.Font.Bold = 1; oPara1.Format.SpaceAfter = 12; //24 pt spacing after paragraph. oPara1.Range.InsertParagraphAfter(); //Insert a paragraph at the end of the document. Word.Paragraph oPara2; object oRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; oPara2 = oDoc.Content.Paragraphs.Add(ref oRng); oPara2.Range.Font.Bold = 0; oPara2.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter; oPara2.Range.Text = "Лабораторія - ЦКДЛ КЗ\"Дніпропетровський клінічний онкологічний центр\" Дніпропетровської обласної ради"; oPara2.Range.ParagraphFormat.SpaceAfter = 1; oPara2.Format.SpaceAfter = 3; oPara2.Range.InsertParagraphAfter(); //Insert another paragraph. Word.Paragraph oPara3; oRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; oPara3 = oDoc.Content.Paragraphs.Add(ref oRng); oPara3.Range.Text = "Показник, що визначається:________________________"; oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft; oPara3.Range.ParagraphFormat.SpaceAfter = 1; oPara3.Range.InsertParagraphAfter(); oPara3.Range.Font.Bold = 0; oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft; oPara3.Range.Text = "Методика:________________________"; oPara3.Range.ParagraphFormat.SpaceAfter = 1; oPara3.Range.InsertParagraphAfter(); oPara3.Range.Font.Bold = 0; oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft; oPara3.Range.Text = "Одиниці вимірювання________ Прилад _________________________________________"; oPara3.Range.ParagraphFormat.SpaceAfter = 1; oPara3.Range.InsertParagraphAfter(); //oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter; oPara2.Range.Font.Bold = 0; oPara1.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter; oPara2.Range.Text = "Побудова контрольноъ карти індивідуальних значень"; oPara3.Range.ParagraphFormat.SpaceAfter = 1; //oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft; oPara3.Range.InsertParagraphAfter(); oPara3.Range.Font.Bold = 0; oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft; oPara3.Range.Text = "Контрольний матеріал________ Серія_________________________________________"; oPara3.Range.ParagraphFormat.SpaceAfter = 1; oPara3.Range.InsertParagraphAfter(); oPara3.Range.Font.Bold = 0; oPara3.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft; oPara3.Range.Text = "Термін використання __________________"; oPara3.Range.ParagraphFormat.SpaceAfter = 1; //oPara3.Range.Font.Bold = 0; oPara3.Range.Font.Bold = 0; oPara3.Format.SpaceAfter = 3; oPara3.Format.SpaceAfter = 12; oPara3.Range.InsertParagraphAfter(); //Insert a 3 x 5 table, fill it with data, and make the first row //bold and italic. Word.Table oTable; Word.Range wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = oDoc.Tables.Add(wrdRng, 22, 5, ref oMissing, ref oMissing); oTable.Range.ParagraphFormat.SpaceAfter = 2; double allsum = 0; string strText; oTable.Range.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; oTable.Range.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle; // oTable.Borders.InsideLineWidth = Word.WdLineWidth.wdLineWidth050pt; // oTable.Range.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleDashDot; oTable.Cell(1, 1).Range.Text = "Дата"; oTable.Cell(1, 2).Range.Text = "Номер"; oTable.Cell(1, 3).Range.Text = "Полученные значения Хі"; oTable.Cell(1, 4).Range.Text = "Отклонение от среднего d"; oTable.Cell(1, 5).Range.Text = "Квадрат отклонения"; for (int r = 2, i = 0; r <= 21; r++, i++) { strText = System.Convert.ToString(data[i].Number); oTable.Cell(r, 2).Range.Text = strText; strText = System.Convert.ToString(data[i].Value.Value); oTable.Cell(r, 3).Range.Text = strText; strText = System.Convert.ToString(data[i].Deviation); oTable.Cell(r, 4).Range.Text = strText; strText = System.Convert.ToString(data[i].SquaredDeviation); oTable.Cell(r, 5).Range.Text = strText; allsum += data[i].Value.Value; } oTable.Cell(22, 1).Range.Text = ""; oTable.Cell(22, 2).Range.Text = "n=20"; oTable.Cell(22, 3).Range.Text = allsum.ToString(); oTable.Cell(22, 4).Range.Text = ""; oTable.Cell(22, 5).Range.Text = calc.Variance.ToString(); //oTable.Range.ParagraphFormat.SpaceAfter = 6; Word.Paragraph oPara4; oPara4 = oDoc.Content.Paragraphs.Add(ref oMissing); oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.Text = "x = " + calc.Average.ToString() + " S = " + calc.Variance.ToString(); oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.Text = "Перевірка на можливість вилучення__________________________________________"; oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.Text = "Розрахунок коефіцієнта варіації: CV = " + calc.Variance * calc.Average * 100 + "%"; oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.Text = "Розрахунок значень для побудови контрольної карти:"; oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.Text = "x + 1S = " + System.Convert.ToString(calc.ContrArr[0]) + "; x - 1S = " + System.Convert.ToString(calc.ContrArr[3]); oPara4.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphDistribute; oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphDistribute; oPara4.Range.Text = "x + 2S = " + System.Convert.ToString(calc.ContrArr[1]) + "; x - 2S = " + System.Convert.ToString(calc.ContrArr[4]); oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.Text = "x + 3S = " + System.Convert.ToString(calc.ContrArr[2]) + "; x - 3S = " + System.Convert.ToString(calc.ContrArr[5]); oPara4.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphDistribute; oPara4.Range.ParagraphFormat.SpaceAfter = 1; oPara4.Range.InsertParagraphAfter(); oPara4.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphDistribute; oPara4.Range.ParagraphFormat.SpaceBefore = 10; oPara4.Range.Text = "Дата _________________ Підпис _________________"; /* oTable.Rows[1].Range.Font.Bold = 0; oTable.Rows[1].Range.Font.Italic = 1; //Add some text after the table. Word.Paragraph oPara4; oRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; oPara4 = oDoc.Content.Paragraphs.Add(ref oRng); oPara4.Range.InsertParagraphBefore(); oPara4.Range.Text = "And here's another table:"; oPara4.Format.SpaceAfter = 24; oPara4.Range.InsertParagraphAfter(); //Insert a 5 x 2 table, fill it with data, and change the column widths. wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; oTable = oDoc.Tables.Add(wrdRng, 5, 2, ref oMissing, ref oMissing); oTable.Range.ParagraphFormat.SpaceAfter = 6; for (r = 1; r <= 5; r++) for (c = 1; c <= 2; c++) { strText = "r" + r + "c" + c; oTable.Cell(r, c).Range.Text = strText; } oTable.Columns[1].Width = oWord.InchesToPoints(2); //Change width of columns 1 & 2 oTable.Columns[2].Width = oWord.InchesToPoints(3); //Keep inserting text. When you get to 7 inches from top of the //document, insert a hard page break. object oPos; double dPos = oWord.InchesToPoints(7); oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range.InsertParagraphAfter(); do { wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; wrdRng.ParagraphFormat.SpaceAfter = 6; wrdRng.InsertAfter("A line of text"); wrdRng.InsertParagraphAfter(); oPos = wrdRng.get_Information (Word.WdInformation.wdVerticalPositionRelativeToPage); } while (dPos >= Convert.ToDouble(oPos)); object oCollapseEnd = Word.WdCollapseDirection.wdCollapseEnd; object oPageBreak = Word.WdBreakType.wdPageBreak; wrdRng.Collapse(ref oCollapseEnd); wrdRng.InsertBreak(ref oPageBreak); wrdRng.Collapse(ref oCollapseEnd); wrdRng.InsertAfter("We're now on page 2. Here's my chart:"); wrdRng.InsertParagraphAfter(); //Insert a chart. Word.InlineShape oShape; object oClassType = "MSGraph.Chart.8"; wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; oShape = wrdRng.InlineShapes.AddOLEObject(ref oClassType, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing); //Demonstrate use of late bound oChart and oChartApp objects to //manipulate the chart object with MSGraph. object oChart; object oChartApp; oChart = oShape.OLEFormat.Object; oChartApp = oChart.GetType().InvokeMember("Application", BindingFlags.GetProperty, null, oChart, null); //Change the chart type to Line. object[] Parameters = new Object[1]; Parameters[0] = 4; //xlLine = 4 oChart.GetType().InvokeMember("ChartType", BindingFlags.SetProperty, null, oChart, Parameters); //Update the chart image and quit MSGraph. oChartApp.GetType().InvokeMember("Update", BindingFlags.InvokeMethod, null, oChartApp, null); oChartApp.GetType().InvokeMember("Quit", BindingFlags.InvokeMethod, null, oChartApp, null); //... If desired, you can proceed from here using the Microsoft Graph //Object model on the oChart and oChartApp objects to make additional //changes to the chart. //Set the width of the chart. oShape.Width = oWord.InchesToPoints(6.25f); oShape.Height = oWord.InchesToPoints(3.57f); //Add text after the chart. wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range; wrdRng.InsertParagraphAfter(); wrdRng.InsertAfter("THE END."); */ //Close this form. }
private void Start() { Calculation = new Calculation(QuarterValues); GetPlotModel(); }
public TextDocumentWorker(IEnumerable<Data> values, Calculation calc) { data = new List<Data>(values); this.calc = calc; _textRedactor = WhatsInstaled(); }