You should be able to insert the excel file directly by copying the cell and pasting into drawing. This will create the excel table ion the drawing which can be edited by double clicking.
Thanks Deepak, it seems I need to use "control v" to get the file into the drawing. I was right clicking and seeing no sign of a paste option I assumed it was not possible! reading your fast response I realised I should try another method to paste.
I have found that when saving a drawing (such as a harness) that has an excel bom inserted on the face of the drawing, it disappears when I check it into PDM. or at least the preview shows it but upon re-opening from the vault, it is no longer there. any thoughts on what other options I could use to avoid the rework of it all? Of course I am not using the latest electrical package..... just faking it to get by.
I am trying to paste a fairly large excel spreadsheet into my drawing but I am finding that it is not showing all the copied cells. If I try to expand the window in the drawing, it simply changes the scale of the data rather than expanding the field.
The image below shows the data I selected to copy from excel
The image below shows the result of the paste into Solidworks.
The result after trying to expand the window. I double clicked in the excel data to activate it and then re-sized the window.