using System;
using System.Reflection; // å¼ç¨è¿ä¸ªæè½ä½¿ç¨Missingå段
namespace CExcel1
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
//å建Application对象
Excel.Application xApp=new Excel.ApplicationClass();
xApp.Visible=true;
//å¾å°WorkBook对象, å¯ä»¥ç¨ä¸¤ç§æ¹å¼ä¹ä¸: ä¸é¢çæ¯æå¼å·²æçæ件
Excel.Workbook xBook=xApp.Workbooks._Open(@"D:\Sample.xls",
Missing.Value,Missing.Value,Missing.Value,Missing.Value
,Missing.Value,Missing.Value,Missing.Value,Missing.Value
,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
//xBook=xApp.Workbooks.Add(Missing.Value);//æ°å»ºæ件ç代ç
//æå®è¦æä½çSheetï¼ä¸¤ç§æ¹å¼ï¼
Excel.Worksheet xSheet=(Excel.Worksheet)xBook.Sheets[1];
//Excel.Worksheet xSheet=(Excel.Worksheet)xApp.ActiveSheet;
//读åæ°æ®ï¼éè¿Range对象
Excel.Range rng1=xSheet.get_Range("A1",Type.Missing);
Console.WriteLine(rng1.Value2);
//读åï¼éè¿Range对象ï¼ä½ä½¿ç¨ä¸åçæ¥å£å¾å°Range
Excel.Range rng2=(Excel.Range)xSheet.Cells[3,1];
Console.WriteLine(rng2.Value2);
//åå
¥æ°æ®
Excel.Range rng3=xSheet.get_Range("C6",Missing.Value);
rng3.Value2="Hello";
rng3.Interior.ColorIndex=6; //设置Rangeçèæ¯è²
//ä¿åæ¹å¼ä¸ï¼ä¿åWorkBook
xBook.SaveAs(@"D:\CData.xls",
Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,
Excel.XlSaveAsAccessMode.xlNoChange,Missing.Value,Missing.Value,Missing.Value,
Missing.Value,Missing.Value);
//ä¿åæ¹å¼äºï¼ä¿åWorkSheet
xSheet.SaveAs(@"D:\CData2.xls",
Missing.Value,Missing.Value,Missing.Value,Missing.Value,
Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
//ä¿åæ¹å¼ä¸
xBook.Save();
xSheet=null;
xBook=null;
xApp.Quit(); //è¿ä¸å¥æ¯é常éè¦çï¼å¦åExcel对象ä¸è½ä»å
åä¸éåº
xApp=null;
}
}
}
追é®äº²ï¼æé®çæ¯å¨å·²ç»æå¼çExcelä¸åå
¥æ°æ®å
追çèªå·±ç¢ç£¨ç¢ç£¨