Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting to Excel, Then Formatting Columns/Cells
Hello,
I am trying to export a record set from my ASP page to an excel spreadsheet. I am able to do this and i have been successful in making minor formatting changes to spreadsheet but I need to give certain cells .Text Wrapping. I have searched all over for the right sequence of code. objSpreadsheet.Columns(iCol).ColumnWidth = 300 works for column widths but objSpreadsheet.Columns(iCol).TextWrap = True does not work. I have tried using the Select method, selecting the columns, then Using With Selection ....TextWrap, but to no avail. Can anyone help me out with this? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting to Excel, Then Formatting Columns/Cells
check out http://www.greggriffiths.org/webdev/both/excel/ which has a
tutorial on this as well as some links to sites of interest. Matt wrote: Hello, I am trying to export a record set from my ASP page to an excel spreadsheet. I am able to do this and i have been successful in making minor formatting changes to spreadsheet but I need to give certain cells .Text Wrapping. I have searched all over for the right sequence of code. objSpreadsheet.Columns(iCol).ColumnWidth = 300 works for column widths but objSpreadsheet.Columns(iCol).TextWrap = True does not work. I have tried using the Select method, selecting the columns, then Using With Selection ....TextWrap, but to no avail. Can anyone help me out with this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting conditional formatting rules | Excel Discussion (Misc queries) | |||
When exporting a report from Access to Excel columns misaligned | Excel Worksheet Functions | |||
Selecting & Formatting Columns w/ Merged Cells | New Users to Excel | |||
Exporting From Quickbooks-not formatting numbers | Excel Discussion (Misc queries) | |||
Formatting Cells/Columns in Excel 97 | Excel Programming |