Hi People,
Sorry for this snippet not aligned!
Im just pasting the snippet here!
using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
class PRE_ExportSOExcelBatchService_DataExport extends SysOperationServiceBase
{
public void process()
{
Salestable salesTab, salesTab2, salesTabExport;
SalesLine salesLi;
TPO_ExportedSalesId_DataIntegrationForRBTD exportedSalesOrder;
PRE_ExportedSalesIDtable headerTmpStore;
SalesId salesId1 = "";
str salesId2 = "", dataId = "";
MemoryStream memoryStream = new MemoryStream();
int i = 0, _dd = 0, _yy = 0;
str _mthName;
TransDate _today = DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone());
_dd = dayOfMth(_today);
_mthName = mthName(mthOfYr(_today));
_yy = Year(_today);
using (var package = new ExcelPackage(memoryStream))
{
var currentRow = 1;
var currentRowHeader = 1;
Filename fileName = strFmt("ExportedSalesOrderFO%1%2%3.Xlsx",_dd,_mthName,_yy);
//str fullFilePath = System.IO.Path.Combine(filePath, fileName);
var worksheets = package.get_Workbook().get_Worksheets();
var linesWorksheet = worksheets.Add("ExportLines");
var headerWorksheet = worksheets.Add("ExportHeader");
var cells = linesWorksheet.get_Cells();
var headerCells = headerWorksheet.get_Cells();
//mylogic
package.Save();
file::SendFileToUser(memoryStream, fileName);
}
}
}
