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 4204 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
  • Sparkylabs
    0 Sparkylabs over 7 years ago

    It has happened on two different projects on two different computers. the only commonality is that the BOM is for a project variant.

     

    No I can't change the text format in excel. Even if I do as you suggest it retains the formatting in floating paint notation even though it would no longer be recognised as such the original part number is destroyed, it has to be "imported" in order to not try and be clever.

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

    All the CSV file fields should be in quotes by default so they don't get 'smartly' converted. For example:

     

    "FS1","FUSE LITTLEFUSE POLYFUSE 2200mA 30V THRU-HOLE","1","Farnell","1175-844","",""

     

    So, "1175-844" doesn't get converted to 331.

     

    Did you add extra quotes around the Wurth part numbers? Or maybe there is some escape char in the part number?

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

    Also, I don't use variants so maybe there is an issue there, as you suggested.

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

    Look CS offer output in CSV it should format the file appropriately, I'm not going to re-edit the BOM everytime I export it. Basically the whole BOM export is buggy.

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

    Well I need variants in these projects as they are designed to have a common PCB with options.

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

    If you are creating the BOM in CSV format then the trick is to read it into Excel correctly. Do not just open the file otherwise it does tend to mess up things that look like numbers or dates, it is a complete pain the way it messes up data. Use the import option instead - a good randomly found link on the subject if it helps https://www.hesa.ac.uk/support/user-guides/import-csv .

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

    If you are creating the BOM in CSV format then the trick is to read it into Excel correctly. Do not just open the file otherwise it does tend to mess up things that look like numbers or dates, it is a complete pain the way it messes up data. Use the import option instead - a good randomly found link on the subject if it helps https://www.hesa.ac.uk/support/user-guides/import-csv .

    • 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