Export to Spreadsheet formatting not working.

[jlscranton]

When I use the AEEXPORT2SS command, I'd like my spreadsheet to retain the formatting I choose every time I export. There are lots of attributes being exported that I do not need and would like to move them to the right side of the spreadsheet or get rid of them altogether. I tried editing the wd_xls_all_template.xlt file the restarting autocad, but it didn't seem to work. Am I doing something wrong?

[rhesusminus]

What option do you choose when running the AEEXPORT2SS command?

What sheet in the WD_XLS_ALL_TEMPLATE.XLT did you edit?

THL

[jlscranton]

I chose to export "components" like you have shown. I edited the "comp" sheet in the wd_xls_all_template.xlt file. I also made sure to save it back as an .xlt, not an .xls. After all that, I restarted autocad and excel, but saw no change when I exported to a spreadsheet.

[rhesusminus]

Just to make sure that there aren't any other versions of this file lying around, try to write this on the command line:

Command: (c:ace_find_file "wd_xls_all_template.xlt" nil)
"C:\\program files\\autodesk\\acade 2012\\support\\wd_xls_all_template.xlt"

THL

[jlscranton]

Only reported back this file path, which is the file I changed.

"C:\\program files\\autodesk\\acade 2010\\support\\wd_xls_all_template.xlt"

[rhesusminus]

Seems like it only uses this XLT-file when using the "General (all * below)" option in the AEEXPORT2SS command.

THL