说明：  用于uibot将数字转换为文字格式（数字前加‘），存入excel 1、将文件拷贝到C:\Program Files (x86)\UiBotCreator\extend\python\下。 2、在uibot的源代码中加入 import changetext dim sText = "" sText = “001”//要转文本格式的数据 sText = changetext.totxt(sText) objExcelWorkBook = Excel.WorkBookOpen(@res"文件名.xlsx","","")//打开与源代码存储在同一个目录下的res目录中的excel文件 sText = changetext.totxt(sText) Excel.CellSetText(objExcelWorkBook,1,1,1,sText)//写入到第一个工作簿的a1单元格 Excel.WorkBookSave(objExcelWorkBook,"")//关闭excel
(Used for uibot to convert digits to text format (add''before digits) and store them in Excel 1. Copy the file to C: Program Files (x86) UiBotCreator extend python. 2. Add in source code Import changetext Dim sText = "" SText = 001 // / Data to be converted to text format SText = changetext. totxt (sText) ObjExcelWorkBook = Excel. WorkBook Open (@res "File Name. xlsx", "")// Open Excel files stored in the res directory in the same directory as the source code SText = changetext. totxt (sText) Excel. CellSetText (objExcel WorkBook, 1, 1, 1, sText)// Writes to the A1 cell of the first Workbook Excel. WorkBook Save (objExcelWorkBook, ")// Close Excel)