Aspose.Cells組件可以不依賴excel來導入導出excel文件：

?導入：

public static System.Data.DataTable ReadExcel(String strFileName){Workbook book = new Workbook();book.Open(strFileName);Worksheet sheet = book.Worksheets[0];Cells cells = sheet.Cells;return cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);}

導出：

private static void Export<T>(IEnumerable<T> data, HttpResponse response){Workbook workbook = new Workbook();Worksheet sheet = (Worksheet)workbook.Worksheets[0]; PropertyInfo[] ps = typeof(T).GetProperties();var colIndex = "A";foreach (var p in ps){sheet.Cells[colIndex + 1].PutValue(p.Name);int i = 2;foreach (var d in data){sheet.Cells[colIndex + i].PutValue(p.GetValue(d, null));i++;}colIndex = ((char)(colIndex[0] + 1)).ToString();}response.Clear();response.Buffer = true;response.Charset = "utf-8";response.AppendHeader("Content-Disposition", "attachment;filename=xxx.xls");response.ContentEncoding = System.Text.Encoding.UTF8;response.ContentType = "application/ms-excel";response.BinaryWrite(workbook.SaveToStream().ToArray());response.End();}

轉自：http://blog.csdn.net/weiky626/article/details/7514637

轉載于:https://www.cnblogs.com/gebenhagen/p/5156823.html

總結

以上是生活随笔為你收集整理的【转】 (C#)利用Aspose.Cells组件导入导出excel文件的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。