Загрузка и управление файлами Excel,OpenOffice,Json, Csv и Html

Создание новой книги

В следующем примере создается новая книга с нуля.

// 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");

Открытие и сохранение файла

С помощью Aspose.Cells просто открывайте, сохраняйте и управляйте файлами 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");

Продвинутые темы