public void InitializeAsposeLicensing()
{
var stopwatch = MegaExcel.StartStopwatch();
try
{
var excellicense = new Cells.License();
var stream = new MemoryStream(Resources.Resources.Aspose_Total);
excellicense.SetLicense(stream);
this.TraceSource.TraceEvent(TraceEventType.Information, "COMPLETE: Aspose Excel Licensed", stopwatch.Elapsed, TraceStatus.Success);
}
catch (Exception ex)
{
this.TraceSource.TraceException(ex, TraceEventType.Error, "FAILED: Could not get License for Aspose Excel.", stopwatch.Elapsed, TraceStatus.Failed);
}
}
public string SaveExcelFile()
{
var stopwatch = MegaExcel.StartStopwatch();
var excelTemp = @"C:\BACKUPS\TEST_TEMP.xlsx";
var excelFinal = @"C:\BACKUPS\TEST_FINAL.xlsx";
try
{
using (var fileStream = new FileStream(excelTemp, FileMode.OpenOrCreate))
{
var workbook = new Cells.Workbook(fileStream);
var worksheet = workbook.Worksheets[0];
// 'rowNumber' represents the current row number in the spreadsheet, starts at ONE, and is continually incremented.
//var listObjects = workbook.Worksheets[0].ListObjects;
//listObjects.Add(0, 0, 1, 11, true);
//var listObject = workbook.Worksheets[0].ListObjects.ElementAt(0);
//listObject.TableStyleType = TableStyleType.TableStyleMedium2;
//listObject.PutCellValue(1, 0, "A");
//listObject.PutCellValue(2, 1, "B");
//listObject.PutCellValue(3, 2, "C");
// ------------------------------------------------
// Adding a string value to the cell
worksheet.Cells["A1"].PutValue("Hello World");
// Adding a double value to the cell
worksheet.Cells["A2"].PutValue(20.5);
// Adding an integer value to the cell
worksheet.Cells["A3"].PutValue(15);
// Adding a boolean value to the cell
worksheet.Cells["A4"].PutValue(true);
// Adding a date/time value to the cell
worksheet.Cells["A5"].PutValue(DateTime.Now);
// Setting the display format of the date
var style = worksheet.Cells["A5"].GetStyle();
style.Number = 15;
worksheet.Cells["A5"].SetStyle(style);
// ------------------------------------------------
//listObject.ApplyStyleToRange();
//worksheet.AutoFitColumns();
workbook.Save(excelFinal);
this.TraceSource.TraceEvent(TraceEventType.Information, "COMPLETE", stopwatch.Elapsed, TraceStatus.Success);
}
}
catch (Exception ex)
{
this.TraceSource.TraceException(ex, TraceEventType.Error, "FAILED", stopwatch.Elapsed, TraceStatus.Failed);
}
return(excelFinal);
}