C#创建excel文档并把数组中的数据保存到exce_l中.docx

想用C#创建excel文档，想当然的用了file.create(“a.xlsx”),但是每次想打开该excel都出现“档案格式与附档名无效”的错误提示，查了一下度娘以后，搜到一个答案，觉得很有意思，他是这样说的，我创建一个*.导弹，怎么不能发射呢？想想很有道理，我们不能以为，创建了一个后缀名为.xlsx的文档，就认定它是一个excel。 正确的创建方式为： public void CreateExcel(string fileName) { Object missing = Missing.Value; Microsoft.Office.Interop.Excel.Application m_objExcel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks = m_objExcel.Workbooks; Microsoft.Office.Interop.Excel.Workbook m_objWorkBook = m_objWorkBooks.Add(true); Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets = m_objWorkBook.Sheets; ; Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkSheets[1]; m_objWorkBook.SaveAs(fileName, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing); m_objWorkBook.Close(false, missing, missing); m_objExcel.Quit(); } 当然，用以上的方式要添加引用：Microsoft.Office.Interop.Excel 创建了excel后，我们要把数据写入excel指定的列中： private void writeDataToExcel(ArrayList al) { Excel._Worksheet objSheet; Excel.Range range; string startRow = ; string titleRow = ; string filepath = ; filepath = @D:\满一年抽奖结果.xlsx; if (!(File.Exists(filepath))) { CreateExcel(filepath); } try { Excel.Application objApp = new Excel.Application(); Excel.Workbook objBook = objApp.Workbooks._Open(filepath, Missing.Value, Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); objSheet = (Excel.Worksheet)objBook.She