資源簡介
private void daochu_Click(object sender, RoutedEventArgs e)
{
System.Windows.Controls.DataGrid DataGrid = dataGrid1;
string file = "C:Users\\Administrator\\Desktop\\qb";
Export(DataGrid, file);
}
public static void Export(System.Windows.Controls.DataGrid dataGrid, string _fileName)
{
System.Data.DataTable dt = new System.Data.DataTable();
for (int i = 0; i < dataGrid.Columns.Count; i++)
{
if (dataGrid.Columns[i].Visibility == System.Windows.Visibility.Visible)//只導出可見列
{
dt.Columns.Add(dataGrid.Columns[i].Header.ToString());//構建表頭

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Windows;
namespace?execl_test
{
????///?
????///?App.xaml?的交互邏輯
????///?
????public?partial?class?App?:?Application
????{
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????321??2015-11-13?09:45??execl_test\execl_test\App.xaml
?????文件????????306??2015-11-13?09:45??execl_test\execl_test\App.xaml.cs
?????文件??????13824??2015-11-13?10:59??execl_test\execl_test\bin\Debug\Book1.xls
?????文件??????18944??2015-11-13?10:54??execl_test\execl_test\bin\Debug\execl_test.exe
?????文件??????32256??2015-11-13?10:54??execl_test\execl_test\bin\Debug\execl_test.pdb
?????文件??????11600??2015-11-13?10:59??execl_test\execl_test\bin\Debug\execl_test.vshost.exe
?????文件????????490??2014-01-13?21:31??execl_test\execl_test\bin\Debug\execl_test.vshost.exe.manifest
?????文件???????5447??2015-11-13?10:37??execl_test\execl_test\execl_test.csproj
?????文件????????286??2015-11-13?09:52??execl_test\execl_test\Hellow.cs
?????文件???????1102??2015-11-13?09:59??execl_test\execl_test\MainWindow.xaml
?????文件???????5641??2015-11-13?10:54??execl_test\execl_test\MainWindow.xaml.cs
?????文件???????2316??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\App.g.cs
?????文件???????2316??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\App.g.i.cs
?????文件??????15202??2015-11-13?10:18??execl_test\execl_test\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6849??2015-11-13?10:54??execl_test\execl_test\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????1163??2015-11-13?10:59??execl_test\execl_test\obj\x86\Debug\execl_test.csproj.FileListAbsolute.txt
?????文件????????917??2015-11-13?09:50??execl_test\execl_test\obj\x86\Debug\execl_test.csproj.GenerateResource.Cache
?????文件???????1019??2015-11-13?10:04??execl_test\execl_test\obj\x86\Debug\execl_test.csproj.ResolveComReference.cache
?????文件??????18944??2015-11-13?10:54??execl_test\execl_test\obj\x86\Debug\execl_test.exe
?????文件???????1869??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\execl_test.g.resources
?????文件??????32256??2015-11-13?10:54??execl_test\execl_test\obj\x86\Debug\execl_test.pdb
?????文件????????180??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\execl_test.Properties.Resources.resources
?????文件????????276??2015-11-13?10:54??execl_test\execl_test\obj\x86\Debug\execl_test_MarkupCompile.cache
?????文件????????277??2015-11-13?10:35??execl_test\execl_test\obj\x86\Debug\execl_test_MarkupCompile.i.cache
?????文件????1082368??2015-11-13?10:04??execl_test\execl_test\obj\x86\Debug\Interop.Excel.dll
?????文件?????407040??2015-11-13?10:04??execl_test\execl_test\obj\x86\Debug\Interop.Microsoft.Office.Core.dll
?????文件???????1641??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\MainWindow.baml
?????文件???????4796??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\MainWindow.g.cs
?????文件???????4796??2015-11-13?10:37??execl_test\execl_test\obj\x86\Debug\MainWindow.g.i.cs
?????文件???????4608??2015-11-13?09:45??execl_test\execl_test\obj\x86\Debug\TempPE\Properties.Resources.Designer.cs.dll
............此處省略19個文件信息
- 上一篇:(asp.net)網頁打印的全套解決方案
- 下一篇:C#文件夾的操作遍歷文件夾
評論
共有 條評論