Export to Excel - Drawing a frame

poppinspoppins Member Posts: 646
Hi everyone,

I am trying to export some data to excel...

The customer wants each row to be surrounded by a frame...and the whole data to be surronded by a bold frame, just like the picture below:

Does anyone knows how to do this????


  • postsauravpostsaurav Member Posts: 708
    Hi poppins,

    Excel Buffer table have a pre-defined function for same BorderAround.

    This function takes input a range of cells.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?

    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • poppinspoppins Member Posts: 646
    Yes indeed postsaurav, I've just checked it...
    but it draws a thin border...what if I want it to be thick???
  • BeliasBelias Member Posts: 2,995
    try to change the value passed to xlrange1.borderaround instruction. Switch it to 2,3,4 etc. and see the result.
    If this is the property you need, you can:
    a. customize the existing function by adding an additional parameter (i don't recommend this one, as you don't know where's used and where will it be used in the standard nav)
    BorderAround(RangeName : Text[50];BorderStyle : Integer)
    b. create a new function (a copy of borderaround but with the additional parameter
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Mohamed_ZayedMohamed_Zayed Member Posts: 36
    can you please tell me how did you use the Fnc "Boarder Around" in your code?
Sign In or Register to comment.