Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 2018 Excel Buffer .NET Cell Alignment
rocksoft63
Member Posts: 2
Hello.
Is there any way to align cells (horizontal/vertical) after writing an Excel sheet via T370 (Excel Buffer)?
In earlier versions of NAV when using automations the 'Range' object provided every possibility of cell
design. Just recorded an Excel macro and built the functionality in T370.
Now the .NET object XlWrkSht.Range has only a limited repertoire of methods and properties (as far as
I can see) and especially the urgently needed 'HorizontalAlignment' (with an Enumeration afterwards)
seems not to be included.
I know that this functionality will not decide if the battle is won or lost :-) but those basic things make
a huge difference on distributing your Excel file, wether it's pretty or not.
All that I got is a tremendous headache by running against the walls with all I tried out...
Any help would be appreciated. Thanks
Is there any way to align cells (horizontal/vertical) after writing an Excel sheet via T370 (Excel Buffer)?
In earlier versions of NAV when using automations the 'Range' object provided every possibility of cell
design. Just recorded an Excel macro and built the functionality in T370.
Now the .NET object XlWrkSht.Range has only a limited repertoire of methods and properties (as far as
I can see) and especially the urgently needed 'HorizontalAlignment' (with an Enumeration afterwards)
seems not to be included.
I know that this functionality will not decide if the battle is won or lost :-) but those basic things make
a huge difference on distributing your Excel file, wether it's pretty or not.
All that I got is a tremendous headache by running against the walls with all I tried out...
Any help would be appreciated. Thanks
0
Answers