Exemplo n.º 1
0
 public Table(Sheet sheet, string title, params string[] columnHeaders)
 {
     _cols = new Columns(this);
     _rows = new Rows(this);
     _title = title;
     _fields = new Fields(this);
     _sheet = sheet;
     _cols.Add(columnHeaders);
 }
Exemplo n.º 2
0
 public Table(Sheet sheet, int numberOfColumnsWithNoHeader)
 {
     _sheet = sheet;
     _cols = new Columns(this);
     _rows = new Rows(this);
     _title = "";
     _fields = new Fields(this);
     _cols.Add(numberOfColumnsWithNoHeader);
 }
Exemplo n.º 3
0
 public Sheet Add(Sheet sheet)
 {
     List.Add(sheet);
     return sheet;
 }
Exemplo n.º 4
0
 /*public string[] PrintText{
     get{
         //TODO: This isn't done. I might can be used to shink the width of a report to make it fit on a page.
         int colWidth;
         string rowString = "";
         ArrayList printText = new ArrayList();
         foreach(Sheet sheet in _sheets){
             foreach(Table table in sheet.Tables){
                 colWidth = (93 / table.Columns.Count) - Table.COLUMN_PAD;
                 foreach(Row row in table.Rows){
                     foreach(Field fld in row.Fields){
                         if (fld.Value.Length > colWidth)
                             fldVal = fld.Value.Substring(1, colWidth);
                         else
                             fldVal = fld.Value.PadRight(
                                 //rowString = fld.Value.Substring(1, colWidth) + " ".PadRight(Table.COLUMN_PAD);
                                 //printText.Add(rowString);
                 }
             }
         }
         return (string[])printText.ToArray();
     }
 }*/
 protected Table CreateDefaultTable(string title, params string[] columnHeaders)
 {
     Table table;
     Sheet sheet;
     if (_sheets[0] == null){
         sheet = new Sheet(this,title);
         _sheets.Add(sheet);
         table = new Table(sheet, title, columnHeaders);
         sheet.Add(table);
     }else{
         table = _sheets[0][0];
     }
     return table;
 }
Exemplo n.º 5
0
 public void DeleteDefaultWorksheets(Excel.Workbook wb, Sheet sheet)
 {
     Excel.Sheets excelSheets = wb.Sheets;
     foreach(Excel.Worksheet wsToDel in excelSheets){
         if (wb.Name != sheet.Title){
             wsToDel.Delete();
         }
     }
     Marshal.ReleaseComObject(excelSheets); excelSheets = null;
 }
Exemplo n.º 6
0
 public Sheet CreateSheet(string title)
 {
     Sheet sheet = new Sheet(this, title);
     _sheets.Add(sheet);
     return sheet;
 }
Exemplo n.º 7
0
 public void Table(Sheet sheet)
 {
     _sheet = sheet;
 }