public void excelAdatbazisKimento()
{
excel = new Microsoft.Office.Interop.Excel.Application();
wb = (excel.Workbooks.Open(connection()));
ws = (Worksheet)wb.ActiveSheet;
object[,] ob = db.dbFullListForExcel();
int lengthOfList = 0;
try
{
for (int i = 0; i < 16000; i++)
{
if (ob[i, 0].ToString() == "" || ob[i, 0] == null)
{
break;
}
else
{
lengthOfList++;
}
}
}
catch (Exception)
{
}
for (int i = 0; i < lengthOfList; i++)
{
ws.Cells[i + 2, 1] = ob[i, 0];
ws.Cells[i + 2, 2] = ob[i, 30];
ws.Cells[i + 2, 3] = ob[i, 31];
ws.Cells[i + 2, 4] = ob[i, 26];
ws.Cells[i + 2, 5] = ob[i, 32];
ws.Cells[i + 2, 6] = ob[i, 33];
ws.Cells[i + 2, 7] = ob[i, 27];
ws.Cells[i + 2, 8] = ob[i, 25];
ws.Cells[i + 2, 9] = ob[i, 34];
ws.Cells[i + 2, 10] = ob[i, 35];
ws.Cells[i + 2, 11] = ob[i, 36];
ws.Cells[i + 2, 12] = ob[i, 37];
ws.Cells[i + 2, 13] = ob[i, 38];
ws.Cells[i + 2, 14] = ob[i, 39];
ws.Cells[i + 2, 15] = ob[i, 24];
ws.Cells[i + 2, 16] = ob[i, 20];
ws.Cells[i + 2, 17] = ob[i, 22];
ws.Cells[i + 2, 18] = ob[i, 21];
ws.Cells[i + 2, 19] = ob[i, 23];
ws.Cells[i + 2, 20] = ob[i, 28];
ws.Cells[i + 2, 21] = ob[i, 29];
ws.Cells[i + 2, 22] = ob[i, 1];
ws.Cells[i + 2, 23] = ob[i, 2];
ws.Cells[i + 2, 24] = ob[i, 3];
ws.Cells[i + 2, 25] = ob[i, 7];
ws.Cells[i + 2, 26] = ob[i, 9];
ws.Cells[i + 2, 27] = ob[i, 11];
ws.Cells[i + 2, 28] = ob[i, 13];
ws.Cells[i + 2, 29] = ob[i, 15];
ws.Cells[i + 2, 30] = ob[i, 4];
ws.Cells[i + 2, 31] = ob[i, 16];
ws.Cells[i + 2, 32] = ob[i, 8];
ws.Cells[i + 2, 33] = ob[i, 10];
ws.Cells[i + 2, 34] = ob[i, 12];
ws.Cells[i + 2, 35] = ob[i, 14];
ws.Cells[i + 2, 36] = ob[i, 5];
ws.Cells[i + 2, 37] = ob[i, 17];
ws.Cells[i + 2, 38] = ob[i, 6];
}
try
{
ws.SaveAs(path);
}
catch (Exception)
{
throw;
}
wb.Close();
excel.Quit();
}