ExcelHelper Class

HD.Common

ExcelHelper Class Helper帮助文档
Excel操作类
Inheritance Hierarchy

SystemObject  HD.CommonExcelHelper

Namespace: HD.Common
Assembly: HD.Common (in HD.Common.dll) Version: 1.0.0.0 (1.0.0.0)
Syntax

public class ExcelHelper
Public Class ExcelHelper
public ref class ExcelHelper
type ExcelHelper =  class end

The ExcelHelper type exposes the following members.

Constructors

  NameDescription
Public methodExcelHelper
Initializes a new instance of the ExcelHelper class
Top
Methods

  NameDescription
Public methodStatic memberDataTable1Excel
Public methodStatic memberDataTable2Excel
导出Excel文件,转换为可读模式
Public methodStatic memberDataTable3Excel
导出Excel文件,并自定义文件名
Public methodEquals (Inherited from Object.)
Public methodExportData
导出Excel
Protected methodFinalize (Inherited from Object.)
Public methodStatic memberGetExcelTableColumns
获取Excel文件指定数据表的数据列表
Public methodStatic memberGetExcelTables
获取Excel文件数据表列表
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodStatic memberInputFromExcel
将Excel文件导出至DataTable(第一行作为表头)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodStatic memberOutputToExcel(DataTable, String)
将数据导出至Excel文件
Public methodStatic memberOutputToExcel(DataTable, ArrayList, String)
将数据导出至Excel文件
Public methodToString (Inherited from Object.)
Top
See Also

Reference