一、通用操作
1)用Excel Application Scope读写excel, 操作datatable;
2)手动新建dt(可固定表头),进行dt的增删筛选,然后写入excel;
二、.Net写法,用inokeCode来操作excel
1)文本打开xaml文件,
a. 在<sco:Collection x:TypeArguments="x:String">标签下级插入 <x:String>Microsoft.Office.Interop.Excel</x:String>
b. 在<sco:Collection x:TypeArguments="AssemblyReference">标签下级插入 <AssemblyReference>Microsoft.Office.Interop.Excel</AssemblyReference>
2)invoke里面进行.net代码操作
'Dim xlApp As Microsoft.Office.Interop.Excel.Application = Nothing
Dim xlWorkBooks As Microsoft.Office.Interop.Excel.Workbooks=Nothing
'Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook=Nothing
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet=