Reading data from Excel file

[gilberto.arechigaiba]

Hola amigo @d.kelfkens buenas. I get a similar situation, i guess you are open 5 times the file to read 5 diferent sheets, what you can do is make an phyton script to open the excel file read the sheets names and close the file, then you can use ImportExcel node to read the data from each sheet in the list that you previosly get, this way you only open the file 1 time and clean the data. I’m not the autor of this script i let you also the original post, you can copy the code there!!

Get Excel sheets names

Hello, using COM objects is more difficult with PythonNet, here some solutions [image] without Excel Interrop using OpenXml (Dynamo has integrated this lib since 2.10, need to be confirm) import sys import clr import System from System import Array from System.Collections.Generic import List, IList, Dictionary clr.AddReference('DocumentFormat.OpenXml') import DocumentFormat from DocumentFormat.OpenXml import * from DocumentFormat.OpenXml.Packaging import * from DocumentFormat.OpenXml.Spre…