format the cells while export to exces

suresh111
Member Posts: 32
Hi
can any one help me to format the cells in the excel sheets, when we create a excel sheet through a report. I am not able to format the cell as date and text etc.,
suresh
can any one help me to format the cells in the excel sheets, when we create a excel sheet through a report. I am not able to format the cell as date and text etc.,
suresh
0
Comments
-
Hi Suresh,
do you want to export via ExcelBuffer or directly via Excel automation objects?
Greetings
KaiKai Huegle
from mack-rides.com0 -
yes, it is through automation objects
suresh0 -
Hi Suresh,
you will find many information about this in table 370 (Excel Buffer) in the code sections.
You have to adress the excel object properties as you use it in visualbasic (opt. vba). But you have to use the codenumbers not the excel expressions (use f.e. -4131 instead of xlHAlignLeft to align horizontal).
Greetings from the black forest
Kai
Some examples:
(you will find the numbers to use in the object catalog of excel vba editor)
XlWorkSheet.Range(xlColID + xlRowID).NumberFormat := NumberFormat;
XlWorkSheet.Range(xlColID + xlRowID).Value := "Cell Value as Text"
XlWorkSheet.Range(xlColID + xlRowID).Formula := Formula;
XlWorkSheet.Range(xlColID + xlRowID).AddComment := Comment;
XlWorkSheet.Range(xlColID + xlRowID).Font.Bold := Bold;
XlWorkSheet.Range(xlColID + xlRowID).Font.Italic := Italic;
XlWorkSheet.Range(xlColID + xlRowID).Borders.LineStyle := XlLineStyleNone;Kai Huegle
from mack-rides.com0
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