C # Read and Write Word files,

C # Read and Write Word files.

A project report at hand is relatively simple. Therefore, the report printing engine uses the VBA engine to customize the Word template, then fill in the data according to the template needs, and then OK and print.

Implementation Method: first, we need to reference VBA to build it. I use Office2003 Professional and the Dll version is Microsoft Word11.0.

 

 

You also need to reference Interop. Word. Dll.

The Code is as follows:

/// # Region open the Word document and return the wDoc and wDoc objects. //// open the Word document and return the wDoc object, wDoc // complete Word file path + name // The returned Word. document wDoc object // The returned Word. application Object public static void CreateWordDocument (string FileName, ref Word. document wDoc, ref Word. application WApp) {if (FileName = "") return; Word. document thisDocument = null; Word. formFields formFields = null; Word. application thisApplication = new Word. applicationClass (); ThisApplication. visible = true; thisApplication. caption = ""; thisApplication. options. checkSpellingAsYouType = false; thisApplication. options. checkGrammarAsYouType = false; Object filename = FileName; Object ConfirmConversions = false; Object ReadOnly = true; Object AddToRecentFiles = false; Object PasswordDocument = System. type. missing; Object PasswordTemplate = System. type. missing; Object Revert = System. Type. missing; Object WritePasswordDocument = System. type. missing; Object WritePasswordTemplate = System. type. missing; Object Format = System. type. missing; Object Encoding = System. type. missing; Object Visible = System. type. missing; Object OpenAndRepair = System. type. missing; Object DocumentDirection = System. type. missing; Object NoEncodingDialog = System. type. missing; Object XMLTransform = System. type. mis Sing; try {Word. document wordDoc = thisApplication. documents. open (ref filename, ref ConfirmConversions, ref ReadOnly, ref AddToRecentFiles, ref PasswordDocument, ref PasswordTemplate, ref Revert, ref WritePasswordDocument, ref WritePasswordTemplate, ref Format, ref Encoding, ref Visible, ref OpenAndRepair, ref DocumentDirection, ref NoEncodingDialog, ref XMLTransform); thisDocument = wordDoc; wDoc = wordDo C; WApp = thisApplication; formFields = wordDoc. formFields;} catch (Exception ex) {MessageBox. show (ex. message) ;}# endregion call the above static method to open the target file and fill in the data in the DataGrid to the corresponding Word tag. // # region Word data filling (For Example) ///// Word fill data /// private void WordLoadData () {Word. document wDoc = null; Word. application wApp = null; sysFun. createWordDocument ("E: \ Monitoring Report (new ). dot ", ref wDoc, ref wApp); // fill the tag" C "with object bkmC =" C "; if (wApp. activeDo Cument. bookmarks. exists ("C") = true) {wApp. activeDocument. bookmarks. get_Item (ref bkmc).select(%%%%wapp.selection.typetext(this.txt 1. text); object bkmG = "TWaterTable3"; object unit; object count; // Number of moving objects extend; extend = Word. wdMovementType. wdExtend; unit = Word. wdUnits. wdCell; // fill in the data in the DataGrid to the tag TWaterTable3 if (wApp. activeDocument. bookmarks. exists ("TWaterTable3") = true) {wApp. activeDocument. bookma Rks. get_Item (ref bkmG ). select (); for (int I = 0; I {if (I = 0) {count = 1;} else {count = 0 ;} // fill in five columns of Data wApp. selection. move (ref unit, ref count); wApp. selection. typeText (gridEX1.GetRow (I ). cells [0]. text); count = 1; wApp. selection. move (ref unit, ref count); wApp. selection. typeText (gridEX1.GetRow (I ). cells [1]. text); wApp. selection. move (ref unit, ref count); wApp. selection. typeText (gridEX1.GetRow (I ). cells [2]. text); wApp. selectio N. move (ref unit, ref count); wApp. selection. typeText (gridEX1.GetRow (I ). cells [3]. text); wApp. selection. move (ref unit, ref count); wApp. selection. typeText (gridEX1.GetRow (I ). cells [4]. text); // wrap wApp. selection. moveRight (ref unit, ref count, ref extend) ;}}# endregion and then OK. When controlling the label table, pay attention to column loops and line breaks. C # Excel operations (Import and Export) Many friends say that C # The code for exporting data to Excel is required, share it with everyone ///// read the Excel document ///// file name /// return a DataSet public DataSet ExcelToDS (string Path) {String strConn = "Provider = Microsoft. jet. OLEDB.4.0; "+" Data Source = "+ Path +"; "+" Extended Properties = Excel 8.0; "; OleDbConnection conn = new OleDbConnection (strConn); conn. open (); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = null; strExcel = "select * from [sheet1 $]"; myCommand = new OleDbDataAdapter (strExcel, strConn); ds = new DataSet (); myCommand. fill (ds, "table1"); return ds ;}/ ///// Write the Excel document ///// file name public bool SaveFP2toExcel (string Path) {try {string strConn = "Provider = Microsoft. jet. OLEDB.4.0; "+" Data Source = "+ Path +"; "+" Extended Properties = Excel 8.0; "; OleDbConnection conn = new OleDbConnection (strConn); conn. open (); System. data. oleDb. oleDbCommand cmd = new OleDbCommand (); cmd. connection = conn; // cmd. commandText = "UPDATE [sheet1 $] SET Name = '2017-01-01 'WHERE employee ID = 'date '";// Cmd. ExecuteNonQuery (); for (int I = 0; I {if (fp2.Sheets [0]. Cells [I, 0]. Text! = "") {Cmd. commandText = "insert into [sheet1 $] (employee ID, name, department, title, date, time) VALUES ('" + fp2.Sheets [0]. cells [I, 0]. text + "','" + fp2.Sheets [0]. cells [I, 1]. text + "','" + fp2.Sheets [0]. cells [I, 2]. text + "','" + fp2.Sheets [0]. cells [I, 3]. text + "','" + fp2.Sheets [0]. cells [I, 4]. text + "','" + fp2.Sheets [0]. cells [I, 5]. text + "')"; cmd. executeNonQuery () ;}} conn. close (); return true;} catch (System. data. oleDb. oleDbException ex) {System. di Agnostics. Debug. WriteLine ("an error occurred when writing to Excel:" + ex. Message);} return false;} This method is quite effective. Appendix: VB. NET version to enable and disable word. If you are interested, you can study VB. NET to enable and disable Imports word' to open Dim mWordapp As word. application 'word Application Dim mobjDoc As word. document 'word Document Dim fullFileName as string' file path mWordapp = CreateObject ("word. application ") mobjDoc = mWordapp. documents. add (FullFileName) 'disable Dim missing As Object = System. reflection. missing. valuemWordapp. application. quit () If Not mobjDoc Is Nothing Then 'garbage collection System. runtime. interopServices. marshal. releaseComObject (mobjDoc) mobjDoc = NothingEnd IfIf Not mWordapp Is Nothing ThenSystem. runtime. interopServices. marshal. releaseComObject (mWordapp) mWordapp = NothingEnd If 'truly releases the word Process

 

