I'm having trouble inserting file namse and configuration names in an Excel bom template. I am atemting to put the text "SW-File Name(File Name)" in to the name box in the first colum, but excel won't accept it.
Try this. add a column named File If you want you could name it "File Name" but you have to name the cell title "File" so that SW can use it properly because you cannot have spaces. Add a custom property to each model called "File" make it's value $PRP:"SW-File Name" then generate a bom with your new template and you will have a collumn with all the file names.
I know what you meant, and now that I think about it SW may strip that information. I think what I was thinking was that this method works through API. When set in windows it grabs the file extention. You could just add it after the property value.