class MyData//存储行数据
{
public List<string> RowData { get; set; }
} static void Main(string[] args)
{ Application app=new ApplicationClass();
app.DisplayAlerts = false;
var path = @"C:\Users\Administrator\Desktop\JTWC台风季1979-2010.xls";//读取数据的excel
var path2=@"C:\Users\Administrator\Desktop\JTWC.xlsx";//存储数据的excel
var workbook=app.Workbooks.Open(path, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value);//打开指定位置的excel文件
Worksheet sheet=(Worksheet)workbook.Sheets[];//获取第一个table
var resultWorkBook= app.Workbooks.Open(path2);
var resultSheet =(Worksheet) resultWorkBook.Sheets[]; //
var resultData=new List<MyData>(); string numberAndNameStr = string.Empty;
for (int i = ; i < ; i++)
{
var number = ((Range) sheet.Cells[i, ]).Text.ToString();
var name = ((Range) sheet.Cells[i, ]).Text.ToString();
var tempStr = number + name;
if (tempStr != numberAndNameStr)//根据每一行的前两个cell的组合，判断这一行数据是否属于同一个Typhoon（这是一个具体问题）
{
var str = new List<string>
{
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString(),
((Range) sheet.Cells[i, ]).Text.ToString() };
var data = new MyData() {RowData = str};
resultData.Add(data);
//写入excel数据
numberAndNameStr = tempStr;
}
}
int row = ;
foreach (MyData myData in resultData)//循环每一行数据
{
for (int j = ; j < myData.RowData.Count; j++)//循环一行数据的所有cell
{
resultSheet.Cells[row, j + ] = myData.RowData[j];
}
row++;
} app.AlertBeforeOverwriting = false; //屏蔽掉系统跳出的Alert
//workbook.Save();
resultWorkBook.SaveAs(path2, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);//用save方法会保存失败 app.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(app);//释放资源
Console.WriteLine("Over");
}