C language ^ how to use

A1 = 0x01; // 0000 0001
A2 = 0x00; // 0000 0000
A3 = 0x03; // 0000 0011
A4 = 0x02; // 0000 0010

B1 = a1 ^ a2; // 0000 0001
B2 = a1 ^ a3; // 0000 0010
B3 = a1 ^ a4; // 0000 0011

^ XOR operator. The bitwise value is 0 and the difference is 1. See the example above.

//
Examples of simple and practical problems:
====================================
======= A ======= B =========
There are two circuits on the top. The two switches are a and B respectively. The opening status is \ [1], and the closing status is/[0].
If both circuits are enabled or disabled.
If a turns on [1], B turns off [0], and circuit 1 Powers on
=====================
If a disables [0], B enables [1], and circuit 2 powers on.
====================================
In summary, the circuit fails in the and B states simultaneously [0]. When a and B are different, the power is charged [1].

C language ^ how to use

A1 = 0x01; // 0000 0001
A2 = 0x00; // 0000 0000
A3 = 0x03; // 0000 0011
A4 = 0x02; // 0000 0010

B1 = a1 ^ a2; // 0000 0001
B2 = a1 ^ a3; // 0000 0010
B3 = a1 ^ a4; // 0000 0011

^ XOR operator. The bitwise value is 0 and the difference is 1. See the example above.

//
Examples of simple and practical problems:
====================================
======= A ======= B =========
There are two circuits on the top. The two switches are a and B respectively. The opening status is \ [1], and the closing status is/[0].
If both circuits are enabled or disabled.
If a turns on [1], B turns off [0], and circuit 1 Powers on
=====================
If a disables [0], B enables [1], and circuit 2 powers on.
====================================
In summary, the circuit fails in the and B states simultaneously [0]. When a and B are different, the power is charged [1].