changing a row height in Excel sheet. (C#) RRS feed

  • Question

  • User1228437946 posted

    Hi everyone,

    On my aspx page, I've got a button to export a server-side table to a excel sheet. Each row has one picture and some data. Data looks fine on a excel workbook, but the pictures overlap vertically since each row is spaced as just one line.

    I used a Response to stream out data; Response.ContentType = "application/vnd.ms-excel" (but not an excel class).

    After researching, I found that I can use excelObject.Columns("G:G").ColumnWidth = 14.43 (perhaps the size of picture instead of 14.43). My question is how do I get a reference to my excel sheet when I didn't use Excel object??


    Thanks for your time,

    Wednesday, December 3, 2008 5:34 PM