/// <summary> /// Ote la protection d'une feuille, sans mot de passe /// </summary> public bool OterProtectionFeuille() { try { _MaFeuille.Unprotect(_M); return(true); } catch (Exception e) { MessageBox.Show(e.Message); return(false); } }
public void WriteData(List <FoodAmount> foodnames, string formname) { int i = 8; worksheet = (Worksheet)excelApp.Worksheets["Calculation Sheet"]; worksheet.Unprotect("cich"); if ((worksheet.Cells[i, "C"] as Range).Value != null) { Range foodNames = worksheet.get_Range(worksheet.Cells[i, "C"], worksheet.Cells[17, "C"]); Range rationAmounts = worksheet.get_Range(worksheet.Cells[i, "F"], worksheet.Cells[17, "F"]); foodNames = null; rationAmounts = null; } if (foodnames.Count > 20) { MessageBox.Show("Sorry! There is a maximum of 20 foods."); } else { worksheet.Cells[54, "D"] = formname; worksheet.Cells[56, "D"] = DateTime.Now; for (int f = 9; f < foodnames.Count - 1; f++) { excelApp.Run("AddRow"); } for (int j = 0; j < foodnames.Count; j++) { worksheet.Cells[i, "C"] = foodnames[j].Food.Name; worksheet.Cells[i, "F"] = foodnames[j].Amount; i++; } } excelApp.Visible = true; }