Chargement et gestion de fichiers Excel, OpenOffice, Json, Csv et Html

Avec Aspose.Cells, il est simple de créer, ouvrir et gérer des fichiers Excel, par exemple, pour récupérer des données ou utiliser un modèle de concepteur pour accélérer le processus de développement.

Création d’un nouveau classeur

L’exemple suivant crée un nouveau classeur à partir de zéro.

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// The path to the documents directory.
	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	try
	{
	// Create a License object
	License license = new License();

	// Set the license of Aspose.Cells to avoid the evaluation limitations
	license.SetLicense(dataDir + "Aspose.Cells.lic");
	}
	catch (Exception ex)
	{
	Console.WriteLine(ex.Message);
	}

	// Instantiate a Workbook object that represents Excel file.
	Workbook wb = new Workbook();

	// When you create a new workbook, a default "Sheet1" is added to the workbook.
	Worksheet sheet = wb.Worksheets[0];

	// Access the "A1" cell in the sheet.
	Cell cell = sheet.Cells["A1"];

	// Input the "Hello World!" text into the "A1" cell
	cell.PutValue("Hello World!");

	// Save the Excel file.
	wb.Save(dataDir + "MyBook_out.xlsx");

view raw Examples-CSharp-Introduction-FirstApplication-1.cs hosted with ❤ by GitHub

Ouverture et enregistrement d’un fichier

Avec Aspose.Cells, il est simple d’ouvrir, enregistrer et gérer des fichiers Excel.

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	// Opening through Path
	// Creating a Workbook object and opening an Excel file using its file path
	Workbook workbook1 = new Workbook(dataDir + "Book1.xlsx");
	//Adding new sheet
	Worksheet sheet = workbook1.Worksheets.Add("MySheet");
	//Setting active aheet
	workbook1.Worksheets.ActiveSheetIndex = 1;
	//Setting values.
	Cells cells = sheet.Cells;
	//Setting text
	cells["A1"].PutValue("Hello!");
	//Setting number
	cells["A2"].PutValue(1000);
	//Setting Date Time
	Cell cell = cells["A3"];

	cell.Value = DateTime.Now;
	Style style = cell.GetStyle();
	style.Number = 14;
	cell.SetStyle(style);
	//Setting formula
	cells["A4"].Formula = "=SUM(A1:A3)";
	//Saving the workbook to disk.
	workbook1.Save(dir + "dest.xlsx");

view raw Examples-CSharp-Open-Save-Workbook-1.cs hosted with ❤ by GitHub

Sujets avancés

Différentes façons d enregistrer des fichiers