工作需要,邀月收集了幾個操作excel的資源。
1、如何:使用 COM Interop 建立 Excel 試算表(C# 編程指南)
http://msdn.microsoft.com/zh-cn/library/ms173186(VS.80).aspx
2、從 .NET 開發人員的角度理解 Excel 物件模型
http://msdn.microsoft.com/zh-cn/library/aa168292(office.11).aspx
3、Excel Primary Interop Assembly Reference _Workbook.Excel4MacroSheets Property
http://msdn.microsoft.com/zh-cn/library/microsoft.office.interop.excel._workbook.excel4macrosheets(VS.80).aspx
4、 如何使用 Visual C# 2005 或 Visual C# .NET 向 Excel 活頁簿傳輸資料
http://support.microsoft.com/kb/306023/zh-cn
5、Excel 指令碼編寫:系列連載
http://msdn.microsoft.com/zh-cn/library/ms974573.aspx
6、DataSet 匯出到Excel比較完整的解決方案(一)--用戶端組建檔案(downmoon)
http://www.cnblogs.com/downmoon/archive/2009/01/15/1376693.html
7、DataSet 匯出到Excel比較完整的解決方案(二)--伺服器端組建檔案(downmoon)
http://www.cnblogs.com/downmoon/archive/2009/01/16/1376702.html
8、CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet
http://www.codeproject.com/KB/database/cspreadsheet.aspx
9、Exporting in MS Excel by MS Excel way
http://www.codeproject.com/KB/aspnet/ExportInExcelByExcelWay.aspx
10、 Copy Excel Sheet - for Excel 2007
http://www.codeproject.com/KB/aspnet/CopyExcelSheet.aspx
11、Fast Exporting from DataSet to Excel
http://www.codeproject.com/KB/office/FastExcelExporting.aspx
12、 Yet another way to Generate Excel documents programmatically
http://www.codeproject.com/KB/office/excelxmlreport.aspx
13、 Import and Export to Multiple Worksheets
http://www.codeproject.com/KB/aspnet/ExporttoMultipleWorksheet.aspx