| public static CreateExcel ( string path ) : Excel, | ||
| path | string | |
| return | Excel, | |
public void GenerateExcel(List <ExcelData> sheets, string fileName)
{
var helper = new ExcelHelper();
if (sheets.Count == 1)
{
ExcelData sheet = sheets[0];
using (var stream = helper.CreateExcel(sheet.DataRows, sheet.SheetName, sheet.Headers))
{
using (FileStream file = new FileStream(fileName, FileMode.Create, FileAccess.Write))
{
stream.WriteTo(file);
file.Close();
stream.Close();
}
}
}
else
{
using (var stream = helper.CreateExcelWithManySheets(sheets))
{
using (FileStream file = new FileStream(fileName, FileMode.Create, FileAccess.Write))
{
stream.WriteTo(file);
file.Close();
stream.Close();
}
}
}
}
/// <summary>
/// 模板下载
/// </summary>
/// <param name="code"></param>
/// <param name="name"></param>
/// <returns></returns>
public byte[] GetbytesByCode(string code, out string name)
{
var impTb = _impTbRepository.GetAllList(a => a.Code == code).FirstOrDefault();
name = impTb.CnTableName;
var impTbField = impTb.ImpTbField;
var dic = new Dictionary <string, string>();
if (impTbField.Count > 0)
{
foreach (var item in impTbField)
{
dic.Add(item.FieldCode, item.FieldName);
}
}
var sheet = new List <MultiSheet>();
sheet.Add(new MultiSheet {
SheetName = "ss", Data = null, Description = null, TopTitle = null, DicTitle = dic
});
var ss = ExcelHelper.CreateExcel(sheet, "ssss", name);
return(ss.GetBuffer());
}
protected void Page_Load(object sender, EventArgs e)
{
int index = 1;
IEnumerable enumerable = AdminService.UserService.Search().Select(u => new
{
id = index++,
name = u.UserName,
pwd = u.UserPwd,
date = u.AddDate
}).ToList();
var templateFileName = Server.MapPath("~/template.xls");
var excelHelper = new ExcelHelper(3, 0, templateFileName);
var workbook = excelHelper.CreateExcel(enumerable);
var ms = new MemoryStream();
workbook.Write(ms);
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
Response.ContentType = "application/vnd.ms-excel";
string fileName = "会员信息列表.xls";
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(fileName));
Response.BinaryWrite(ms.GetBuffer());
Response.Flush();
Response.End();
}
static void Main(string[] args)
{
List <Po> pos = new List <Po>();
for (int t = 0; t <= 25; t++)
{
for (int j = 1; j <= 5; j++)
{
GNN4PO po1 = new GNN4PO();
po1.CalculateA(t);
pos.Add(new Po {
Column = t + 1, Row = j, Value = po1.a
});
po1 = null;
}
Console.WriteLine(string.Format("i={0}, a1-a5:\r\n{1},{2},{3},{4},{5}", t, pos[5 * t + 0].Value, pos[5 * t + 1].Value, pos[5 * t + 2].Value, pos[5 * t + 3].Value, pos[5 * t + 4].Value));
//GNN4PO po1 = new GNN4PO();
//po1.CalculateA(t);
//GNN4PO po2 = new GNN4PO();
//po2.CalculateA(t);
//GNN4PO po3 = new GNN4PO();
//po3.CalculateA(t);
//GNN4PO po4 = new GNN4PO();
//po4.CalculateA(t);
//GNN4PO po5 = new GNN4PO();
//po5.CalculateA(t);
//Console.WriteLine(string.Format("i={0}, a1-a5:\r\n{1},{2},{3},{4},{5}", t, po1.a, po2.a, po3.a, po4.a, po5.a));
//pos.Add(new Po { Column = t + 1, Row = 1, Value = po1.a });
//pos.Add(new Po { Column = t + 1, Row = 2, Value = po2.a });
//pos.Add(new Po { Column = t + 1, Row = 3, Value = po3.a });
//pos.Add(new Po { Column = t + 1, Row = 4, Value = po4.a });
//pos.Add(new Po { Column = t + 1, Row = 5, Value = po5.a });
}
Console.ReadLine();
ExcelHelper helper = new ExcelHelper();
helper.CreateExcel(pos);
}
public ActionResult ExcelExport(string formvar)
{
ListCondition condition = new ListCondition();
condition.SortField = DataConvert.ToString(Request.Params["sidx"]);
condition.SortType = DataConvert.ToString(Request.Params["sord"]);
condition.PageIndex = DataConvert.ToInt32(Request.Params["page"]);
condition.PageRowNum = DataConvert.ToInt32(Request.Params["rows"]);
condition.ListModelString = formvar;
DataTable dt = Repository.GetReportGridDataTable(condition, false);
QueryEntryViewModel model = JsonHelper.Deserialize <QueryEntryViewModel>(formvar);
StringBuilder sbHtml = ExcelHelper.CreateExcel(dt, EntryGridLayout(model.FormMode));
//string fileName = Server.MapPath("~/Content/uploads/output.xls");
//ExcelHelper.CreateExcel(dt, EntryGridLayout(), "main", "报表", fileName);
//return File(fileName, "application/ms-excel", IdGenerator.GetMaxId("ExcelExport") + ".xls");
byte[] fileContents = Encoding.UTF8.GetBytes(sbHtml.ToString());
return(File(fileContents, "application/ms-excel", IdGenerator.GetMaxId(ExportFileName) + ".xls"));
}
private void button3_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "导出Excel(*.xls)|*.xls";
sfd.FileName = "" + reportobj.REPORT_DISPLAYNAME + "" + DateTime.Now.ToString("yyyyMMddhhmmss");
if (sfd.ShowDialog() == DialogResult.OK)
{
Cursor.Current = Cursors.WaitCursor;
bool res = ExcelHelper.CreateExcel(dgvDiscourseList, sfd.FileName, @"" + (reportobj.REPORT_XLS == "publicXls" ? "" : reportobj.REPORT_XLS) + "");
if (res)
{
MessageBox.Show("导出成功！");
}
else
{
MessageBox.Show("导出失败！");
}
Cursor.Current = Cursors.Default;
}
}
public ActionResult Export(string formvar)
{
try
{
ListCondition condition = new ListCondition();
condition.SortField = DataConvert.ToString(Request.Params["sidx"]);
condition.SortType = DataConvert.ToString(Request.Params["sord"]);
condition.PageIndex = DataConvert.ToInt32(Request.Params["page"]);
condition.PageRowNum = DataConvert.ToInt32(Request.Params["rows"]);
condition.ListModelString = formvar;
UserInfo sysUser = CacheInit.GetUserInfo(HttpContext);
condition.SysUser = sysUser;
DataTable dt = ListRepository.GetAllGridDataTable(condition);
StringBuilder sbHtml = ExcelHelper.CreateExcel(dt, GridLayout());
byte[] fileContents = Encoding.UTF8.GetBytes(sbHtml.ToString());
return(File(fileContents, "application/ms-excel", IdGenerator.GetMaxId(ExportFileName) + ".xls"));
}
catch (Exception ex)
{
AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "MasterController.Export", ControllerName + "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace);
return(Content(ControllerName + "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace, "text/html"));
}
}
public static MvcHtmlString AppReportPrintFor(this HtmlHelper htmlHelper, DataTable dt, AdvanceGridLayout layout)
{
StringBuilder sb = ExcelHelper.CreateExcel(dt, layout);
return(MvcHtmlString.Create(sb.ToString()));
}
public async Task <FileStreamResult> TranslateExcelAsync(IFormCollection collection)
{
var files = Request.Form.Files;
IList <IList <string> > resultList = new List <IList <string> >();
var filePath = @"data/excel/";
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
IList <string> list = new List <string>();
foreach (var formFile in files)
{
if (formFile.Length > 0)
{
string fileFullPath = filePath + DateTime.Now.Millisecond + formFile.FileName;
using (var stream = new FileStream(fileFullPath, FileMode.Create))
{
list.Add(fileFullPath);
await formFile.CopyToAsync(stream);
}
}
}
foreach (var item in list)
{
var excelData = _excelHelper.ReadExcel(item);
//此处只读第一列
IList <string> textList = new List <string>();
foreach (var text in excelData)
{
textList.Add(text[0]); //只读第一列
}
resultList.Add(textList);
List <Task> taskList = new List <Task>();
var task2 = _translator.Translateasync("en", "fr", textList); //翻译成法语
var task1 = _translator.Translateasync("en", "de", textList); //翻译成德文
await Task.WhenAll(task1, task2);
resultList.Add(task2.Result);
resultList.Add(task1.Result);
string savePath = $"data/{DateTime.Now.ToFileTime()}.xlsx";
_excelHelper.CreateExcel(resultList, savePath);
FileStream fileStream = new FileStream(savePath, FileMode.Open);
return(File(fileStream, "text/comma-separated-values", "result" + DateTime.Now.ToFileTime() + ".xlsx"));
}
return(null);
// process uploaded files
// Don't rely on or trust the FileName property without validation.
// return Ok(new { result });
}