public XLSWorker FromSQLToXLS(ADONETWorker adoWorker, string xlsPath) { List <string> tables = adoWorker.GetTablesList(); XLSWorker xls = XLSWorker.Create(xlsPath); for (int i = 0; i < tables.Count; i++) { xls.CreateSheetAfter(tables[i]); string[] columns = adoWorker.GetColumnsNames(tables[i]).ToArray(); xls.WriteLine(columns, 1, 1); List <KeyValuePair <string, object>[]> rows = adoWorker.SelectAll(tables[i]); List <string[]> lines = rows.ConvertAll <string[]>(x => { string[] val = new string[x.Length]; for (int j = 0; j < x.Length; j++) { val[j] = x[j].Value.ToString(); } return(val); }); xls.InsertData(lines, 1, 2); } return(xls); }
public ADONETWorker FromXLSToSQL(XLSWorker adoWorker) { throw new NotImplementedException(); }