FAQ C#Consultez toutes les FAQ

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
string filePath = @"C:\Classeur1.xls"; 
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0\";"; 
OleDbConnection connection = new OleDbConnection(connectionString); 
string cmdText = "SELECT * FROM [Feuil1$]"; 
OleDbCommand command = new OleDbCommand(cmdText, connection); 
  
command.Connection.Open(); 
OleDbDataReader reader = command.ExecuteReader(); 
  
if (reader.HasRows) 
{ 
    while (reader.Read()) 
    { 
        Console.WriteLine("{0}\t{1}", reader[0].ToString(), reader[1].ToString()); 
    } 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
string filePath = @"C:\Classeur1.xls"; 
_Application application = new ApplicationClass(); 
_Workbook workbook = application.Workbooks.Open(filePath, 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); 
_Worksheet worksheet = (_Worksheet)workbook.ActiveSheet; 
Range range; 
  
for (int i = 1; i < worksheet.Rows.Count + 1; i++) 
{ 
    // A la première cellule vide, sortir de la boucle : 
    if ((worksheet.Cells[i, 1] == null || ((Range)worksheet.Cells[i, 1]).Value2 == null) && 
        (worksheet.Cells[i, 2] == null || ((Range)worksheet.Cells[i, 2]).Value2 == null)) 
    { 
        break; 
    } 
  
    // Lire les cellules : 
    Console.WriteLine("{0}\t{1}", ((Range)worksheet.Cells[i, 1]).Value2.ToString(), ((Range)worksheet.Cells[i, 2]).Value2.ToString()); 
} 
  
workbook.Close(false, Type.Missing, Type.Missing); 
application.Quit();

1
2
3
4
5
6
7
8
string filePath = @"C:\Classeur1.xls"; 
Workbook workbook = new Workbook(filePath); 
Worksheet worksheet = workbook.Sheets.GetByName("Feuil1"); 
  
for (ushort i = 0; i <= worksheet.Rows.LastRow; i++) 
{ 
    Console.WriteLine("{0}\t{1}", worksheet.Rows[i].Cells[0].Value.ToString(), worksheet.Rows[i].Cells[1].Value.ToString()); 
}

1
2
3
4
using (StreamWriter streamWriter = new StreamWriter(@"C:\Classeur1.csv")) 
{ 
    streamWriter.WriteLine("Valeur dans la cellule A1;Autre valeur dans la cellule A2"); 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
string filePath = @"C:\Classeur1.xls"; 
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0\";"; 
using (OleDbConnection connection = new OleDbConnection(connectionString)) 
{ 
    connection.Open(); 
  
	// Le nom des colonnes se trouve en première ligne de la feuille. 
	// Ici les colonnes concernées s'intitulent COL 1 et COL 2 : 
	string cmdText = "INSERT INTO [Feuil1$] ([COL 1], [COL 2]) VALUES ('Valeur dans la cellule A1', 'Autre valeur dans la cellule A2')"; 
	using (OleDbCommand command = new OleDbCommand(cmdText, connection)) 
	{ 
		command.ExecuteNonQuery(); 
	} 
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
string filePath = @"C:\Classeur1.xls"; 
_Application application = new ApplicationClass(); 
_Workbook workbook = application.Workbooks.Open(filePath, Type.Missing, false, Type.Missing, 
                                                Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
                                                Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
                                                Type.Missing, Type.Missing, Type.Missing); 
_Worksheet worksheet = (_Worksheet)workbook.ActiveSheet; 
  
((Range)worksheet.Cells[1, 1]).Value2 = "Valeur dans la cellule A1"; 
((Range)worksheet.Cells[1, 2]).Value2 = "Autre valeur dans la cellule A2"; 
  
workbook.Save(); 
workbook.Close(false, Type.Missing, Type.Missing); 
application.Quit();

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
string filePath = @"C:\Classeur1.xls"; 
_Application application = new ApplicationClass(); 
application.DisplayAlerts = false; // Ne pas afficher les alertes, telles que boites de dialogues de confirmation. 
_Workbook workbook = application.Workbooks.Open(filePath, Type.Missing, false, Type.Missing, 
                                                Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
                                                Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
                                                Type.Missing, Type.Missing, Type.Missing); 
_Worksheet worksheet = (_Worksheet)workbook.ActiveSheet; 
  
Range maCellule = ((Range)worksheet.Cells[1, 1]); 
maCellule.Borders.Color = XlRgbColor.rgbRed; // Définir la couleur des bordures à rouge 
maCellule.Interior.Color = XlRgbColor.rgbGreen; // Définir la couleur de fond à vert 
  
workbook.Save(); 
workbook.Close(false, Type.Missing, Type.Missing); 
application.Quit();