public void sbrCreaExcel(DataTable dtb, string vNomHoja)
{
frmInformacion.vTexto = "Creando Hoja Excel";
Form frm = new frmInformacion();
frm.Show();
Application.DoEvents();
DataTable dtEx = dtb.DefaultView.ToTable();
cOffice oOffice = new cOffice();
oOffice.AbreExcel(false);
Application.DoEvents();
oOffice.Visible = false;
Application.DoEvents();
oOffice.CargaExcel(dtEx, 1);
Application.DoEvents();
if (vNomHoja != "")
{
oOffice.NombreHoja(vNomHoja);
}
oOffice.Visible = true;
Application.DoEvents();
oOffice.LimpiaExcel();
Application.DoEvents();
frm.Close();
Application.DoEvents();
}
public void sbrImportarExcel()
{
FD1.Filter = "Ficheros xls|*.xls|Todos|*.*";
if (FD1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string vFich = FD1.FileName;
cOffice oOffice = new cOffice();
DataTable dt = oOffice.ImportExcelXLS(vFich, true, "ListaMovimientos$");
grMovi.DataSource = null;
grMovi.DataSource = dt.DefaultView;
}
}
