WPF导入导出Excel文件操作详解

在VS2010中名为Microsoft.Office.Interop.Excel的程序集提供了对Excel操作的相关类，主要相关类有Application，Workbooks，Sheets，_Worksheet，Range 等. 在wpf中打开文件对话框的类为Microsoft.Win32.OpenFileDialog，保存文件对话框的类为Microsoft.Win32.SaveFileDialog，注意，它们都是在Microsoft.Win32的命名空间里。

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        328  2011-05-06 21:53  ExcelExportImport\ExcelExportImport\App.xaml

     文件        313  2011-05-06 21:53  ExcelExportImport\ExcelExportImport\App.xaml.cs

     文件      23552  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\bin\Debug\ExcelExportImport.exe

     文件      46592  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\bin\Debug\ExcelExportImport.pdb

     文件      11600  2011-05-07 15:14  ExcelExportImport\ExcelExportImport\bin\Debug\ExcelExportImport.vshost.exe

     文件        490  2010-03-17 22:39  ExcelExportImport\ExcelExportImport\bin\Debug\ExcelExportImport.vshost.exe.manifest

     文件       1640  2011-05-07 12:07  ExcelExportImport\ExcelExportImport\CommonCommand.cs

     文件       4704  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\ExcelExportImport.csproj

     文件       8908  2011-05-07 15:25  ExcelExportImport\ExcelExportImport\ExcelHelper.cs

     文件       1003  2011-05-07 15:04  ExcelExportImport\ExcelExportImport\MainWindow.xaml

     文件        757  2011-05-06 23:39  ExcelExportImport\ExcelExportImport\MainWindow.xaml.cs

     文件       2988  2011-05-07 14:56  ExcelExportImport\ExcelExportImport\MainWindowViewModel.cs

     文件       2236  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\App.g.cs

     文件       2236  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\App.g.i.cs

     文件      12712  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

     文件       6581  2011-05-07 15:13  ExcelExportImport\ExcelExportImport\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件       1576  2011-05-07 15:14  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport.csproj.FileListAbsolute.txt

     文件      23552  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport.exe

     文件       1603  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport.g.resources

     文件      46592  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport.pdb

     文件        180  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport.Properties.Resources.resources

     文件        349  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport_MarkupCompile.cache

     文件        348  2011-05-07 15:13  ExcelExportImport\ExcelExportImport\obj\x86\Debug\ExcelExportImport_MarkupCompile.i.cache

     文件        196  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\GenerateResource.read.1.tlog

     文件        462  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\GenerateResource.write.1.tlog

     文件       1375  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\MainWindow.baml

     文件       2933  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\MainWindow.g.cs

     文件       2933  2011-05-07 15:06  ExcelExportImport\ExcelExportImport\obj\x86\Debug\MainWindow.g.i.cs

     文件       4608  2011-05-06 21:53  ExcelExportImport\ExcelExportImport\obj\x86\Debug\TempPE\Properties.Resources.Designer.cs.dll

     文件       2217  2011-05-06 21:53  ExcelExportImport\ExcelExportImport\Properties\AssemblyInfo.cs

............此处省略59个文件信息