public FileResult DownloadSalesForceTemplate()
{
SingelSheetExcelScaffold <SalesForce> scaffod = new SingelSheetExcelScaffold <SalesForce>("SalesForce");
var memoryStream = new MemoryStream();
scaffod.GetWorkBook().Write(memoryStream);
memoryStream.Seek(0, SeekOrigin.Begin);
string s = MimeMapping.GetMimeMapping(".xls");
return(File(memoryStream, s, "SalesForce.xls"));
}
public FileResult DownloadOracleCost()
{
SingelSheetExcelScaffold <OracleCost> scaffod = new SingelSheetExcelScaffold <OracleCost>("OracleCost");
var memoryStream = new MemoryStream();
scaffod.GetWorkBook().Write(memoryStream);
memoryStream.Seek(0, SeekOrigin.Begin);
string s = MimeMapping.GetMimeMapping(".xls");
return(File(memoryStream, s, "OracleCost.xls"));
}
public FileResult DownloadExchangeRateTemplate()
{
SingelSheetExcelScaffold <FlatExchangeRate> scaffod = new SingelSheetExcelScaffold <FlatExchangeRate>("ExchageRate");
string yearmonth = DateTime.Now.ToString("yyyy/MM");
int rowIdex = 1;
foreach (var cur in Currency.GetCurrencys(true))
{
scaffod.SetCellContentByColumnName(rowIdex, "Currency", cur);
scaffod.SetCellContentByColumnName(rowIdex, "YearMonthDate", yearmonth);
rowIdex++;
}
var memoryStream = new MemoryStream();
scaffod.GetWorkBook().Write(memoryStream);
memoryStream.Seek(0, SeekOrigin.Begin);
string s = MimeMapping.GetMimeMapping(".xls");
return(File(memoryStream, s, "ExchangeRate.xls"));
}