10 2010 档案

[转]动态获取Excel表名

摘要：public string GetExcelFirstTableName(string excelFileName) { string tableName = null; if (File.Exists(excelFileName)) { using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet." + "O... 阅读全文

posted @ 2010-10-12 16:49 沙茶叶阅读(386) 评论(0) 推荐(0) 编辑

asp.net操作Excel助手

摘要：public partial class ExcelHelper : IDisposable { #region Fileds private string _excelObject = "Provider=Microsoft.{0}.OLEDB.{1};Data Source={2};Extended Properties=\"Excel {3};HDR={4};IMEX={5}\""; pri... 阅读全文

posted @ 2010-10-12 16:44 沙茶叶阅读(515) 评论(1) 推荐(0) 编辑