public static DataSet getData()
{
ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
DataSet ds = egv.getValuesFromExcel();
return(ds);
}
private void Form1_Load(object sender, EventArgs e)
{
ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
Cg1.clsDb cd = new Cg1.clsDb();
string textout = "";
DataSet ds = egv.getValuesFromExcel();
if (ds == null)
{
return;
}
foreach (DataTable dt in ds.Tables)
{
textout = textout + "\n" + (new clsDb()).gencreate(dt);
}
Clipboard.SetText(textout);
}
public override bool Execute()
{
ExcelExtension.GetValues egv = new ExcelExtension.GetValues();
//Cg1.clsDb cd = new Cg1.clsDb();
string textout = "";
DataSet ds = egv.getValuesFromExcel();
if (ds == null)
{
return(false);
}
foreach (DataTable dt in ds.Tables)
{
textout = textout + "\n" + (new clsDb()).gencreate(dt);
}
Clipboard.SetText(textout);
return(false);
}