Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Formating Spreadsheet

Author  Topic 

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2006-04-12 : 13:31:26
Hey all - SQL 2000

Is there a way to format a spreadsheet on a DTS, after it has been created ?
I have a ActiveX that copies a .xls from a template, I have row 1 and 2 formated - row 2 hided -, so I can have headers different from the data/body.
The report I'm trying to format is summary that has a total on the bottom, I wish I could format the 3 last rows with data (Total and 2 Lines of Percentage).

PS: Did this change in SQL 2005 ?

Any ideas ?

---

Thanks!
Igor.
   

- Advertisement -