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

Avec Aspose.Cells, il est simple de créer, d’ouvrir et de gérer des fichiers Excel, par exemple pour récupérer des données, ou d’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

Ouvrir et enregistrer un fichier

Avec Aspose.Cells, il est simple d’ouvrir, d’enregistrer et de 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

Introduction de Aspose.Cells for .NET Différentes façons d'enregistrer des fichiers