Alternate Solution for Excel Validation

Hi Team,

I created a workflow using excel validation,but later i realized the server which i want to run the work flow doesn’t have MS Excel which its not possible to install also.
How can i run this workflow if it didn’t support excel?
Appreciate your inputs.

@RajeshT

If we don’t have Excel application installed in that machine then we can use Workbook activities.

Hi @lakshman,

Thank you for the response,will the workbook activities acts same as Excel?
Can you explore more?
How to read workbook and how to write.

1 Like

@RajeshT

There are two workbook activities called Read Range and write Range. It will help you to do this.

Just specify excel file path,sheet name and Range you want to read.

2 Likes

Hi @lakshman ,

You mean the below ones:
image

image

2 Likes

@RajeshT

Yes, exactly.

1 Like

Hi @lakshman ,

So the “Excel application scope” activity wont work in this case right?

You don’t use the excel application scope activity with the workbook activities.

1 Like

@RajeshT

Yes it won’t work. Directly you place this activities and provide required values.

Thanks a ton @lakshman !!

1 Like

Thank you @CBlanchard for your inputs!

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