Export to Excel - Drawing a frame

poppins
Member Posts: 647
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????
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????
0
Comments
-
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 + Page0 -
Yes indeed postsaurav, I've just checked it...
but it draws a thin border...what if I want it to be thick???0 -
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)
example:BorderAround(RangeName : Text[50];BorderStyle : Integer)
b. create a new function (a copy of borderaround but with the additional parameter0 -
can you please tell me how did you use the Fnc "Boarder Around" in your code?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions