WPF的导出Excel表格

                                     WPF的导出Excel表格

思路：如果我们要把数据导出Excel表格，就要查询出数据，然后创建Excel、创建工作表和创建行，最后把Excel转化为文件流，输出。

前端：

1.我们在打印界面给他一个导出按钮

<Button x:Name="btnInvestigate" Content="导出Excel" Click="btnInadmissible_Click" Width="80" Height="20" Background="#daedff" VerticalAlignment="Center" HorizontalAlignment="Right" />

后台：

1.我们要查询这些数据就要把它查询出来，数据可以根据自已的情况查询

 private void btnInadmissible_Click(object sender, RoutedEventArgs e)
{
             var listAchievement = (from dbRegister in myMode.PW_Register
                                    join dbPerson in myMode.PW_Person on dbRegister.PersonID equals dbPerson.PersonID                                       
                                    join dbManPerson in myMode.PW__ManPerson on dbPerson.ManPersonID equals dbManPerson.ManPersonID
                                    join dbFemalePerson in myMode.PW__FemalePerson on dbPerson.FemalePersonID equals dbFemalePerson.FemalePersonID
                                    join dbNationality in myMode.BS_National