public void RadExcelFile(string excelFilePath)
{
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
// Open the Workbook:
Microsoft.Office.Interop.Excel.Workbook wb = excelApp.Workbooks.Open(
excelFilePath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// Get the first worksheet.
// (Excel uses base 1 indexing, not base 0.)
Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];
// for (int row = 1; row < ws.UsedRange.Rows.Count; row++)\
// Count is 1048576 instead of 4
for (int row = 1; row < ws.UsedRange.Rows.Count; row++)
{
var studentId = Int64.Parse((ws.Cells[row + 1, 1] as Range).Value.ToString());
var group = Int64.Parse((ws.Cells[row + 1, 6] as Range).Value.ToString());
var cours = Int64.Parse((ws.Cells[row + 1, 5] as Range).Value.ToString());
var semester = Int64.Parse((ws.Cells[row + 1, 7] as Range).Value.ToString());
var subId = Int64.Parse((ws.Cells[row + 1, 10] as Range).Value.ToString());
var assessments = Int64.Parse((ws.Cells[row + 1, 12] as Range).Value.ToString());
// var group = Int64.Parse((ws.Cells[row + 1, 13] as Range).Value.ToString());
// var document = Int64.Parse((ws.Cells[row + 1, 13] as Range).Value.ToString());
// var attempt = Int64.Parse((ws.Cells[row + 1, 12] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
// var semesterCount = Int64.Parse((ws.Cells[row + 1, 13] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var SpecialityID = Int64.Parse((ws.Cells[row + 1, 8] as Range).Value.ToString());
ExcelModel model = new ExcelModel()
{
StudentId = (int)studentId,
FirstName = ((Range)ws.Cells[row + 1, 2]).Value2.ToString(),
LastName = ((Range)ws.Cells[row + 1, 3]).Value2.ToString(),
Patronimic = ((Range)ws.Cells[row + 1, 4]).Value2.ToString(),
Group = (int)group,
Cours = (int)cours,
Semester = (int)semester,
SpecialityID = (int)SpecialityID,
Name_Specialty = ((Range)ws.Cells[row + 1, 9]).Value2.ToString(),
// SpecialityID = ((Range)ws.Cells[row + 1, 8]).Value2.ToString(),
SubId = (int)subId,
SubName = ((Range)ws.Cells[row + 1, 11]).Value2.ToString(),
Assessments = (int)assessments,
// Docum=(byte[])document,
};
items.Add(model);
//excelApp.Workbooks.Close();
}
}
public void RadExcelFile(string excelFilePath)
{
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
// Open the Workbook:
Microsoft.Office.Interop.Excel.Workbook wb = excelApp.Workbooks.Open(
excelFilePath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// Get the first worksheet.
// (Excel uses base 1 indexing, not base 0.)
Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];
for (int row = 1; row < ws.UsedRange.Rows.Count; row++) // Count is 1048576 instead of 4
{
var studentId = Int64.Parse((ws.Cells[row + 1, 1] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var cours = Int64.Parse((ws.Cells[row + 1, 3] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var semester = Int64.Parse((ws.Cells[row + 1, 4] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var subId = Int64.Parse((ws.Cells[row + 1, 6] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var mark = Int64.Parse((ws.Cells[row + 1, 8] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var attempt = Int64.Parse((ws.Cells[row + 1, 9] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
var semesterCount = Int64.Parse((ws.Cells[row + 1, 10] as Microsoft.Office.Interop.Excel.Range).Value.ToString());
ExcelModel model = new ExcelModel()
{
StudentId = (int)studentId,
Fulllname = ((Range)ws.Cells[row + 1, 2]).Value2.ToString(),
Cours = (int)cours,
Semester = (int)semester,
Speciality = ((Range)ws.Cells[row + 1, 5]).Value2.ToString(),
SubId = (int)subId,
SubName = ((Range)ws.Cells[row + 1, 7]).Value2.ToString(),
Mark = (int)mark,
Attempt = (int)attempt,
SemesterCount = (int)semesterCount
};
items.Add(model);
}
}
