public void inp(Form1 f) { string str, filename=""; int rCnt; int cCnt; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.Filter = "Excel (*.XLS;*.XLSX)|*.XLS;*.XLSX"; if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { System.IO.StreamReader sr = new System.IO.StreamReader(openFileDialog1.FileName); filename = openFileDialog1.FileName; sr.Close(); f.Toggle(); } // System.Data.DataTable tb = new System.Data.DataTable(); // string filename = openFileDialog1.FileName; Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook Book; Microsoft.Office.Interop.Excel.Worksheet Sheet; Microsoft.Office.Interop.Excel.Range Range; Book = ExcelApp.Workbooks.Open(filename, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); Sheet = (Microsoft.Office.Interop.Excel.Worksheet)Book.Worksheets.get_Item(1); Range = Sheet.UsedRange; for (rCnt = 1; rCnt <= Range.Rows.Count; rCnt++) { f.Tabl.Rows.Add(1); for (cCnt = 1; cCnt <= 13; cCnt++) { str = (string)(Range.Cells[rCnt, cCnt] as Microsoft.Office.Interop.Excel.Range).Text; f.Tabl.Rows[rCnt - 1].Cells[cCnt - 1].Value = str; } } Book.Close(true, null, null); ExcelApp.Quit(); releaseObject(Sheet); releaseObject(Book); releaseObject(ExcelApp); }
/// <summary> /// Метод считывания файла Excel в tab. /// </summary> /// <param name="f">Главная форма программы</param> public void Inp(Form1 f) { string str, filename = string.Empty; int rowCount; int collumnCount; this.tab.Clear(); OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.Filter = "Excel (*.XLS;*.XLSX)|*.XLS;*.XLSX"; if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { System.IO.StreamReader sr = new System.IO.StreamReader(openFileDialog1.FileName); filename = openFileDialog1.FileName; sr.Close(); f.Toggle(); } else { return; } Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook book; Microsoft.Office.Interop.Excel.Worksheet sheet; Microsoft.Office.Interop.Excel.Range range; book = excelApp.Workbooks.Open(filename, 0, true, 5, string.Empty, string.Empty, true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); sheet = (Microsoft.Office.Interop.Excel.Worksheet)book.Worksheets.get_Item(1); range = sheet.UsedRange; for (rowCount = 1; rowCount <= range.Rows.Count; rowCount++) { this.tab.Add(new List<string>()); for (collumnCount = 1; collumnCount <= range.Columns.Count; collumnCount++) { str = (string)(range.Cells[rowCount, collumnCount] as Microsoft.Office.Interop.Excel.Range).Text; this.tab[rowCount - 1].Add(str.Trim()); } } book.Close(true, null, null); excelApp.Quit(); this.ReleaseObject(sheet); this.ReleaseObject(book); this.ReleaseObject(excelApp); int x = 0, y = 0; f.Tabl.RowCount = this.tab.Count; foreach (List<string> i in this.tab) { f.Tabl.ColumnCount = i.Count; foreach (string u in i) { f.Tabl.Rows[x].Cells[y].Value = u; y++; } y = 0; x++; } }
public void TestButton2() { Form1 f = new Form1(); f.Toggle(); Assert.AreEqual(false,f.Spanel); }