Export to excel x++ column width

Finance and Operations/AX Developer Forum
1

Hi, im exporting some data to excel from x++ code, and i cant find how to increase column width to specific number through x++ code (not autoFit) ? and how to add a border too.

2

Hi Raimondas,

You can refer this link to solve your issue.

http://patrikluca.blogspot.com/2010/04/export-to-excel-with-x-code-sequel.html

http://patrikluca.blogspot.com/2010/06/export-to-excel-with-x-code-continued.html

3

Ive read these allready, there’s no info about changing column width

4

Dont need anymore, figured it out.

5

What was the solution?

6

excel’s comObject with no auto suggested functions but from excels objects functions list

7

excel’s comObject with no auto suggested functions but from excels functions list