internal static void LoadEmpresa(ExcelWorksheet ws, Orb OrbEffect) { var start = ws.Dimension.Start; var end = ws.Dimension.End; for (int row = start.Row + 1; row <= end.Row; row++) { string UK = ws.Cells[row, 1].Text; string CNPJ = ws.Cells[row, 2].Text; string RazaoSocial = ws.Cells[row, 3].Text; string NomeFantasia = ws.Cells[row, 4].Text; string URLSite = ws.Cells[row, 5].Text; string URLAD = ws.Cells[row, 6].Text; string URLWS = ws.Cells[row, 7].Text; string UsuarioInclusao = ws.Cells[row, 8].Text; OrbEffect.CadastrarEmpresa(new GISModel.Entidades.Empresa() { UniqueKey = Guid.Parse(UK), CNPJ = CNPJ, RazaoSocial = RazaoSocial, NomeFantasia = NomeFantasia, URL_Site = URLSite, URL_AD = URLAD, URL_WS = URLWS, UsuarioInclusao = UsuarioInclusao }); } }