Scusate se ci riprovo.
Vorrei sapere come fare ad aprire in visual studio 2010 o 2022 file excel e poi operare su questo file modificando i valori delle singole celle e infine salvare le modifiche. A disposizione per chiarimenti.
Grazie

To open an Excel file in Visual Studio 2010 or 2022, you can use the Microsoft.Office.Interop.Excel namespace. Here are the steps to do so:

In Visual Studio, create a new project and add a reference to the Microsoft.Office.Interop.Excel assembly.
Import the Microsoft.Office.Interop.Excel namespace into your code file.
Use the Workbook object to open the Excel file and access the worksheet.
Use the Worksheet.Cells property to access individual cells and modify their values.
Save the changes using the Workbook.Save method.
Here's some sample code to get you started:

csharp
Copy
using Microsoft.Office.Interop.Excel;

// Open the Excel file
Application excelApp = new Application();
Workbook workbook = excelApp.Workbooks.Open(@"C:\path\to\your\file.xlsx");

// Get the first worksheet
Worksheet worksheet = workbook.Worksheets[1];

// Modify the value of cell A1
worksheet.Cells[1, 1].Value = "New Value";

// Save the changes
workbook.Save();

// Close the workbook and release resources
workbook.Close();
excelApp.Quit();
Note that this code assumes that you have Excel installed on your computer. If you don't have Excel installed, you can use a third-party library like EPPlus to work with Excel files in C#.

Hope it helps you! https://fun-games.io

---

Modificato da Mumphi il 06 settembre 2023 05:07 -