Formating column size in Excel with using Export-CSV

Welcome Forums General PowerShell Q&A Formating column size in Excel with using Export-CSV

This topic contains 2 replies, has 3 voices, and was last updated by

1 year, 4 months ago.

  • Author
  • #82231

    Points: 0
    Rank: Member

    I was thinking this would be simple but I cannot find anything on how to set the size of a column with the Export-CSV

    Can I set column size using Export-Csv? There does not seem to be a property for this and this seems like something that you would want to be able to do.

    Thank you

  • #82234

    Points: 1,811
    Helping HandTeam Member
    Rank: Community Hero

    You don't actually set column sizes in a CSV. The CSV format doesn't "retain" sizing – columns aren't fixed-length in CSV.

  • #82244

    Points: 139
    Helping Hand
    Rank: Participant

    you can use the importexcel module to get some of this functionality and export to excel spreadsheets.

The topic ‘Formating column size in Excel with using Export-CSV’ is closed to new replies.

denizli escort samsun escort muğla escort ataşehir escort kuşadası escort