1. WPF頁面

<Window x:Class="DeltaLotteryDrawSystem.Views.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:prism="http://prismlibrary.com/"
        prism:ViewModelLocator.AutoWireViewModel="True"
        xmlns:materialDesign="http://materialdesigninxaml.net/winfx/xaml/themes"
        Title="{Binding Title}"
        Height="750"
        Width="950">
    <materialDesign:DialogHost x:Name="DrawerHost"
                               CloseOnClickAway="True">
        <materialDesign:DialogHost.DialogContent>
            <DockPanel Width="520"
                       Height="250"
                       LastChildFill="False">
                <StackPanel Orientation="Horizontal"
                            DockPanel.Dock="Top">
                    <TextBlock Margin="5,25,5,5"
                               Text="Select the file path : "
                               FontSize="30"
                               FontWeight="Bold" />
                    <Button Margin="5,25,5,5"
                            HorizontalAlignment="Center"
                            FontSize="20"
                            Height="40"
                            Command="{Binding OpenExcelPathCommand}"
                            Content="選擇檔案" />
                </StackPanel>
                <StackPanel DockPanel.Dock="Top"
                            Margin="5"
                            VerticalAlignment="Center"
                            HorizontalAlignment="Left">
                    <TextBlock Text="{Binding FilePath}"
                               FontSize="18"
                               FontWeight="Bold"
                               Foreground="Chocolate"/>
                </StackPanel>
                <StackPanel Orientation="Horizontal"
                            Margin="0,0,10,15"
                            HorizontalAlignment="Right"
                            DockPanel.Dock="Bottom">
                    <Button Content="Upload"
                            Width="120"
                            Margin="5"
                            Height="40"
                            Command="{Binding UploadExcelCommand}" />
                    <Button Content="Cancle"
                            Width="120"
                            Margin="5"
                            Command="{x:Static materialDesign:DialogHost.CloseDialogCommand}"
                            Height="40" />
                </StackPanel>
            </DockPanel>
        </materialDesign:DialogHost.DialogContent>

        <Grid>
            <Grid.RowDefinitions>
                <RowDefinition Height="200" />
                <RowDefinition />
                <RowDefinition />
            </Grid.RowDefinitions>
            <Image Source="/Image/1.jpg"
                   Height="70"
                   Width="200"
                   VerticalAlignment="Top"
                   HorizontalAlignment="Left" />
            <StackPanel HorizontalAlignment="Center"
                        VerticalAlignment="Center">
                <TextBlock Text="123"
                           FontSize="40"
                           Foreground="Black"
                           FontWeight="Bold" />
            </StackPanel>
            <StackPanel Grid.Row="1"
                        Orientation="Horizontal"
                        HorizontalAlignment="Center">
                <Button x:Name="UploadExcelButton"
                        Content="Upload Excel"
                        FontSize="20"
                        Margin="10"
                        Command="{x:Static materialDesign:DialogHost.OpenDialogCommand}"
                        FontWeight="Bold"
                        Width="160"
                        Height="70" />
                <Button Content="Lottery Draw"
                        FontSize="20"
                        Margin="10"
                        FontWeight="Bold"
                        Width="160"
                        Height="70" />
            </StackPanel>
        </Grid>
    </materialDesign:DialogHost>
</Window>

2. Upload Function

    public void OpenExcelPath()
    {
        OpenFileDialog openFileDialog = new OpenFileDialog();
        openFileDialog.Filter = "All Files (*.*)|*.*";
        if (openFileDialog.ShowDialog() == true)
        {
            // 用户选择了一个文件   
            FilePath = openFileDialog.FileName;
        }
    }

    public void UploadExcel()
    {
        UserList = new ObservableCollection<string>();
        var fs = new FileStream(FilePath, FileMode.Open, FileAccess.Read);
        var workbook = WorkbookFactory.Create(fs);

        var sheet = workbook.GetSheetAt(0);

        if (sheet != null)
        {
            //最后一列的标号  
            int rowCount = sheet.LastRowNum;
            for (int i = 0; i <= rowCount; i++)
            {
                IRow row = sheet.GetRow(i);
                ICell cell = row.GetCell(0);
                if (cell != null)
                {
                    string cellValue = cell.StringCellValue;
                    if (!string.IsNullOrEmpty(cellValue))
                    {
                        UserList.Add(cellValue);
                    }
                }
            }
        }
    }

3. Parse Excel

