Last post Dec 08, 2008 02:12 AM by Nai-Dong Jin - MSFT
Dec 03, 2008 05:34 PM|ansdhr|LINK
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 =
(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,
Dec 08, 2008 02:12 AM|Nai-Dong Jin - MSFT|LINK
From your description, it seems that what you want can be achieved by Excel.Application model. You can get the excel instance, and add or modify the settings of
the workbooks in that excel file.
For more information, you can see:
For more information on Excel.Application model, see: