Python calls the java Module SmartXLS and jpype to modify the excel file

This article mainly introduces how to use python to call the java Module SmartXLS and jpype to modify excel files. it involves the related skills of Python to call the java module and is of great practical value, for more information about how to modify an excel file, see the example in this article. Share it with you for your reference. The specific implementation method is as follows:

#-*-Coding: utf8-*-"use the java Module SmartXLS and jpype to modify excel and xlrd, different from xlwt, xlwt can generate and maintain the chart "from _ Ure _ import print_function, pisionimport osimport jpype # OS. environ ['Java _ home'] = "/usr/lib64/jvm/default-JAVA" jpype. startJVM (jpype. getDefaultJVMPath (), '-Djava. class. path = SX. jar ') WorkBook = jpype. JClass ('com. smartxls. workBook ') w = WorkBook () w. read ("B .xls") w. setNumber (0, 2, 0, 20.0) w. write ("c.xls ")

I hope this article will help you with Python programming.