public class ExcelHelper : IDisposable   
{  
    private string fileName = null; //文件名  
    private IWorkbook workbook = null;  
    private FileStream fs = null;  
    private bool disposed;  
    public ExcelHelper(string fileName)//构造函数，读入文件名  
    {  
        this.fileName = fileName;  
        disposed = false;  
    }  
    /// 将excel中的数据导入到DataTable中  
    /// <param name="sheetName">excel工作薄sheet的名称</param>  
    /// <param name="isFirstRowColumn">第一行是否是DataTable的列名</param>  
    /// <returns>返回的DataTable</returns>  
    public DataTable ExcelToDataTable(string sheetName, bool isFirstRowColumn)  
    {  
        ISheet sheet = null;  
        DataTable data = new DataTable();  
        int startRow = 0;  
        try  
        {  
            fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);  
            workbook = WorkbookFactory.Create(fs);  
            if (sheetName != null)  
            {  
                sheet = workbook.GetSheet(sheetName);  
                //如果没有找到指定的sheetName对应的sheet，则尝试获取第一个sheet  
                if (sheet == null)   
                {  
                    sheet = workbook.GetSheetAt(0);  
                }  
            }  
            else  
            {  
                sheet = workbook.GetSheetAt(0);  
            }  
            if (sheet != null)  
            {  
                IRow firstRow = sheet.GetRow(0);  
                int cellCount = firstRow.LastCellNum; //一行最后一个cell的编号，即总的列数  
                if (isFirstRowColumn)  
                {  
                    for (int i = firstRow.FirstCellNum; i < cellCount; ++i)  
                    {  
                        ICell cell = firstRow.GetCell(i);  
                        if (cell != null)  
                        {  
                            string cellValue = cell.StringCellValue;  
                            if (cellValue != null)  
                            {  
                                DataColumn column = new DataColumn(cellValue);  
                                data.Columns.Add(column);  
                            }  
                        }  
                    }  
                    startRow = sheet.FirstRowNum + 1;//得到项标题后  
                }  
                else  
                {  
                    startRow = sheet.FirstRowNum;  
                }  
                //最后一列的标号  
                int rowCount = sheet.LastRowNum;  
                for (int i = startRow; i <= rowCount; ++i)  
                {  
                    IRow row = sheet.GetRow(i);  
                    if (row == null) continue; //没有数据的行默认是null　　　　　　　  
  
                    DataRow dataRow = data.NewRow();  
                    for (int j = row.FirstCellNum; j < cellCount; ++j)  
                    {  
                        if (row.GetCell(j) != null) //同理，没有数据的单元格都默认是null  
                            dataRow[j] = row.GetCell(j).ToString();  
                    }  
                    data.Rows.Add(dataRow);  
                }  
            }  
            return data;  
        }  
        catch (Exception ex)//打印错误信息  
        {  
            MessageBox.Show("Exception: " + ex.Message);  
            return null;  
        }  
    }  
  
    //将DataTable数据导入到excel中  
    //<param name="data">要导入的数据</param>  
    //<param name="sheetName">要导入的excel的sheet的名称</param>  
    //<param name="isColumnWritten">DataTable的列名是否要导入</param>  
    //<returns>导入数据行数(包含列名那一行)</returns>  
    public int DataTableToExcel(DataTable data, string sheetName, bool isColumnWritten)  
    {  
        int i = 0;  
        int j = 0;  
        int count = 0;  
        ISheet sheet = null;  
  
        fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);  
        if (fileName.IndexOf(".xlsx") > 0) // 2007版本  
            workbook = new XSSFWorkbook();  
        else if (fileName.IndexOf(".xls") > 0) // 2003版本  
            workbook = new HSSFWorkbook();  
  
        try  
        {  
            if (workbook != null)  
            {  
                sheet = workbook.CreateSheet(sheetName);  
            }  
            else  
            {  
                return -1;  
            }  
  
            if (isColumnWritten == true) //写入DataTable的列名  
            {  
                IRow row = sheet.CreateRow(0);  
                for (j = 0; j < data.Columns.Count; ++j)  
                {  
                    row.CreateCell(j).SetCellValue(data.Columns[j].ColumnName);  
                }  
                count = 1;  
            }  
            else  
            {  
                count = 0;  
            }  
  
            for (i = 0; i < data.Rows.Count; ++i)  
            {  
                IRow row = sheet.CreateRow(count);  
                for (j = 0; j < data.Columns.Count; ++j)  
                {  
                    row.CreateCell(j).SetCellValue(data.Rows[i][j].ToString());  
                }  
                ++count;  
            }  
            workbook.Write(fs); //写入到excel  
            return count;  
        }  
        catch (Exception ex)  
        {  
            Console.WriteLine("Exception: " + ex.Message);  
            return -1;  
        }  
    }  
  
    public void Dispose()//IDisposable为垃圾回收相关的东西，用来显式释放非托管资源,这部分目前还不是非常了解  
    {  
        Dispose(true);  
        GC.SuppressFinalize(this);  
    }  
    protected virtual void Dispose(bool disposing)  
    {  
        if (!this.disposed)  
        {  
            if (disposing)  
            {  
                if (fs != null)  
                    fs.Close();  
            }  
            fs = null;  
            disposed = true;  
        }  
    }  
}