Loading and managing Excel,OpenOffice,Json, Csv and Html files

With Aspose.Cells, it is simple to create,open and manage Excel files, for example, to retrieve data, or to use a designer template to speed up the development process.

Creating a New Workbook

The following example creates a new workbook from the scratch.

	// 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

Opening and saving a File

With Aspose.Cells, it is simple to open, save and mange Excel files.

	// 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

Advance topics

Different Ways to Save Files