public void read(ref List<string> grpname , ref List<string> path) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; int i = 0; string str,str1; for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++) { str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2; str1 = (string)(range.Cells[rCnt, 2] as Excel.Range).Value2; grpname.Add(str); path.Add(str1); } xlWorkBook.Close(true, null, null); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
public void add(string path, string name, string phoneno,string Email,string type,string gname) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; // MessageBox.Show(_lastRow.ToString()); xlWorkSheet.Cells[range.Rows.Count+1, 1] = name; xlWorkSheet.Cells[range.Rows.Count+1, 2] = phoneno; xlWorkSheet.Cells[range.Rows.Count+1, 3] = Email; xlWorkSheet.Cells[range.Rows.Count+1, 4] = type; xlWorkSheet.Cells[range.Rows.Count+1, 5] = gname; xlWorkBook.Save(); xlWorkBook.Close(); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
public void update(string gname, string path) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; xlWorkSheet.Cells[range.Rows.Count + 1, 1] = gname; xlWorkSheet.Cells[range.Rows.Count + 1, 2] = path; xlWorkBook.Save(); xlWorkBook.Close(); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
public void read(ref List <string> grpname, ref List <string> path) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; int i = 0; string str, str1; for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++) { str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2; str1 = (string)(range.Cells[rCnt, 2] as Excel.Range).Value2; grpname.Add(str); path.Add(str1); } xlWorkBook.Close(true, null, null); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
public void read(string path, ref List<string> name, ref List<string> phone, ref List<string> email,ref List<string> gname) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; string str,str1,str2,str3; for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++) { str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2; str1 = (string)((range.Cells[rCnt, 2] as Excel.Range).Value2).ToString(); str2 = (string)(range.Cells[rCnt, 3] as Excel.Range).Value2; str3 = (string)(range.Cells[rCnt, 5] as Excel.Range).Value2; name.Add(str); phone.Add(str1); email.Add(str2); gname.Add(str3); } xlWorkBook.Close(true, null, null); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
private void addmember_Click(object sender, RoutedEventArgs e) { addmember objaddmem = new addmember(); appendfile objappend = new appendfile(); int res= objaddmem.check(combogroup.Text,combotype.Text); string pt; if (combotype.Text.Equals("Student")) { pt = @"d:\database\Student\" + combogroup.Text + ".xlsx"; } else { pt = @"d:\database\Faculty\" + combogroup.Text + ".xlsx"; } // MessageBox.Show(pt); // MessageBox.Show(res.ToString()); if(res==0) { // MessageBox.Show("file create"); createfile objcreate = new createfile(); objcreate.create(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text); } else { objappend.add(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text); } }
private void addmember_Click(object sender, RoutedEventArgs e) { addmember objaddmem = new addmember(); appendfile objappend = new appendfile(); int res = objaddmem.check(combogroup.Text, combotype.Text); string pt; if (combotype.Text.Equals("Student")) { pt = @"d:\database\Student\" + combogroup.Text + ".xlsx"; } else { pt = @"d:\database\Faculty\" + combogroup.Text + ".xlsx"; } // MessageBox.Show(pt); // MessageBox.Show(res.ToString()); if (res == 0) { // MessageBox.Show("file create"); createfile objcreate = new createfile(); objcreate.create(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text); } else { objappend.add(@pt, nametxt.Text, phonetxt.Text, emailtxt.Text, combotype.Text, combogroup.Text); } }
public void update(string gname,string path) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(@"d:\database\Group.xlsx", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; xlWorkSheet.Cells[range.Rows.Count + 1, 1] = gname; xlWorkSheet.Cells[range.Rows.Count + 1, 2] = path; xlWorkBook.Save(); xlWorkBook.Close(); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
public void read(string path, ref List <string> name, ref List <string> phone, ref List <string> email, ref List <string> gname) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; string str, str1, str2, str3; for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++) { str = (string)(range.Cells[rCnt, 1] as Excel.Range).Value2; str1 = (string)((range.Cells[rCnt, 2] as Excel.Range).Value2).ToString(); str2 = (string)(range.Cells[rCnt, 3] as Excel.Range).Value2; str3 = (string)(range.Cells[rCnt, 5] as Excel.Range).Value2; name.Add(str); phone.Add(str1); email.Add(str2); gname.Add(str3); } xlWorkBook.Close(true, null, null); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }
public void add(string path, string name, string phoneno, string Email, string type, string gname) { createfile objcf = new createfile(); Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Range range; object missing = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(path, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, true, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; // MessageBox.Show(_lastRow.ToString()); xlWorkSheet.Cells[range.Rows.Count + 1, 1] = name; xlWorkSheet.Cells[range.Rows.Count + 1, 2] = phoneno; xlWorkSheet.Cells[range.Rows.Count + 1, 3] = Email; xlWorkSheet.Cells[range.Rows.Count + 1, 4] = type; xlWorkSheet.Cells[range.Rows.Count + 1, 5] = gname; xlWorkBook.Save(); xlWorkBook.Close(); xlApp.Quit(); objcf.releaseObject(xlWorkSheet); objcf.releaseObject(xlWorkBook); objcf.releaseObject(xlApp); }