java.lang.OutOfMemoryError: Python中的Java堆空间

Question

我不明白这个错误是与Java或Python有关的。我试图配置Java来增加大小，但失败了。这段代码是用木星笔记本编写的。

import  jpype
import numpy
import pandas
import win32com.client as win32
import os
import pyspark
import EasyExcel 
from xlrd import open_workbook
import  asposecells
jpype.startJVM()
from asposecells.api import Workbook
workbook = Workbook(r"C:\Users\prajw\Downloads\LargeFile.xlsx")
workbook.save(r"C:\Users\prajw\Downloads\LargeFile1.xlsb")
jpype.shutdownJVM()

错误

Exception                                 Traceback (most recent call last)
~\anaconda3\lib\site-packages\_jpype.cp39-win_amd64.pyd in com.aspose.cells.Workbook.save()

Exception: Java Exception

The above exception was the direct cause of the following exception:

java.lang.OutOfMemoryError                Traceback (most recent call last)
~\AppData\Local\Temp\ipykernel_6056\723174829.py in <module>
      6 from asposecells.api import Workbook
      7 workbook = Workbook(r"C:\Users\prajw\Downloads\LargeFile.xlsx")
----> 8 workbook.save(r"C:\Users\prajw\Downloads\LargeFile1.xlsb")
      9 jpype.shutdownJVM()

java.lang.OutOfMemoryError: java.lang.OutOfMemoryError: Java heap space

我希望输出是以小数据格式保存xlsb文件。

Answer 1

通过https://jpype.readthedocs.io/en/latest/userguide.html#controlling-the-jvm，您可以向startJVM发送参数。

如果您想要增加最大内存，您将使用jpype.startJVM("-Xmx2g")。根据需要调整实际大小。

运行java --help或java -X以获得可用选项。