Microsoft Dynamics AX (Archived)

Export to excel and cell borders

(0) Share

Report

Posted on by Xainu Khan

165

Hi all,

I have to export excel file in customized format. Having borders around my cells.

Can anyone help me to share some blog related excel export with customized format.

Thanks

Zain Khalid Khan

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Martin Dráb 237,967 Most Valuable Professional on at

Like (1)

Report
You have to main options:

You'll use a template with predefined formatting and merely fill it with data at runtime.

You'll set formatting at runtime using an API for manipulating Excel files.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Zain Khan,

Rather than modifying something in AX wouldn't it be easier doing some kind of automatic formatting in Excel directly for example by making use of Excel-Macros?

Maybe think about this option before making a system modification.

Best regards,

Ludwig

Was this reply helpful? Yes No
Xainu Khan 165 on at

Like (0)

Report

I have already customized export to excel. All i need to mofify is to add border around certain cells. I am using SysExcelApplication api.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi Zain,

Please refer to similar question on community community.dynamics.com/.../134487

Was this reply helpful? Yes No
Xainu Khan 165 on at

Like (0)

Report

Is there any blog related detailed api methods of SysExcelApplication.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

SysExcelApplication does not have a method to work with borders. It is just a wrapper around com object.

So you have to either create your own x++ methods to wrap com or use com directly as previous discussion does.

It has all the code you need, any way here you go another blog post how to create new method for borders :

axapta2009.wordpress.com/.../applying-formats-to-excel-reports-using-x-in-ax-2009

But again its just com no nice x++ methods.

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (1)

Report

Also note that there are managed (.NET) wrappers around these COM objects, which may be easier to use, especially if you're already familiar with .NET.

Was this reply helpful? Yes No
Xainu Khan 165 on at

Like (0)

Report

Thanks ievgen you referred looks helpful to me.

I am trying with these blogs.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Don't hesitate to share your solution with us.

Was this reply helpful? Yes No
Xainu Khan 165 on at

Like (0)

Report

Will surely share the solution, after work done.

Was this reply helpful? Yes No