Civil 3d dynamo error in reading excel

Civil3D
1

Hi everyone,

Has anyone encountered this error? if yes do you know how to fix it?

“Warning: Data.ImportExcel operation failed.
Creating an instance of the COM component with CLSID {00024500-0000-0000-C000-000000000046} from the IClassFactory failed due to the following error: 80010108 The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)).”

2

try to re install office 365 or repair it . it should be good

3

Tried it… but still getting the same error… Even tried to uninstall re install the Civil 3D software… still same error.

4

I worked around this problem by using ExcelReader lib., otherwise you can import CSV data instead.

5

Instead, you can type the following code in PythonScript to do exactly the same thing.

IN[0] = file_path(string)
IN[1] = sheet_name(string)

------------------------Code-----------------------------------
import openpyxl

file_path = IN[0]
sheet_name = IN[1]

wb = openpyxl.load_workbook(file_path, data_only = False)
ws = wb[sheet_name]

result =
for i in range(ws.max_row):
row_values =
for j in range(ws.max_column):
row_values.append(
ws.cell(row=i+1, column=j+1).value
)
result.append(row_values)

OUT = result