Selecting Excel Columns RRS feed

  • Question

  • I am an engineer and at my company we use Projectwise to store all of our drawing files.  I am attempting to write a script that can produce a drawing index of files on Projectwise.  I used the get-pwdocumentreportdatatable cmdlt and piped it to new-xlsxworkbook and this worked but the get cmdlt gives me much more information than I need.  I was wondering if their is anyway I can write code to condense the number of columns given in excel (ie. Title, Drawing No., Rev No., etc.) or will I just have to delete the superfluous columns manually?


    Monday, July 2, 2018 3:36 PM

All replies