Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Andrew
530
Autosize Excel cell using Silverlight Excel library
posted

How can I autosize cells (adjust the cell width to the width of the contents) using the Silverlight Excel library?

Alternatively, if this is not available, how can I convert the displayed width of the XamGrid columns to an Excel cell width?

  • 0
    Offline posted

    I'm using zetexcel.com to Develop high-performance applications to Create, Edit, Convert or Print Excel spreadsheet file formats without requiring Microsoft Excel.

  • 44743
    posted

    Auto-sizing columns is currently not supported. You can submit a feature request for this.

    The Excel columns widths are expressed in 1/256ths of the width of the '0' character in the default font. You can convert between pixels and these units by using the Workbook.PixelsToCharacterWidth256ths method.