.net formatting data in excel
 

I am writing a Visual Basic.Net 2005 desktop application that exports data to
individual excel 2003 spreadsheets in separate workbooks. (The data is
written to separate workbooks since the workbooks are emailed to different
customers.)

I am exporting all the data I want to the spreadsheets now. However, I
would like to know how to do any of the following:
1. Put the column headers on to the top of each data column.
2. How to put report headers on the first 3 rows of each spreadsheet,
3. How to set the wraparound property one column in particular. I have one
column that is varchar(500) and I want this column to wraparound.

Thanks!

.net formatting data in excel
 

Page header information if not populated in cells will not be displayed
unless you print/print preview.

ActiveSheet.PageSetup.LeftHeader = "Page &P"

..CenterHeader
..RightHeader
..LeftFooter
..CenterFooter
..RightFooter


If this post helps click Yes
---------------
Jacob Skaria


"douglas" wrote:

I am writing a Visual Basic.Net 2005 desktop application that exports data to
individual excel 2003 spreadsheets in separate workbooks. (The data is
written to separate workbooks since the workbooks are emailed to different
customers.)

I am exporting all the data I want to the spreadsheets now. However, I
would like to know how to do any of the following:
1. Put the column headers on to the top of each data column.
2. How to put report headers on the first 3 rows of each spreadsheet,
3. How to set the wraparound property one column in particular. I have one
column that is varchar(500) and I want this column to wraparound.

Thanks!

.net formatting data in excel
 

"Jacob Skaria":

1. How can you make a user do a print/print preview to see the column
headings? Can this be contolled with vb.net?

"Jacob Skaria" wrote:

Page header information if not populated in cells will not be displayed
unless you print/print preview.

ActiveSheet.PageSetup.LeftHeader = "Page &P"

.CenterHeader
.RightHeader
.LeftFooter
.CenterFooter
.RightFooter


If this post helps click Yes
---------------
Jacob Skaria


"douglas" wrote:

I am writing a Visual Basic.Net 2005 desktop application that exports data to
individual excel 2003 spreadsheets in separate workbooks. (The data is
written to separate workbooks since the workbooks are emailed to different
customers.)

I am exporting all the data I want to the spreadsheets now. However, I
would like to know how to do any of the following:
1. Put the column headers on to the top of each data column.
2. How to put report headers on the first 3 rows of each spreadsheet,
3. How to set the wraparound property one column in particular. I have one
column that is varchar(500) and I want this column to wraparound.

Thanks!