using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Collections;
using System.Data.OleDb;
using System.Configuration;
namespace IOF.CRM.Cancel.Controllers
{
/// <summary>
/// 像操作MSSQL数据库一去操作一个Excel文件:)
/// </summary>
public class Excel
{
public static string TableName = "Sheet1";
public static string ExcelPath = string.Empty;
/// <summary>
/// 返回一个OleDbDataReader对象
/// </summary>
/// <param name="excelFileFullPath">Excel文件完路径</param>
/// <param name="CommondText">查询语句 例如:Select * from [sheet1$]</param>
/// <returns></returns>
public static OleDbDataReader ExcuteReader(string excelFileFullPath, string CommondText)
{
try
{
OleDbConnection oConn =
c# 操作excel类
最新推荐文章于 2016-10-10 08:48:14 发布