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);
}
