C#导入导出Excel基于Aspose.Cells.dll

导入导出Excel

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Aspose.Cells;
namespace OperateExcelByAspose
{
    /// 

    /// Excel操作类
    /// lyzane.it@gmail.com
    /// 奔放的胸毛。
    /// 

    public class ExcelHelper
    {
		/// 

        /// 读取Excel文件到DataSet
		/// 

		/// Excel文件物理路径
        /// /// Excel中要读取的Sheet的宽度
		/// tleRow“>是否含有标题列
		/// 
        public DataSet Import（string pathint sheetWidthbool hastitleRow）
        {
            Workbook tcWorkBook = new Workbook（）;
            tcWorkBook.Open（path）;
            WorksheetCollection tcWorkSheets = tcWorkBook.Worksheets;
            D

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

    ..A..H.     45056  2019-04-29 11:36  OperateExcelByAspose\.vs\OperateExcelByAspose\v15\.suo

     文件          0  2019-04-24 09:32  OperateExcelByAspose\.vs\OperateExcelByAspose\v15\Server\sqlite3\db.lock

     文件       4096  2019-04-24 09:32  OperateExcelByAspose\.vs\OperateExcelByAspose\v15\Server\sqlite3\storage.ide

     文件      32768  2019-04-29 11:28  OperateExcelByAspose\.vs\OperateExcelByAspose\v15\Server\sqlite3\storage.ide-shm

     文件    1417312  2019-04-24 09:51  OperateExcelByAspose\.vs\OperateExcelByAspose\v15\Server\sqlite3\storage.ide-wal

    ..A..H.     54272  2020-06-12 19:20  OperateExcelByAspose\.vs\OperateExcelByAspose\v16\.suo

     文件          0  2019-12-05 17:30  OperateExcelByAspose\.vs\OperateExcelByAspose\v16\Server\sqlite3\db.lock

     文件     995328  2020-05-07 15:16  OperateExcelByAspose\.vs\OperateExcelByAspose\v16\Server\sqlite3\storage.ide

     文件       6715  2011-12-13 12:11  OperateExcelByAspose\Backup\OperateExcelByAspose\ExcelHelper.cs

     文件       4559  2011-12-13 12:06  OperateExcelByAspose\Backup\OperateExcelByAspose\Form_Main.cs

     文件       6274  2011-12-13 11:20  OperateExcelByAspose\Backup\OperateExcelByAspose\Form_Main.Designer.cs

     文件       6018  2011-12-13 11:20  OperateExcelByAspose\Backup\OperateExcelByAspose\Form_Main.resx

     文件       4149  2011-12-13 11:44  OperateExcelByAspose\Backup\OperateExcelByAspose\Import_Service.cs

     文件       3491  2011-12-12 18:05  OperateExcelByAspose\Backup\OperateExcelByAspose\OperateExcelByAspose.csproj

     文件        483  2011-12-12 18:05  OperateExcelByAspose\Backup\OperateExcelByAspose\Program.cs

     文件       1224  2011-12-12 17:52  OperateExcelByAspose\Backup\OperateExcelByAspose\Properties\AssemblyInfo.cs

     文件       2896  2011-12-12 17:52  OperateExcelByAspose\Backup\OperateExcelByAspose\Properties\Resources.Designer.cs

     文件       5612  2011-12-12 17:52  OperateExcelByAspose\Backup\OperateExcelByAspose\Properties\Resources.resx

     文件       1105  2011-12-12 17:52  OperateExcelByAspose\Backup\OperateExcelByAspose\Properties\Settings.Designer.cs

     文件        249  2011-12-12 17:52  OperateExcelByAspose\Backup\OperateExcelByAspose\Properties\Settings.settings

     文件        949  2011-12-12 17:52  OperateExcelByAspose\Backup\OperateExcelByAspose.sln

     文件    6570840  2011-04-01 15:12  OperateExcelByAspose\OperateExcelByAspose\bin\Debug\Aspose.Cells.dll

     文件      16896  2020-05-07 14:46  OperateExcelByAspose\OperateExcelByAspose\bin\Debug\OperateExcelByAspose.exe

     文件      36352  2020-05-07 14:46  OperateExcelByAspose\OperateExcelByAspose\bin\Debug\OperateExcelByAspose.pdb

     文件       5632  2005-11-11 22:25  OperateExcelByAspose\OperateExcelByAspose\bin\Debug\OperateExcelByAspose.vshost.exe

     文件      42496  2020-05-07 14:47  OperateExcelByAspose\OperateExcelByAspose\bin\Debug\奔放的胸毛。.xls

     文件      62976  2020-05-07 14:52  OperateExcelByAspose\OperateExcelByAspose\bin\奔放的胸毛。.xls

     文件       6715  2011-12-13 12:11  OperateExcelByAspose\OperateExcelByAspose\ExcelHelper.cs

     文件       5299  2019-12-05 17:40  OperateExcelByAspose\OperateExcelByAspose\Form_Main.cs

     文件       7162  2019-12-05 17:38  OperateExcelByAspose\OperateExcelByAspose\Form_Main.Designer.cs

............此处省略48个文件信息