I'm new to this great library but I have some questions about some Worksheet commands.
- How can I make JUST bottom border colored of Navy with width of 0,5 ?
- How to set column width to automatic or how to calculate the largest data of column 3 ?
- Is there any way to paste a row of data by once ?
- Is there a way to set a style to a AREA ? (eg
I know how many rows I have with dtDados.Rows.Count and how many columns ... so... how to apply a style to this area ?
- Can I apply format to a column ? (eg date format to Brasilian format dd/MM/yy ?)
- Apply a style do make a background color like a zebra, even rows silver others lightgray ?
Thanks in advanced.