private void openContactsToolStripMenuItem_Click(object sender, EventArgs e)
{
var excel = new Excel.Application
{
SheetsInNewWorkbook = 1
};
excel.Workbooks.Add();
Excel.Worksheet table = excel.Workbooks[1].Worksheets.get_Item(1);
DataWorker dataWorker = DataWorker.Instance;
var contacts = dataWorker.GetContacts();
table.Range["A1", "A1"].Value = "User name";
table.Range["B1", "B1"].Value = "Login";
for (int i = 2; i < contacts.Count + 2; i++)
{
table.Range["A" + i, "A" + i].Value = contacts.ElementAt(i - 2).Item1;
table.Range["B" + i, "B" + i].Value = contacts.ElementAt(i - 2).Item2;
}
excel.Visible = true;
}
private void openContactsInWordToolStripMenuItem_Click(object sender, EventArgs e)
{
DataWorker dataWorker = DataWorker.Instance;
var word = new Word.Application {
Visible = true
};
var doc = word.Documents.Add();
doc.Paragraphs[1].Range.Text = "Users table\n";
var wdRange = doc.Paragraphs[2].Range;
var contacts = dataWorker.GetContacts();
var table = doc.Tables.Add(wdRange, contacts.Count + 1, 2);
table.set_Style("Сетка таблицы");
table.Cell(1, 1).Range.Text = "User name";
table.Cell(1, 2).Range.Text = "Login";
for (int i = 0; i < contacts.Count; i++)
{
table.Cell(i + 2, 1).Range.Text = contacts.ElementAt(i).Item1;
table.Cell(i + 2, 2).Range.Text = contacts.ElementAt(i).Item2;
}
doc.Paragraphs[(contacts.Count + 1) * 3 + 2].Range.Text = "Press Ctrl+P for print\n";
}
