NetQuickJamesFrameTests/Util/File_EXCELHelperTests.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using Microsoft.VisualStudio.TestTools.UnitTesting;
using NetQuickJamesFrame.Util;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace NetQuickJamesFrame.Util.Tests
{
    [TestClass()]
    public class File_EXCELHelperTests
    {
        [TestMethod()]
        public void readExcel_usingEPPlusTest()
        {
            File_EXCELHelper excleHelp = new File_EXCELHelper();
            DataTable dt = excleHelp.readExcel_usingEPPlus(@"C:\Users\\Desktop\test.xlsx", 0);

            DataColumnCollection dc = dt.Columns;
            for (int i = 0; i < dc.Count; i++)
            {
                Console.Write(dc[i] + "   ");
            }

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string id = dt.Rows[i]["id"].ToString();
                string name = dt.Rows[i]["name"].ToString();
                string tel = dt.Rows[i]["tel"].ToString();
                string bg = dt.Rows[i]["bg"].ToString();

                Console.WriteLine(id + "   " + name + "   " + tel + "   " + bg);
            }
        }

        [TestMethod()]
        public void writeExcel_usingEPPlusTest()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("id");
            dt.Columns.Add("name");
            dt.Columns.Add("tel");

            for (int row = 0; row < 5; row++)
            {
                DataRow dr = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    Random random = new Random();
                    dr[i] = random.Next(0, 10000).ToString();
                }
                dt.Rows.Add(dr);
            }

            File_EXCELHelper excleHelp = new File_EXCELHelper();
            excleHelp.writeExcel_usingEPPlus(@"C:\Users\\Desktop\testWrite.xlsx", "mySheet", dt);
        }
    }
}