Excel, OpenOffice,Json, Csv und Html Dateien laden und verwalten

Neue Arbeitsmappe erstellen

Das folgende Beispiel erstellt eine neue Arbeitsmappe von Grund auf neu.

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

Eine Datei öffnen und speichern

Mit Aspose.Cells ist es einfach, Excel-Dateien zu öffnen, zu speichern und zu verwalten.

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

Erweiterte Themen

Verschiedene Möglichkeiten, Dateien zu speichern