private void wordToolStripMenuItem_Click(object sender, EventArgs e) { saveFileDialog2.Filter = "doc files (*.doc)|*.doc|All files (*.*)|*.*"; saveFileDialog2.FilterIndex = 2; saveFileDialog2.RestoreDirectory = true; if (saveFileDialog2.ShowDialog() == DialogResult.OK) { Microsoft.Office.Interop.Word.Application application = new Microsoft.Office.Interop.Word.Application(); Object missing = Type.Missing; Word.Document word1 = application.Documents.Add(ref missing, ref missing, ref missing, ref missing); //object text = "tesfsdfkslghsdgjh"; //word1.Paragraphs[1].Range.InsertParagraphAfter(); //word1.Paragraphs[1].Range.Text = "asaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"; //word1.Footnotes.Location = Word.WdFootnoteLocation.wdBeneathText; //word1.Footnotes.NumberStyle = Word.WdNoteNumberStyle.wdNoteNumberStyleLowercaseRoman; //word1.Footnotes.Add(word1.Paragraphs[1].Range.Words[2].Characters[2], ref missing, ref text); Microsoft.Office.Interop.Word.Document doc = application.ActiveDocument; Microsoft.Office.Interop.Word.Range range = doc.Paragraphs[doc.Paragraphs.Count].Range; dataSetTemp = dbw1.ReadMetricsByReport(listView2.Items[listView2.SelectedIndices[0]].Text); doc.Tables.Add(range, dataSetTemp.Tables[0].Rows.Count + 1, 6, ref missing, ref missing); doc.Tables[1].Cell(1, 1).Range.Text = "NAME metric"; doc.Tables[1].Cell(1, 2).Range.Text = "MIN value"; doc.Tables[1].Cell(1, 3).Range.Text = "CUR value"; doc.Tables[1].Cell(1, 4).Range.Text = "MAX value"; doc.Tables[1].Cell(1, 5).Range.Text = "VALUE"; doc.Tables[1].Cell(1, 6).Range.Text = "RATE"; for (int i = 0; i < dataSetTemp.Tables[0].Rows.Count; i++) { dataSetTemp1 = dbw1.ReadInfoMetricByReportMetric(listView2.Items[listView2.SelectedIndices[0]].Text, dataSetTemp.Tables[0].Rows[i].ItemArray[0].ToString()); doc.Tables[1].Cell(i + 2, 1).Range.Text = dataSetTemp.Tables[0].Rows[i].ItemArray[0].ToString(); doc.Tables[1].Cell(i + 2, 2).Range.Text = dataSetTemp1.Tables[0].Rows[0].ItemArray[2].ToString(); doc.Tables[1].Cell(i + 2, 3).Range.Text = dataSetTemp1.Tables[0].Rows[0].ItemArray[0].ToString(); doc.Tables[1].Cell(i + 2, 4).Range.Text = dataSetTemp1.Tables[0].Rows[0].ItemArray[3].ToString(); doc.Tables[1].Cell(i + 2, 5).Range.Text = Double.Parse(dataSetTemp1.Tables[0].Rows[0].ItemArray[4].ToString()).ToString("F5"); doc.Tables[1].Cell(i + 2, 6).Range.Text = dataSetTemp1.Tables[0].Rows[0].ItemArray[5].ToString(); } doc.Tables[1].Columns.AutoFit(); Word.Border[] borders = new Word.Border[6]; Word.Table tbl = doc.Tables[doc.Tables.Count]; borders[0] = tbl.Borders[Word.WdBorderType.wdBorderLeft]; borders[1] = tbl.Borders[Word.WdBorderType.wdBorderRight]; borders[2] = tbl.Borders[Word.WdBorderType.wdBorderTop]; borders[3] = tbl.Borders[Word.WdBorderType.wdBorderBottom]; borders[4] = tbl.Borders[Word.WdBorderType.wdBorderHorizontal]; borders[5] = tbl.Borders[Word.WdBorderType.wdBorderVertical]; foreach (Word.Border border in borders) { border.LineStyle = Word.WdLineStyle.wdLineStyleSingle; border.Color = Word.WdColor.wdColorBlack; } application.Documents[word1].SaveAs(saveFileDialog2.FileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing); application.Quit(); string info = "Doc file saved at\n" + saveFileDialog2.FileName; MessageBox.Show(this, info, "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { checkedListBox1.Items.Clear(); if (comboBox1.SelectedIndex == 0) { dataSet1 = dbw1.ReadFartorsByReport(g_reportName); } if (comboBox1.SelectedIndex == 1) { dataSet1 = dbw1.ReadCriteriasByReport(g_reportName); } if (comboBox1.SelectedIndex == 2) { dataSet1 = dbw1.ReadMetricsByReport(g_reportName); } parametrs = new double[0]; this.Invalidate(); for (int i = 0; i < dataSet1.Tables[0].Rows.Count; i++) { checkedListBox1.Items.Add(dataSet1.Tables[0].Rows[i].ItemArray[0].ToString(), false); } }