1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
//define Excel
Excel.Application XlsApp;
Excel._Workbook Workbook;
Excel._Worksheet WorkSheet;
object missing = System.Reflection.Missing.Value;
//Get a new workbook.
Workbook = (Excel._Workbook)( XlsApp.Workbooks._Open(ExcelDBPath + "\\ExcelSheet.xls" , missing , missing , missing , missing , missing , missing , missing , missing , missing , missing , missing , missing) );
WorkSheet = (Excel._Worksheet)Workbook.ActiveSheet;
//Excel wird sichtbar / false = unsichtbar
XlsApp.Visible= false
//read row by row for example 15000 rows - column A to F:
for ( int i = 2 ; i < 15000 ; i++ )
{
//Auswahl bestimmen
Excel.Range rngID = WorkSheet.get_Range("A" + i.ToString() , missing);
Excel.Range rngDE = WorkSheet.get_Range("B" + i.ToString() , missing);
Excel.Range rngUK = WorkSheet.get_Range("C" + i.ToString() , missing);
Excel.Range rngES = WorkSheet.get_Range("D" + i.ToString() , missing);
Excel.Range rngFR = WorkSheet.get_Range("E" + i.ToString() , missing);
Excel.Range rngPL = WorkSheet.get_Range("F" + i.ToString() , missing);
//Aus Excelrange rngDE den Wert auslesen (hier nur ein kurzer Auszug, macht wenig Sinn aber demonstriert die Funktionsweise):
string excelString = Convert.ToString(rngDE.Value2)
}
//Schliessen
Workbook.Save();
XlsApp.Workbooks.Close();
XlsApp.Quit();
|