Hide gridlines in Excel

[fairymemay (noona)]

I want to Hide gridlines in Excel.

How to solve it?

[Srini84 (Srinivas)]

@fairymemay

Check below for your reference

Hide gridlines in a worksheet using Excel and VBA | Exceldome

Hope this may help you

Thanks

[fairymemay (noona)]

@Srini84 I​ must​ create​ file​ macro​ right?
Or​ use​ invoke​ code?

[Srini84 (Srinivas)]

@fairymemay

Yes, you can create Macro

Hope this will help you

Thanks

[nikhil.girish]

Hi @fairymemay

An alternative easy solution

We have Bala Reva excel activities

Kindly refer below video

Uipath set border in excel | change border color in excel (BalaReva)

You please set border colour as White

So that it works as expected @fairymemay
Thanks

[fairymemay (noona)]

It can use invoke code activity or not ?

[nikhil.girish]

You can @fairymemay

[fairymemay (noona)]

@nikhil.girish But now error.

How can write code?

[ushu (Usha kiranmai)]

@fairymemay Try this, you can also write VB code in the text file and can call it in excel scope. Attaching the below sample workflow

Example.zip (9.1 KB)

Below is the output looks like