.net formatting data in excel

D

douglas

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!
 
J

Jacob Skaria

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
 
D

douglas

"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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.net data being formatted in excel 9
vb.net interfacing with office applications 4
excel formatting 2
Can I open a new Excel document in a separate instance of Excel? 1
Quick way to expand all columns to show all data? 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing data in excel 2003 1
Linking data within several Workbooks 1

Top