Has anyone else noticed that writing to cells in a BOM is extremely slow through the API. I am trying to find a way to quickly transfer data from an excel BOM back to the Solidworks BOM, and it seems that using the Table.Text(i,j)=ExcelApp.WorkBook.Sheet(1).Cells(i,j).text takes quite a long time to execute on medium-large size BOMs. Is there a better way to batch write cells than looping through checking a few other cells in that row, and then using the code from above to write the info?
Before anyone asks why I am doing this and not just relying on the BOM generated by SolidWorks, I am trying to implement a better part tracking scheme for seeing when custom parts are ordered, delivered, and where they are stored, so all of that info is entered manually in Excel and then passed back to SolidWorks so that if any changes are made in the future and the BOM is re-exported, it has that information already in it.
SolidworksApi macros