Com 调用word和excel

using Microsoft.Office.Interop.Word;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace 线程
{
public partial class Com : Form
{
public Com()
{
InitializeComponent();
}
/// <summary>
/// word
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button12_Click(object sender, EventArgs e)
{
//启动Word并使Word可见
Microsoft.Office.Interop.Word.Application wordApp = new Microsoft.Office.Interop.Word.Application() { Visible = true };
//新建word文档
wordApp.Documents.Add();
Document wordDoc = wordApp.ActiveDocument;
Paragraph para = wordDoc.Paragraphs.Add();
para.Range.Text = "导出word";
//保存文档
object filename = @"E:\com_out_put_word.doc";
wordDoc.SaveAs2(filename);
wordDoc.Close();
wordApp.Application.Quit();
}
/// <summary>
/// excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button13_Click(object sender, EventArgs e)
{
object missing = Type.Missing;
Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application() { Visible = true };
Microsoft.Office.Interop.Excel.Workbook wb = ExcelApp.Workbooks.Add(missing);
Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets.get_Item(1);

ws.Cells[1, 1] = "导出Excel第一行第一列";
ws.Cells[2, 2] = "导出Excel第二行第二列";
string filename = @"E:\com_out_put_excel.xls";
if (System.IO.File.Exists(filename))
System.IO.File.Delete(filename);
ws.SaveAs(filename);
}
}
}

转载于:https://www.cnblogs.com/net520/p/7832260.html