Excel "CurrentWorksheet" object returns null always

#1

Hi, I need to use the Range method for CurrentWorkSheet object to get the NumberFormat property for a specific cell but worksheet object returns null value for some reason. Did anyone else come across this scenario?

Any help/lead is appreciated. Thanks.

PS: in the screenshot, wbJournal variable is a WorkbookApplication object obtained as output from Excel Application Scope activity.

image

#2

Hi @swathykodoth

Welcome to our UiPath Forum! :slight_smile:

Please try it like this:

String.Join(",",workbookVariable.GetSheets(0).ToArray)

or simpler

workbookVariable.GetSheets(0).ToString

The thing is, I suppose Excel Application Scope simply won’t have the CurrentWorksheet set due to the fact that you don’t specify any concrete sheet to be worked on when you invoke it.

#3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.