{
 public Form1()
 {
InitializeComponent();
 }
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app1 =
new Microsoft.Office.Interop.Excel.Application(); //在Windows中生成一個Excel.exe進程
app1.Visible = true; //運行時顯示Excel主窗口
 try
{
Workbook book1 = app1.Workbooks.Add(Type.Missing); //使用 app1生成一個book對象
Worksheet sheet1 = (Worksheet)book1.Sheets[1]; //從book1對象中生成Sheet對象并賦值
Range rng1 = sheet1.get_Range("A1", Type.Missing); //設(shè)置操作區(qū)域
rng1.Value2 = "Hello World!"; //對操作區(qū)域賦值
}
catch
{
app1.Quit(); //結(jié)束進程
}
}
private void button2_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app1 =
new Microsoft.Office.Interop.Excel.Application();
app1.Visible = true; //運行時顯示Excel主窗口
try
{
//打開一個已經(jīng)存在的excel文件
Workbook book1 = app1.Workbooks.Open("D:/test.xlsx", Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing);
Worksheet sheet1 = (Worksheet)book1.Sheets["Sheet1"];
Range rng1 = sheet1.get_Range("A1:C3,E2:G6", Type.Missing); //設(shè)置操作區(qū)域為2個不連續(xù)區(qū)域
rng1.NumberFormatLocal = "@";
rng1.Value2 = "2006147214E00045"; //對操作區(qū)域賦值
Range rng2 = sheet1.get_Range("F1:F6", Type.Missing);
rng2.Value2 = "2006147214E00045";
app1.DisplayAlerts = false; //不顯示保存對話框
book1.Save(); //保存
}
catch
{
app1.Quit(); //結(jié)束進程
}
}
private void button3_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app1 =
new Microsoft.Office.Interop.Excel.Application();
app1.Visible = false; //運行時不顯示Excel主窗口
try
{
Workbook book1 = app1.Workbooks.Add(Type.Missing);
Worksheet sheet1 = (Worksheet)book1.Sheets[1];
app1.DisplayAlerts = true;
//將打開的Excel文件另存:D est.xlsx 格式 xlXMLSpreadsheet(xlsm)、xlOpenXMLWorkbook(xlsx)、 xlExcel12(xlsb)
book1.SaveAs("D:/test.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook,
Type.Missing, Type.Missing,false,false,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlLocalSessionChanges,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
book1.Close(Type.Missing, "D:/test.xlsx", Type.Missing);
}
catch
{
app1.Quit();
}
finally
{
app1.Quit();
}
}
}
|
