32
Views
7
Comments
[Advanced Excel] border is not working and it throws error as "Object reference not set to an instanc"
Question
advanced-excel
Service icon
Forge asset by Carlos Freitas
Application Type
Service

error received as "Object reference not set to an instance of an object "

2022-12-22 10-00-39
Beatriz Sabino

Hi Vanaraj, 

Could you provide more details about your use case? 

What parameters are you using in your actions? How is how logic flow? 

If you could provide an example. oml file would be even better. 

UserImage.jpg
Vanaraj Vellapandi

Please find the attached image for your reference. When we set the BorderStyle property, it throws an error, while other functionalities are working fine. 

UserImage.jpg
Vijay sundaram

Hi @Vanaraj Vellapandi ,
Instead  of Cell_format Range use cell_write range 
there u can  provide dataset value : tobject(pass the list)

UserImage.jpg
Vanaraj Vellapandi

please help me to resolve this error

2022-12-22 10-00-39
Beatriz Sabino

Hi Vanaraj,

I just tried to replicate the flow shown in the picture and I got no errors.
This is the excel cell formatted.
Could you provide a sample .oml with the logic you are using to see what the issue might be?

UserImage.jpg
Vanaraj Vellapandi

In the attached excel screenshot there is no border, please check attached one with border

excelborder.png
UserImage.jpg
Vanaraj Vellapandi

Thank you for everyone who support. Now working fine with same code.

Vana_Working.oml
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.