Home > Software engineering >  How to use VBA to get and set the content of the Excel WorkBook (XML format)
How to use VBA to get and set the content of the Excel WorkBook (XML format)

Time:09-25

Doing a project recently, need to use the web page NTKO Office editor implementation of Word, Excel and other Office Document processing, request to online according to the Document template is initialized, save into the database after revised and resubmitted to the background, the first to do Word part, using the Word VBA members of the Content of the XML Document object in properties and InsertXML method, can realize the template injection and data extraction, and then do the Excel part when it was not line, the original Excel VBA is corresponding to the Workbook object, so don't know what to do, you life, also
  •  Tags:  
  • VBA
  • Related