private void преподавателиToolStripMenuItem_Click(object sender, EventArgs e)
{
Teachers group = new Teachers();
group.Show();
}
public static List <Teachers> getTeachers(String filePath)
{
Excel.Application excelApp = new Excel.Application();
excelApp.DisplayAlerts = false;
Excel.Workbook teacher_book = excelApp.Workbooks.Open(Filename: filePath, ReadOnly: false);
Excel.Sheets Tables = teacher_book.Sheets;
Worksheet Table = Tables.get_Item("Info") as Worksheet;
// Excel._Worksheet Table = (Worksheet)teacher_book.Worksheets["Info"];
List <Teachers> teacherList = new List <Teachers>();
/*
* foreach (DataRow row in Table.Rows)
* {
* var teacher = new Teachers() {
* firstName = (row["First Name"].ToString())
*
* };
* Console.WriteLine(teacher.firstName);
* teacherList.Add(teacher);
* }
*/
int rows = Table.UsedRange.Row + Table.UsedRange.Rows.Count - 1;
Range range1 = (Range)Table.Cells[1, 2];
Range range2 = (Range)Table.Cells[rows, 7];
Range range = Table.get_Range(range1, range2);
object[,] values = (object[, ])range.Value;
int i;
Range bColomn = Table.Cells[2, 1];
Range cColomn = Table.Cells[2, 2];
Range dColomn = Table.Cells[2, 3];
Range fColomn = Table.Cells[2, 4];
Range eColomn = Table.Cells[2, 5];
Range gColomn = Table.Cells[2, 6];
Range iColomn = Table.Cells[2, 7];
Range jColomn = Table.Cells[2, 8];
Range kColomn = Table.Cells[2, 9];
for (i = 2; i <= rows; i++)
{
var teacher = new Teachers()
{
firstName = (string)bColomn.get_Value(null),
lastName = (string)cColomn.get_Value(null),
emailAddr = (string)dColomn.get_Value(null),
schoolName = (string)fColomn.get_Value(null),
schoolDist = (string)eColomn.get_Value(null),
city = (string)gColomn.get_Value(null),
county = (string)iColomn.get_Value(null),
gradeTaught = (string)jColomn.get_Value(null),
subjectTaught = (string)kColomn.get_Value(null)
};
teacherList.Add(teacher);
}
string data = string.Empty;
Console.WriteLine();
return(teacherList);
}
