p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_components thread: how to assign border property to a cell from asp.


Message #1 by "Mayur (Pat) Patel" <pat@m...> on Sun, 4 Mar 2001 21:36:06 -0500 (EST)

hi



i am trying to do the following in asp.



this works in vb but not in asp. maybe you can make me some suggestions.



i am trying to assign an excel cell some border values. i cannot see why

this would work in vb and not in asp. everything else seemed to go find

for my application other then this. i need to format my excel report so i

need this feature. if you have any suggestions pleaset let met know.

 

XL.Cells(i, j).Borders(xlEdgeLeft).Weight = xlThin



it works find in vb but not in asp. 



thanks for your help.



pat





Message #2 by "Tom" <tom@i...> on Tue, 6 Mar 2001 00:14:05
Hi Pat,



It might be that the constant xlThin is available in VB because the 

process of referencing the XL object also loads in the constants.  Since 

you cannot "reference" the XL object in ASP, that would explain why the 

contants aren't avaialable. If this is the case, you will have to find out 

the value of xlThin and code it in, or "include" a file with the xl 

constants.



Here are the values of some commonly used xl constants:

Const xlVAlignCenter = -4108;

Const xlThin = 2;

Const xlEdgeBottom = 9;

Const xlDouble = -4119;

Const xlThick = 4;

Const xl3DColumn = -4100;

Const xlColumns = 2;

Const xlLocationAsObject = 2;



Regards,

-Tom-



> 

> hi

> 

> i am trying to do the following in asp.

> 

> this works in vb but not in asp. maybe you can make me some suggestions.

> 

> i am trying to assign an excel cell some border values. i cannot see why

> this would work in vb and not in asp. everything else seemed to go find

> for my application other then this. i need to format my excel report so i

> need this feature. if you have any suggestions pleaset let met know.

>  

> XL.Cells(i, j).Borders(xlEdgeLeft).Weight = xlThin

> 

> it works find in vb but not in asp. 

> 

> thanks for your help.

> 

> pat

> 

> 


  Return to Index