How to load an excel file in IronPython?

Question

I am trying to load an excel file within an IronPython script, which is embedded within a software. I tried to do this with the following code:

import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
import Microsoft.Office.Interop.Excel as Excel
excel = Excel.ApplicationClass()
excel.Visible = True
workbook = excel.Workbooks.Open("C:\Users\antoi\Desktop\rimo_report\ae-project-reporting\codes_02_heat_recovery\data\unit_data_simp_08.xlsx")

However, I get an error that the file path cannot be found. From the error, it seems it is not searching within my own computer. How could one do this ? Do I have to import other packages ?

Forague · Accepted Answer · 2022-11-14 08:39:40Z

1

if it's just a path error, try to escape your \.

\ is a character used to escape some other characters (such as quotes, new lines, etc)

So when python is reading your code and interpreting it, it is trying to understand the characters you escaped such as \U, \a ...

To avoid this problem you can try this :

workbook = excel.Workbooks.Open("C:\\Users\\antoi\\Desktop\\rimo_report\\ae-project-reporting\\codes_02_heat_recovery\\data\\unit_data_simp_08.xlsx")

answered Nov 14, 2022 at 8:39

Forague

1691 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Checster Over a year ago

Thank you so much. Do you also know how to change cell values once the files is open ? Can't find any documentation anywhere :(

Forague Over a year ago

I'm sorry I don't know, I just found this link which might help you, but it doesn't use the same library as you : geeksforgeeks.org/change-value-in-excel-using-python

Collectives™ on Stack Overflow

How to load an excel file in IronPython?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related