开源组件ExcelLibrary的常见用法举例

使用ExcelLibrary开源组件来做excel的生成和解析很方便，常见用法如下：

ExcelLibrary的下载地址http://www.oschina.net/p/excellibrary

/// <summary>
        /// 读取excel文件，输出DataSet，支持多个excel2003和excel2007
        /// </summary>
        /// <param name="excelPath"></param>
        /// <returns></returns>
        static DataSet GetDataSetFromExcel(string excelPath)
        {
            return ExcelLibrary.DataSetHelper.CreateDataSet(excelPath);
        }

        /// <summary>
        /// 读取excel文件，指定要读取的子表，输出DataTable
        /// </summary>
        /// <param name="excelPath"></param>
        /// <param name="sheetName"></param>
        /// <returns></returns>
        static DataTable GetDataTableFromExcelSheet(string excelPath, string sheetName)
        {
            return ExcelLibrary.DataSetHelper.CreateDataTable(excelPath, sheetName);
        }

        /// <summary>
        /// 根据提供的DataSet生成excel，并存放在指定的路径
        /// </summary>
        /// <param name="excelSavedPath"></param>
        /// <param name="inputDataSet"></param>
        static void GenerateExcelFromDataSet(string excelSavedPath, DataSet inputDataSet)
        {
            ExcelLibrary.DataSetHelper.CreateWorkbook(excelSavedPath, inputDataSet);
        }

        /// <summary>
        /// 根据提供的DataSet生成流
        /// </summary>
        /// <param name="excelSavedPath"></param>
        /// <param name="inputDataSet"></param>
        static void OutputStreamFromDataSet(Stream outputStream, DataSet inputDataSet)
        {
            ExcelLibrary.DataSetHelper.CreateWorkbook(outputStream, inputDataSet);
        }