6 Replies Latest reply on Nov 14, 2017 12:02 PM by Amen Allah Jlili

    Export BOM & Preserve Formatting

    Swme Eng

      Hello all, is there an easy way to export a BOM from an assembly and maintain the formatting of the text?

       

      I'm basing my code on this example:

       

      [API] Manipulation of BOM and Excel

       

      When I call this line: bExcelResult = swTableAnno.SaveAsText(xlSaveName, vbTab) it throws an error in excel upon opening that says the extensions doesn't match the format, if I click yes to proceed,  I loose all of the formatting from the SW BOM.

       

      I want to avoid re-formatting programatically if at all possible, and my ultimate goal is to save as a .xlsx file.