com.aspose.cells.com.aspose.cells.CellsException: com.aspose.cells.CellsException: Invalid column index. (Python)

Aspose.Cells Product Family
1

I am trying to convert excel with multiple sheet. When I try to convert with python. I am getting

raceback (most recent call last):
File “com.aspose.cells.Workbook.java”, line -1, in com.aspose.cells.Workbook.save
Exception: Java Exception

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

Traceback (most recent call last):
File “/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/runpy.py”, line 198, in _run_module_as_main
return _run_code(code, main_globals, None,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/runpy.py”, line 88, in _run_code
exec(code, run_globals)
File “/Users/rohit/.vscode/extensions/ms-python.python-2023.4.0/pythonFiles/lib/python/debugpy/adapter/…/…/debugpy/launcher/…/…/debugpy/main.py”, line 39, in
cli.main()
File “/Users/rohit/.vscode/extensions/ms-python.python-2023.4.0/pythonFiles/lib/python/debugpy/adapter/…/…/debugpy/launcher/…/…/debugpy/…/debugpy/server/cli.py”, line 430, in main
run()
File “/Users/rohit/.vscode/extensions/ms-python.python-2023.4.0/pythonFiles/lib/python/debugpy/adapter/…/…/debugpy/launcher/…/…/debugpy/…/debugpy/server/cli.py”, line 284, in run_file
runpy.run_path(target, run_name=“main”)
File “/Users/rohit/.vscode/extensions/ms-python.python-2023.4.0/pythonFiles/lib/python/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_runpy.py”, line 321, in run_path
return _run_module_code(code, init_globals, run_name,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/Users/rohit/.vscode/extensions/ms-python.python-2023.4.0/pythonFiles/lib/python/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_runpy.py”, line 135, in _run_module_code
_run_code(code, mod_globals, init_globals,
File “/Users/rohit/.vscode/extensions/ms-python.python-2023.4.0/pythonFiles/lib/python/debugpy/_vendored/pydevd/_pydevd_bundle/pydevd_runpy.py”, line 124, in _run_code
exec(code, run_globals)
File “/Users/rohit/Desktop/test.py”, line 12, in
workbook.save("/Users/rohit/Desktop/example.pdf", saveOptions)
com.aspose.cells.com.aspose.cells.CellsException: com.aspose.cells.CellsException: Invalid column index.

2

@singhrohit003,

Could you please zip and attach your input Excel file to evaluate your issue. We will check your issue soon.

3

This is my code:
import jpype

import asposecells

jpype.startJVM()

from asposecells.api import Workbook, FileFormatType, PdfSaveOptions, PdfCompliance

workbook = Workbook("/Users/rohit/Desktop/KCL-VW QA Assessment - Final (1).xlsx")

Convert Excel to PDF

#workbook.save(“xlsx-to-pdf.pdf”, SaveFormat.PDF)

saveOptions = PdfSaveOptions()

workbook.save("/Users/rohit/Desktop/example.pdf", saveOptions)

jpype.shutdownJVM()
test.xlsx.zip (69.4 KB)

4

@singhrohit003
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSPYTHONJAVA-57
5

@singhrohit003
The bug has been fixed in Aspose.Cells for Python via Java v23.4. Please install it from aspose-cells · PyPI
Thanks.