Import to excel using Excel buffer with different font color

sharad

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.

Luc_VanDyck

Instead of "import to Excel" you mean "export to Excel", right?

Sog

[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.

Luc_VanDyck

sharad wrote:

Please Help me to Solve this.

Try this site: http://lmsmfy.com/?q=excel+font+color

sharad

Sorry,

Yes, I mean Export to Excel

sharad

Thanks Solved