Import to excel using Excel buffer with different font color

sharad
Member Posts: 112
Hi Experts,
I've made a report and it has option import to excel. I use Excel Buffer table for this functionality.
I want Import to excel using Excel buffer with different font color or column color.
Is it possible to Achieve this by using Excel Buffer or any thing else.
Please Help me to Solve this.
Thanks in Advance.
I've made a report and it has option import to excel. I use Excel Buffer table for this functionality.
I want Import to excel using Excel buffer with different font color or column color.
Is it possible to Achieve this by using Excel Buffer or any thing else.
Please Help me to Solve this.
Thanks in Advance.
Sharad Gupta
Navision Technical Consultant & .Net Developer
Navision Technical Consultant & .Net Developer
0
Answers
-
Instead of "import to Excel" you mean "export to Excel", right?No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
-
[a bit offtopic]
I believe it's export to excel you mean.
Usually the functions in NAV that communicate with external programs are from NAV's point of view. Export to <program> from NAV, or import from <program> to NAV.
[/a bit offtopic]
The excel buffer does not support different fonts/colors/backcolors out of the box. But the excel automation does support these. Since the excel buffer uses the Excel automation, it shouldn't be a too hard of a challenge to modify the excel buffer with support for these. Ofcourse you can also just use the excel automation directly in your report. However I'd suggest modifying the exel buffer, so that when the customer is satisfied with the export and requests other reports to have the same functionality, you don't have to copy paste your code.
However, since you're posting in Three Tier forum, the excel buffer performs worse on RTC than on the classic client.
You'll find topics adressing this issue, feel free to consult these.0 -
sharad wrote:Please Help me to Solve this.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0
-
Sorry,
Yes, I mean Export to ExcelSharad Gupta
Navision Technical Consultant & .Net Developer0 -
Thanks SolvedSharad Gupta
Navision Technical Consultant & .Net Developer0
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