Excel Cell Formatting Using ASP
Posted on 2003-03-04
I need to retrieve data from a database and write such data to an excel file.
How can I set a cell's bottom border thicker in an excel file using ASP?
I know that in VB we can set it by using:
However, it can't work in ASP, "Runtime error occurs".
How can I set a cell in my custom format, e.g. "_(* #,##0_);_(* (#,##0);_(* ""??_);_(@_)", using ASP?
If the item price is 0, I want to set it to blank.
If the total price is 0, I want to set it to "-".
Anyone can help?