C# 读写excel表 例子源码下载

【核心代码】

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Text; 
using Excel = Microsoft.Office.Interop.Excel; 
 

namespace MSDNEXCEL 
{ 
 public class Account 
 { 
 public int ID { get; set; } 
 public double Balance { get; set; } 
 } 
 class Program 
 { 
 
 static void DisplayInExcel(IEnumerable<Account> accounts) 
 { 
 var excelApp = new Excel.Application(); 
 // Make the object visible. 
 excelApp.Visible = true; 
 // Create a new, empty workbook and add it to the collection returned 
 // by property Workbooks. The new workbook becomes the active workbook. 
 // Add has an optional parameter for specifying a praticular template. 
 // Because no argument is sent in this example, Add creates a new workbook. 
 excelApp.Workbooks.Add(); 
 // This example uses a single workSheet. The explicit type casting is 
 // removed in a later procedure. 
 Excel._Worksheet workSheet = (Excel.Worksheet)excelApp.ActiveSheet; 
 workSheet.Cells[1, "A"] = "ID Number"; 
 workSheet.Cells[1, "B"] = "Current Balance"; 
 var row = 1; 
 foreach (var acct in accounts) 
 { 
 row  ; 
 workSheet.Cells[row, "A"] = acct.ID; 
 workSheet.Cells[row, "B"] = acct.Balance; 
 } 
 workSheet.Columns[1].AutoFit(); 
 workSheet.Columns[2].AutoFit(); 
 } 
 static void Main(string[] args) 
 { 
 var bankAccounts = new List<Account> 
 { 
 new Account 
 { 
 ID = 345678, 
 Balance = 541.27 
 },

new Account
 { 
 ID = 1230221, 
 Balance = -127.44 
 } 
 }; 
 // DisplayInExcel(bankAccounts); 
 
ReadExcel(@"C:\Users\Administrator.PC-20121127WIOX\Desktop\project\MSDNEXCEL\MSDNEXCEL\
bin\Debug\Book1.xls"); 
 
//@"C:\Users\Administrator.PC-20121127WIOX\Desktop\project\MSDNEXCEL\MSDNEXCEL\bin\Debu
g\Book1.xls"为写入部分中Excel的保存目录 
 Console.ReadLine(); 
 } 
 static void ReadExcel(string str) 
 { 
 var excelAppRead = new Excel.Application(); 
 excelAppRead.Application.Workbooks.Open(str); 
 Account temp ; 
 Excel._Worksheet workSheet = (Excel.Worksheet)excelAppRead.ActiveSheet; 
 var count = workSheet.Cells.Count; 
 for (int i = 2; i <4; i  ) 
 { 
 temp = new Account(); 
 temp.ID = int.Parse(workSheet.Cells[i, "A"].Text); 
 temp.Balance = double.Parse(workSheet.Cells[i, "B"].Text); 
 Console.WriteLine("ID: {0}\t;Balance: {1}", temp.ID,temp.Balance); 
 } 
 
 } 
 } 
}