有俩种导出格式。一种是xls,一种是xlsx、
通过MenuItem 按钮进行导出
 <Menu Name="MainMenu" DockPanel.Dock="Top" >
                <MenuItem Header="查询" Name="btnQuery" Click="btnQuery_Click" />
                <MenuItem Header="导出Excel" Click="MenuItem_Click" />
</Menu><DataGrid AutoGenerateColumns="False" Name="HistoryWorkingDataGrid" IsReadOnly="True">
<DataGrid.Columns>
<DataGridTextColumn Header="名称"  Binding="{Binding Path=controlcabinetname}" Width="100"/>
<DataGridTextColumn Header="分类"  Binding="{Binding Path=controlcabinetclassname}"Width="100"/>
<DataGridTextColumn Header="时间"  Binding="{Binding Path=datetimeas}" Width="150"/>
<DataGridTextColumn Header="工作模式"  Binding="{Binding Path=workmodeas}" Width="100"/>
<DataGridTextColumn Header="报警状态"  Binding="{Binding Path=alarmstatusas}" Width="100"/>
<DataGridTextColumn Header="输入电压"  Binding="{Binding Path=inputvoltage}" Width="100"/>
<DataGridTextColumn Header="输出电压"  Binding="{Binding Path=outputvoltage}" Width="100"/>
<DataGridTextColumn Header="输出电流"  Binding="{Binding Path=outputcurrent}" Width="100"/>
<DataGridTextColumn Header="一路"  Binding="{Binding Path=firstpart}" Width="100"/>
<DataGridTextColumn Header="二路"  Binding="{Binding Path=secondpart}" Width="100"/>
</DataGrid.Columns>
</DataGrid>求各位帮助啊