Some begginers (style) doubts for worksheets.

Jan 13, 2012 at 12:37 PM

Hi,

I'm new to this great library but I have some questions about some Worksheet commands.

  1. How can I make JUST bottom border colored of Navy with width of 0,5 ?
  2. How to set column width to automatic or how to calculate the largest data of column 3 ?
  3. Is there any way to paste a row of data by once  ?
  4. Is there a way to set a style to a AREA ? (eg
    after writer.PasteDataTable(dtDados,"B3");
    I know how many rows I have with dtDados.Rows.Count and how many columns ... so... how to apply a style to this area ?
  5. Can I apply format to a column ? (eg date format to Brasilian format dd/MM/yy ?)
  6. Apply a style do make a background color like a zebra, even rows silver others lightgray ?

 

Thanks in advanced.