Can i get an excell doc as an input?

i am trying to get an excell doc as an input and do process on the excell doc by getting values that can be given by the user. can someone give me instructions for what the variables should be set for this(for getting the excell doc as input and reading the range value as input aswell)?

@Suryanarayanan_Shanmugam,

Welcome to the UiPath Community :tada:

Follow this approach.

Thanks,
Ashok :slight_smile:

Yes, you can definitely process Excel documents as input in UiPath. UiPath offers a dedicated set of activities for working with Excel files through the UiPath.Excel.Activities package.

What is the varaible type for dtInput because i am getting “Log Message: Object reference not set to an instance of an object.” as an error?

@Suryanarayanan_Shanmugam,

It’s DataTable Data type.

image

Thanks,
Ashok

i am still getting “Log Message: Object reference not set to an instance of an object.” Is there anyway i can overcome this problem?

@Suryanarayanan_Shanmugam,

Share your workflow please. Let me check

Thanks,
Ashok :slight_smile:

HI @Suryanarayanan_Shanmugam

I guess you missed to give dtInput in the Read range output property because of which dtInput is empty and giving you an error.

Try it.Hope it helps


this is the workflow

@Suryanarayanan_Shanmugam,

I got it. You missed to configure Output/DataTable property to DtInput

Thanks,
Ashok :slight_smile:

@Suryanarayanan_Shanmugam Yes !! Give dtInput in the output property(higlighted in yellow) of ReadRange

Not trying to be a troll here, but these are all basics. Basics are covered in the UiPath training modules on UiPath Academy.
Please check those on excel handling, they’ll answer most of your questions.

Thank You Sir for your help

@Suryanarayanan_Shanmugam,

Glad I’m able to help you. Kindly mark my answer as solution. It will help other community member to find it quickly.

Thanks,
Ashok :slight_smile:

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