//Start Excel
System.IO.MemoryStream outputStream;
OfficeOpenXml.ExcelPackage package = new OfficeOpenXml.ExcelPackage(fileStream);
package.Load(fileStream);
ExcelWorksheet worksheet = package.get_workbook().get_worksheets().get_Item(1);
OfficeOpenXml.ExcelRange range = worksheet.Cells;
int rowCount, iterator;
rowCount = worksheet.Dimension.End.Row - worksheet.Dimension.Start.Row + 1;
var cells = worksheet.get_Cells();
for(iterator = 2; iterator<=rowCount ; iterator++)
{
var cell = cells.get_Item(iterator,1);
cell.set_Value(DateTimeUtil::applyTimeZoneOffset(uploadDateTime,
DateTimeUtil::getUserPreferredTimeZone()));
}
outputStream = new System.IO.MemoryStream();
fileStream.Position = 0;
fileStream.CopyTo(outputStream);
outputStream.Seek(0, System.IO.SeekOrigin::Begin);
goshoom
