16780 views|26 replies

13

Posts

0

Resources
The OP
 

Altium Designer 13 prompts filed to open Excel template when exporting the BOM table! [Copy link]

 
Recently, this situation occurred when exporting the BOM table. The specific situation is as follows: 1. Operating system Win7; 2. Using Altium Designer 13; 3. Office version is 2013; 4. You can use the built-in template for output, but the output content is garbled or the table format is wrong; 5. When using a self-made template for output, it prompts Filed to open Excel template (on a colleague's computer, the same template can be exported normally); The solutions currently taken are all ineffective: 1. Reinstall AD13, no effect; 2. Reinstall Office 2013, no effect; 3. Change Office version, 2003, 2007, 2010, 2016, all are enterprise editions, no effect; 4. Run AD13 and Excel 2013 in compatibility mode at the same time, no effect; 5. Run in administrator mode, no effect; I have been struggling for several days, now I hope netizens can provide an effective solution, because I use the company computer, try not to reinstall the system, thank you! The attached picture is a screenshot of the problem.



This post is from PCB Design

Latest reply

I encountered the same problem as the original poster these two days. I used AD17 and tried to reinstall AD, office and WPS, but it still didn't work. Finally, I remembered that AD cracking uses the licenses included in the package, which contains many alf files. I tried to import another alf and delete the original alf, and the problem was solved. Personal experience, for future reference only  Details Published on 2022-11-17 10:26
 

13

Posts

0

Resources
2
 
Is there any big guy who can help me
This post is from PCB Design
 
 

13

Posts

0

Resources
3
 
The image is gone, please re-upload it.

错误截图.jpg (25.82 KB, downloads: 0)

错误截图

错误截图
This post is from PCB Design
 
 
 

2w

Posts

341

Resources
4
 
Unable to open Excel template Check Excel template
This post is from PCB Design
 
 
 

2w

Posts

341

Resources
5
 

This post is from PCB Design
 
 
 

13

Posts

0

Resources
6
 
Brother, thank you very much for your help. I have tried all these methods. The file format and template were not selected correctly, but this problem occurred.
This post is from PCB Design

Comments

Take a screenshot. There is no truth without a picture. It is so difficult that there is no solution. The software has a grudge against you.  Details Published on 2017-12-20 10:09
 
 
 

2w

Posts

341

Resources
7
 
Please call me Mr. Jian. Posted on 2017-12-20 09:19 Brother, thank you for your help. I have tried all these methods. The file format and template are not wrong. This is the problem.
Take a screenshot. There is no picture and no truth. It is so difficult that there is no solution. The software has a grudge against you
This post is from PCB Design
 
 
 

13

Posts

0

Resources
8
 
qwqwqw2088 posted on 2017-12-20 10:09 Here is a large screenshot. There is no truth without a picture. It is so difficult that there is no solution. The software has a grudge against you.
This is the picture. The Excel template can be used normally on other people’s computers. I have also re-made the Excel template, but it still doesn’t work.

错误截图.jpg (69.71 KB, downloads: 0)

错误截图

错误截图
This post is from PCB Design

Comments

1. Is the template file BOM Ljldv0.4.XLT a self-made template? Is this file format in a normal file? 2. Even if there is this template, the alarm indicates that the template file may be corrupted or in an unsupported format.  Details Published on 2017-12-20 14:43
 
 
 

2w

Posts

341

Resources
9
 
Please call me Mr. Jian. Posted on 2017-12-20 13:38 This is the picture. The Excel template can be used normally on other people's computers. I have also remade the Excel template, but it still doesn't work.
1. Is the template file BOM Ljldv0.4.XLT template a self-made template by the OP? Is this file format in a normal file? 2. Even if there is this template, the alarm indicates that the template file may be corrupted or in an unsupported format (The template file may be corrupted or in unsupported format)
This post is from PCB Design
 
 
 

2w

Posts

341

Resources
10
 
Check the template installation path of AD software, which is under Users and Public. The place under Templates in the figure below should be consistent with the menu in the second figure below AD software selection --- Report ---- Bill of Materials.... Check the file in the red box under the template drop-down to be consistent with the file above

This post is from PCB Design

Comments

My template path is placed in a folder I created on drive D. Could this be the cause of the problem?  Details Published on 2017-12-20 15:06
 
 
 

13

Posts

0

Resources
11
 
qwqwqw2088 posted on 2017-12-20 14:51 Check that the template installation path of the AD software is under Users under Public, as shown in the following figure under Templates. This place should be under the menu in the second figure below...
The template is placed in the template directory of Altium Designer 13. This template can export the bill of materials normally on other people's computers, and the possibility of template damage has been ruled out.

模板截图.png (50.34 KB, downloads: 0)

模板截图.png
This post is from PCB Design

Comments

Don't select BOM Ljldv0.4.XLT first, see if it works properly  Details Published on 2017-12-20 15:08
 
 
 

13

Posts

0

Resources
12
 
qwqwqw2088 posted on 2017-12-20 14:51 Check that the template installation path of the AD software is under Users under Public, and under Templates as shown in the figure below. This place should be under the menu in the second figure below...
My template path is placed in a folder I created on drive D. Could this be the cause of the problem?

模板路径.png (43.97 KB, downloads: 0)

模板路径.png
This post is from PCB Design
 
 
 

2w

Posts

341

Resources
13
 
Please call me Mr. Jian. Posted on 2017-12-20 15:01 The template is placed in the template directory of Altium Designer 13. This template can export the bill of materials normally on other people's computers. The template damage has been ruled out...
Do not select BOM Ljldv0.4.XLT first, and see if it is normal.
This post is from PCB Design

Comments

No, there is no error message when exporting, but an error message appears when opening the exported table.  Details Published on 2017-12-20 15:14
 
 
 

13

Posts

0

Resources
14
 
qwqwqw2088 posted on 2017-12-20 15:08 Do not select BOM Ljldv0.4.XLT first, see if it is normal
No, there is no error message when exporting, but an error message appears when opening the exported table

错误提示.png (35.05 KB, downloads: 0)

错误提示.png
This post is from PCB Design

Comments

No matter how I try, it just won't work with you.  Details Published on 2017-12-20 15:15
 
 
 

2w

Posts

341

Resources
15
 
This post was last edited by qwqwqw2088 on 2017-12-20 15:18
Please call me Mr. Jian. Posted on 2017-12-20 15:14 No, there was no error message when exporting, but an error message appeared when opening the exported table
No matter what I did, it just didn't work for you This doesn't seem to be related to the system, or the Excel template Or check the template file directory and compare it with your colleague's file directory

This post is from PCB Design

Comments

Dear moderator, please stop laughing at me. I have been struggling for many days and still cannot export the component list. I have to ask others for help, which is really troublesome.  Details Published on 2017-12-20 15:18
 
 
 

13

Posts

0

Resources
16
 
qwqwqw2088 posted on 2017-12-20 15:15 No matter how I do it, it just doesn't work here
Dear moderator, please stop laughing at me I have been struggling for many days and I can't export the component list. I have to ask others for help. It's really troublesome.
This post is from PCB Design

Comments

Be more serious, is it harder than designing circuits and drawing diagrams?  Details Published on 2017-12-20 15:32
 
 
 

2w

Posts

341

Resources
17
 
Please call me Mr. Jian. Posted on 2017-12-20 15:18 Dear moderator, please stop laughing at me. I have been struggling for many days. I can't export the component list and have to find someone else. It's really troublesome.
Be more serious. Is it harder than designing circuits and drawing diagrams?
This post is from PCB Design

Comments

This is not the case  Details Published on 2017-12-20 15:44
 
 
 

13

Posts

0

Resources
18
 
qwqwqw2088 posted on 2017-12-20 15:32 Be more serious, is it harder than designing circuits and drawing diagrams?
This is not the case: puzzle:
This post is from PCB Design
 
 
 

1

Posts

2

Resources
19
 
plz, is the problem solved?
This post is from PCB Design

Comments

No, I can't find the reason. I guess it has something to do with the system.  Details Published on 2018-2-26 13:33
 
 
 

13

Posts

0

Resources
20
 
quyafeng2011 posted on 2018-2-1 16:43 lz, has the problem been solved?
No, I can't find the reason. I guess it has something to do with the system.
This post is from PCB Design
 
 
 

Just looking around
Find a datasheet?

EEWorld Datasheet Technical Support

Copyright © 2005-2024 EEWORLD.com.cn, Inc. All rights reserved 京B2-20211791 京ICP备10001474号-1 电信业务审批[2006]字第258号函 京公网安备 11010802033920号
快速回复 返回顶部 Return list