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
-
Try Excel automation
0 -
Sorry, but I learned that Excel automations do not work and are not supported in NAV 2018 anymore :-((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