有俩种导出格式。一种是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>求各位帮助啊
通过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>求各位帮助啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货