Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

format cells after exportng to excel

Status
Not open for further replies.

specialist

Programmer
Sep 7, 2001
50
US
good day-
I am trying to export a report from an asp page to an excel file but I'm having some difficulity formating the cells in xls. I am exporting with the
<% Response.ContentType = "application/vnd.ms-excel"%> method.

There are two tables in this report and each has different width values. for example, the width of the cells in the 1st table is 100 pixels and the width in the 2nd is 50 pixels.

Is there a way to export this report to excel and have a "break" in the excel sheet where each table will hold it's values as defined in the asp page?

thanks for any direction! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top