element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • About Us
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Altium CircuitStudio
  • Products
  • Manufacturers
  • Altium CircuitStudio
  • More
  • Cancel
Altium CircuitStudio
Altium CircuitStudio Forum New feature is 1.5 - Can't export BOM's to Excel
  • Blog
  • Forum
  • Documents
  • Events
  • Polls
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Altium CircuitStudio to participate - click to join for free!
Actions
  • Share
  • More
  • Cancel
Forum Thread Details
  • State Verified Answer
  • Locked Locked
  • Replies 25 replies
  • Subscribers 88 subscribers
  • Views 4206 views
  • Users 0 members are here
  • frontpage
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

New feature is 1.5 - Can't export BOM's to Excel

Sparkylabs
Sparkylabs over 7 years ago

i can no longer export BOM's in excel format. If i use the template I used to use in xlsx format CS now cannot work with this. having converted my template to XLT excel cannot handle the output from CS. So new version and MORE bugs.

 

Where do I send my invoice for the time I am wasting on this software? some of us have businesses to run!

  • Cancel

Top Replies

  • voltsandjolts
    voltsandjolts over 7 years ago in reply to Sparkylabs +1
    Look I didn't suggest you re-edit the BOM!
Parents
  • voltsandjolts
    0 voltsandjolts over 7 years ago

    XLSX BOM created through an XLT template works for me in 1.5.1

    Can you share your template?

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
  • Sparkylabs
    0 Sparkylabs over 7 years ago in reply to voltsandjolts

    It even refuses to work with a their own template, the BOM export is a mess. I have tried reinstalling but this has put me back to 1.41 and this too suffers from the problem. I have this now on two computers so it is not machine specific. What data CS attempts to put into an excel file is too corrupt for excel to use so basically altium need to pull their fingers out of their arses and produce a bug fix that will apply to 1.41 because I don't see why I should be paying a maintenance licence for the fixing of basic functionality.

     

    I will have to use csv format that cannot be directly used by excel as it converts wurth electronic electrolytic capacitor part numbers into floating point thus destroying the data. The only way around this is to start a new spreadsheet and import the csv data.

     

    Perhaps it's time microsoft buy out altium. while they generally ruin anything they buy I can't possibly see how you can make CS any worse - ok you could but really this is ridiculous. I have wasted 3 hours on this.

     

    I am not allowed to attach the file format for excel templates. The template was derived from one of theirs and has worked fine in the past.

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
  • voltsandjolts
    0 voltsandjolts over 7 years ago in reply to Sparkylabs

    Hmmm, may there is something in the project which is upsetting the export.

     

    "used by excel as it converts wurth electronic electrolytic capacitor part numbers into floating point thus destroying the data"

     

    Right click on those cells, select Format > "Text"

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
Reply
  • voltsandjolts
    0 voltsandjolts over 7 years ago in reply to Sparkylabs

    Hmmm, may there is something in the project which is upsetting the export.

     

    "used by excel as it converts wurth electronic electrolytic capacitor part numbers into floating point thus destroying the data"

     

    Right click on those cells, select Format > "Text"

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
Children
No Data
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube