We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose-cells python plugin is not working with latest jpype release

when we tried with latest jpype(1.0.2)…jpype is unable to discover aspose libraries.
python code:

import jpype

import asposecells

jpype.startJVM()

from asposecells.api import Workbook, FileFormatType

workbook = Workbook(FileFormatType.XLSX)

workbook.getWorksheets().get(0).getCells().get("A1").putValue("Hello World")

workbook.save("output.xlsx")

jpype.shutdownJVM()

#workbook =  jpype.JClass("com.aspose.cells.Workbook")("output.xlsb")

with older version of jpype(0.7.5)…i am able to create workbook and save it.if i try to open existing excel/apply formats, we are getting below error


Deprecated: convertStrings was not specified when starting the JVM. The default
behavior in JPype will be False starting in JPype 0.8. The recommended setting
for new code is convertStrings=False. The legacy value of True was assumed for
this session. If you are a user of an application that reported this warning,
please file a ticket with the developer.

warnings.warn("""
Traceback (most recent call last):
File “aspose_xlsb_test.py”, line 6, in
workbook = Workbook(FileFormatType.XLSX)
File “C:\Users\Chandan.HR\Anaconda3\lib\site-packages\asposecells\api.py”, line 2992, in init
super(Workbook, self).init(*args)
TypeError: object.init() takes exactly one argument (the instance to initialize)

@taruney,
It looks like JPype version issue. The more recent or very older versions might have issues when working with Aspose.Cells for Python API. We recommend you to use JPype1 version 0.7.0. Such issues will be fixed in our future releases. As pip command line will install the latest version of jpype, so you have to uninstall the latest version/other version and install the 0.7.0 version specifically.