public void export() { string file = @"D:\sem2\Result"; SpectacoleDao spectacol = new SpectacoleDao(); DataSet ds = new DataSet(); DataTable spectacoleTable = spectacol.read(); Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("first"); for (int i = 0; i < spectacoleTable.Columns.Count; i++) { worksheet.Cells[0, i] = new Cell(spectacoleTable.Columns[i].ColumnName); // Populate row data for (int j = 0; j < spectacoleTable.Rows.Count; j++) { worksheet.Cells[j + 1, i] = new Cell(spectacoleTable.Rows[j][i]); } } workbook.Worksheets.Add(worksheet); workbook.Save(file); }
public void export() { DataSet ds = new DataSet(); DataTable spectacoleTable = spectacol.read(); ds.Tables.Add(spectacoleTable); System.IO.StringWriter writer = new System.IO.StringWriter(); spectacoleTable.WriteXml(@"D:\sem2\Result.xml"); }
public DataTable readBL() { SpectacoleDao spectacol = new SpectacoleDao(); return(spectacol.read()); }