那个大仙有操作office通用类

 那个大仙有操作office通用类 --------------------编程问答-------------------- NPOI (不过目前好像只是做EXcel)
QQ交流群:  78142590 --------------------编程问答-------------------- VSTO可否有帮助？ --------------------编程问答-------------------- 关注，顶一下~~~ --------------------编程问答-------------------- NPOI 可以操作Word， 不过目前的版本Word  bug太多 ， 据情况， 也快了。。  --------------------编程问答-------------------- 根据WORD，EXCEL实现不同操作
--------------------编程问答-------------------- public string query_table_getdata(string sourpath) 2         { 3             string str_path = sourpath.Substring(0, sourpath.Length - 22); 4             str_path = str_path + "basic.xls"; 5  6             Excel.QueryTables m_objQryTables = null; 7             Excel.QueryTable m_objQryTable = null; 8             Excel.Application m_objExcel = null; 9             Excel.Workbooks m_objBooks = null;10             Excel.Workbook m_objBook = null;11             Excel.Sheets m_objSheets = null;12             Excel.Worksheet m_objSheet = null;13             Excel.Range m_objRange = null;14             m_objExcel = new Excel.Application();15 16             //try17             //{18                 m_objBooks = m_objExcel.Workbooks;19                 m_objBooks.Open(sourpath, Type.Missing, Type.Missing, Type.Missing, Type.Missing,20                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);21 22                 m_objBook = (Excel.Workbook)m_objBooks.get_Item(1);23 24 25                 m_objSheets = (Excel.Sheets)m_objBook.Worksheets;26                 m_objSheet = (Excel.Worksheet)m_objSheets.get_Item(1);27                 m_objRange = m_objSheet.get_Range("A2", Type.Missing);28                 m_objQryTables = m_objSheet.QueryTables;29                 string sqlstr = "SELECT [day01],[day02],[day03],[day04],[day05],[day06],[day07],[day08],[day09],[day10],[day11],[day12],[day13],[day14]";30                 sqlstr += ",[week01] ,[week02],[week03],[week04],[week05],[week06],[week07],[week08],[week09],[week10],[week11],[week12],[week13],[week14]";31                 sqlstr += ",[week15],[week16],[week17],[week18],[week19],[week20],[week21],[week22],[week23],[week24]";32                 sqlstr += " FROM [GDS_Service].[dbo].[GDS_Service_Report_Base] order by groupID ,id";33                              //可以放在配置文件里34                 string conn = @"Provider=SQLOLEDB.1;Data Source=MININT-G87PHNA\SQLEXPRESS;uid=xijun_ke;Password=12345678;                   Initial Catalog=GDS_Service;Persist Security Info=False;";35 36                 m_objQryTable = (Excel.QueryTable)m_objQryTables.Add("OLEDB;" + conn, m_objRange, sqlstr);37 38                 m_objQryTable.RefreshStyle = Excel.XlCellInsertionMode.xlInsertEntireRows;39 40                 m_objQryTable.Refresh(false);41                 m_objBook.SaveAs(str_path, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);42                 m_objBook.Close(false, Type.Missing, Type.Missing);43             //}44             //catch (Exception ee)45             //{46             //    mp.WriteLog(ee.ToString());47             //}48             //finally49             //{50                 m_objExcel.Quit();51                 GC.Collect();52             //}53             return str_path;54 55         } --------------------编程问答--------------------

补充：.NET技术 ,  C#