public void Test() { var sql2Excel = new Sql2Excel(); sql2Excel .AddQuery(new Query {Name = "Import", CommandText = "SELECT * FROM Import"}) .AddQuery(new Query {Name = "ImportLines", CommandText = "SELECT * FROM ImportLine"}) //.Execute() .Save(@"c:\temp\queryoutput.xlsx", true); }
public void Test() { var sql2Excel = new Sql2Excel(); sql2Excel .AddQuery(new Query { Name = "Import", CommandText = "SELECT * FROM Import" }) .AddQuery(new Query { Name = "ImportLines", CommandText = "SELECT * FROM ImportLine" }) //.Execute() .Save(@"c:\temp\queryoutput.xlsx", true); }