这篇文章主要介绍“ASP.NET WebAPI怎么导出CSV”，在日常操作中，相信很多人在ASP.NET WebAPI怎么导出CSV问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”ASP.NET WebAPI怎么导出CSV”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！
计算
安全
数据库
网络和加速
企业服务
window.open("../Ticket/ExportTicket");[HttpGet]
public ActionResult ExportTicket(TicketSearch search)
{
if (search != null)
{
search.CurrentPage = 1;
search.PageSize = 0;
}
string[] lstTitles = new string[] { "编号", "标题"};
int TotalCount = 0;
List<TicketData> lstTicketData = ListTicketEntityToData(search, out TotalCount);
List<string[]> lstData = new List<string[]>();
foreach (TicketData itemData in lstTicketData)
{
string[] data = new string[]
{
itemData.Barcode,
itemData.Label,
itemData.SiteId.ToString(),
Helper.Htmlhelper.GetSiteInfo(itemData.SiteId),
itemData.Owner,
string.IsNullOrEmpty(itemData.CardId) ? "" : itemData.CardId,
itemData.StartDate == null ? "" : itemData.StartDate.Value.ToString("yyyy-MM-dd HH:mm"),
itemData.EndDate == null ? "" : itemData.EndDate.Value.ToString("yyyy-MM-dd HH:mm"),
itemData.IsValid.ToString(),
itemData.IsUsed.ToString(),
itemData.CreateTime.ToString("yyyy-MM-dd HH:mm")
};
lstData.Add(data);
}
string ExportFileName = Helper.ImportExport.ExportData(lstTitles, lstData);
return File(new System.IO.FileStream(ExportFileName, System.IO.FileMode.Open), "application/octet-stream", "Ticket" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv");
}
public static string ExportData(string[] lstTitles, List<string[]> lstData)
{
try
{
lock (RunningExport)
{
string TemplatePath = AppDomain.CurrentDomain.BaseDirectory + "Export";
string FullFileName = AppDomain.CurrentDomain.BaseDirectory + "Export\\template.csv";
if (Directory.Exists(TemplatePath))
{
if (File.Exists(FullFileName))
File.Delete(FullFileName);
}
else
{
Directory.CreateDirectory(TemplatePath);
}
if (lstTitles.Length <= 0)
{
return null;
}
FileStream fs = new FileStream(FullFileName, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
StreamWriter sw = new StreamWriter(fs, Encoding.UTF8);
string data = "";
foreach (string itemTitle in lstTitles)
{
data += itemTitle + ",";
}
sw.WriteLine(data.TrimEnd(','));
foreach (string[] itemData in lstData)
{
data = "";
foreach (string itemChildData in itemData)
{
data += itemChildData + ",";
}
sw.WriteLine(data.TrimEnd(','));
}
sw.Close();
fs.Close();
return FullFileName;
}
}
catch (Exception)
{
return null;
}
}到此，关于“ASP.NET WebAPI怎么导出CSV”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！
亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
