I am trying to read until the last filled row in a column in Excel in Revit Python Shell.
I've read a lot of posts but I can't find a solution that works for me.
There is a picture of the code I'm working with. Line 15 shows how the last row would be in VBA, but I need a solution that works in Revit Python Shell.
Lines 18 and 20 show a range, but I want to adapt them to go until the last filled row.
I'm new in Python and Revit Python Shell.
I tried to import xlrd to try to find out if it could somehow help, but revit Python Shell shows an error:
Exception : IronPython.Runtime.Exceptions.ImportException: No module named xlrd
at Microsoft.Scripting.Runtime.LightExceptions.ThrowException(LightException lightEx)
at Microsoft.Scripting.Runtime.LightExceptions.CheckAndThrow(Object value)
at Microsoft.Scripting.Interpreter.FuncCallInstruction`2.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1)
at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx)
at Microsoft.Scripting.Hosting.ScriptSource.Execute(ScriptScope scope)
at Microsoft.Scripting.Hosting.ScriptSource.ExecuteAndWrap(ScriptScope scope, ObjectHandle& exception)
I don't know how to to solve this. And I don't really know if xrld would help me anyway.
Sorry if this question is stupid, I could not understand how to use Excel in Revit Python Shell...