/// <summary> /// 输出纯文本到客户端 /// </summary> /// <param name="Response"></param> /// <param name="text"></param> public static void WriteText(this HttpResponseBase Response, string text) { Response.ContentType = "text/plain"; Response.ClearContent(); Response.BinaryWrite(Encoding.UTF8.GetBytes(text)); Response.Flush(); }
/// <summary> /// 输出Jsonp文本到客户端 /// </summary> /// <param name="Response"></param> /// <param name="callBack">客户端的js回调方法</param> /// <param name="json">json参数</param> public static void WriteJsonp(this HttpResponseBase Response, string callBack, IJson json) { Response.ContentType = "application/x-javascript"; Response.ClearContent(); Response.BinaryWrite(Encoding.UTF8.GetBytes(string.Format("{0}({1});", callBack, json.ToString()))); Response.Flush(); }
/// <summary> /// 输出Json文本到客户端 /// </summary> /// <param name="Response"></param> /// <param name="json"></param> public static void WriteJson(this HttpResponseBase Response, IJson json) { Response.ContentType = "application/json"; Response.ClearContent(); Response.BinaryWrite(Encoding.UTF8.GetBytes(json.ToString())); Response.Flush(); }
/// <summary> /// Copies the full binary contents of the given blob to the given HTTP response. /// </summary> private static void CopyContents(CloudBlob blob, HttpResponseBase response, long offset = 0) { blob.FetchAttributes(); response.BufferOutput = false; response.AddHeader("Content-Length", blob.Attributes.Properties.Length.ToString()); response.Flush(); using (var reader = blob.OpenRead()) { reader.Seek(offset, System.IO.SeekOrigin.Begin); byte[] buffer = new byte[1024 * 4]; // 4KB buffer while (reader.CanRead) { int numBytes = reader.Read(buffer, 0, buffer.Length); if (numBytes <= 0) break; response.BinaryWrite(buffer); response.Flush(); } } }
public static ActionResult GetFile(HttpResponseBase Response, HttpRequestBase Request, HttpServerUtilityBase Server, string filePath, string fileName, string contentType, string userFileName) { byte[] value; using (FileStream stream = System.IO.File.Open(filePath, FileMode.Open)) { value = new byte[stream.Length]; stream.Read(value, 0, (int)stream.Length); } //const string userFileName = "MissionOrder.pdf"; //const string contentType = "application/pdf"; Response.Clear(); if (Request.Browser.Browser == "IE") { string attachment = String.Format("attachment; filename=\"{0}\"", Server.UrlPathEncode(userFileName)); Response.AddHeader("Content-Disposition", attachment); } else Response.AddHeader("Content-Disposition", "attachment; filename=\"" + userFileName + "\""); Response.ContentType = contentType; Response.Charset = "utf-8"; Response.HeaderEncoding = Encoding.UTF8; Response.ContentEncoding = Encoding.UTF8; Response.BinaryWrite(value); Response.End(); return null; }
protected override void WriteFile(HttpResponseBase response) { response.AddHeader("Content-Disposition", string.Format("attachment; filename=\"{0}\"", FileDownloadName)); byte[] fileContents = Convert.FromBase64String(_base64); response.BinaryWrite(fileContents); response.End(); }
private void CreateFileResponse(HttpResponseBase response, AttachmentDO attachment) { var fileData = attachment.Bytes; response.ContentType = "application/octet-stream"; response.AddHeader("Content-Disposition", "filename=\"" + attachment.OriginalName + "\""); response.AddHeader("Content-Length", fileData.LongLength.ToString()); response.AddHeader("Content-Type", attachment.Type + "; name=\"" + attachment.OriginalName + "\";"); //Write the data response.BinaryWrite(fileData); }
private void SetHttpResponse(HttpResponseBase httpResponse, string fileNameWithoutExtension, ExcelPackage package) { httpResponse.ClearContent(); httpResponse.Buffer = true; //Write it back to the client httpResponse.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; httpResponse.AddHeader("content-disposition", string.Format("attachment; filename={0}.xlsx", fileNameWithoutExtension)); httpResponse.BinaryWrite(package.GetAsByteArray()); httpResponse.Flush(); httpResponse.End(); }
protected override void WriteFile(HttpResponseBase response) { // string filePath = HostingEnvironment.MapPath("~/Videos/" + FileName); FileInfo file = new FileInfo(filePath); if (file.Exists) { FileStream stream = file.OpenRead(); byte[] videostream = new byte[stream.Length]; stream.Read(videostream, 0, (int)file.Length); response.BinaryWrite(videostream); } else { throw new ArgumentException("檔案不存在。", "fileName"); } }
public bool SendContent(string url, HttpResponseBase response) { if (FileStore.SendContent(url, response)) return true; var key = uriBuilder.ParseKey(url); var id = Hasher.Hash(uriBuilder.ParseFileName(url)); var file = repository.SingleOrDefault<RequestReduceFile>(id); if(file != null) { response.BinaryWrite(file.Content); try { FileStore.Save(file.Content, url, null); } catch(Exception ex) { var message = string.Format("could not save {0}", url); var wrappedException = new ApplicationException(message, ex); RRTracer.Trace(message); RRTracer.Trace(ex.ToString()); if (Registry.CaptureErrorAction != null) Registry.CaptureErrorAction(wrappedException); } RRTracer.Trace("{0} transmitted from db.", url); if (file.IsExpired) reductionRepository.RemoveReduction(key); return true; } RRTracer.Trace("{0} not found on file or db.", url); reductionRepository.RemoveReduction(key); return false; }
protected override void WriteFile(HttpResponseBase response) { response.BinaryWrite(CreateCalendarBytes()); }
public void WriteResponse(HttpResponseBase response) { response.ThrowIfNull("response"); response.StatusCode = _statusCode.StatusCode; response.SubStatusCode = _statusCode.SubStatusCode; response.ContentType = ContentType; response.Charset = Charset; response.ContentEncoding = ContentEncoding; foreach (Header header in Headers) { response.Headers.Add(header.Field, header.Value); } response.HeaderEncoding = HeaderEncoding; foreach (Cookie cookie in Cookies) { response.Cookies.Add(cookie.GetHttpCookie()); } _cachePolicy.Apply(response.Cache); response.BinaryWrite(_content); }
private void ReceivePack(ControllerContext context, Stream input, HttpResponseBase response) { var capabilities = new HashSet<string>(Capabilities.Split(' ')); var requests = ProtocolUtils.ParseUpdateRequests(input, capabilities).ToList(); if (requests.Count == 0) { response.BinaryWrite(ProtocolUtils.EndMarker); return; } var reportStatus = capabilities.Contains("report-status"); var useSideBand = capabilities.Contains("side-band-64k"); var reportBand = useSideBand ? ProtocolUtils.PrimaryBand : (int?)null; var failureBand = reportStatus ? reportBand : ProtocolUtils.ErrorBand; try { ProtocolUtils.UpdateRequest source; ProtocolUtils.UpdateRequest destination; var errors = ReadRequests(requests, out source, out destination); if (errors.Any(e => e.Value != null) || source == null || destination == null) { if (reportStatus || useSideBand) { ReportFailure(response, failureBand, errors, "expected source and destination branches to be pushed"); } return; } var refPrefix = Guid.NewGuid().ToString(); source = new ProtocolUtils.UpdateRequest( source.SourceIdentifier, source.TargetIdentifier, RepoFormat.FormatSourceRef(refPrefix, 1)); destination = new ProtocolUtils.UpdateRequest( destination.SourceIdentifier, destination.TargetIdentifier, RepoFormat.FormatDestinationRef(refPrefix, 1)); var output = this.ReadPack(new[] { source, destination }, capabilities, input); var line = ProtocolUtils.ReadPacketLine(output).TrimEnd('\n'); if (line != "unpack ok") { line = line.Substring("unpack ".Length); if (reportStatus || useSideBand) { ReportFailure(response, failureBand, errors, line); } return; } string id; try { using (var ctx = new ReviewContext()) { using (new NoSyncScope()) { id = ctx.GetNextReviewId().Result; } ctx.Reviews.Add(new Review { Id = id, RefPrefix = refPrefix, }); ctx.SaveChanges(); } } catch (DbUpdateException ex) { ReportFailure(response, failureBand, errors, ex.GetBaseException().Message); throw; } if (useSideBand) { var url = new UrlHelper(context.RequestContext).Action("Index", "Home", null, context.HttpContext.Request.Url.Scheme) + "#/" + id; var message = string.Format("code review created:\n\n\t{0}\n\n", url); response.BinaryWrite(ProtocolUtils.Band(ProtocolUtils.MessageBand, Encoding.UTF8.GetBytes(message))); } if (reportStatus) { ReportSuccess(response, reportBand); } } finally { if (useSideBand) { response.BinaryWrite(ProtocolUtils.EndMarker); } } }
private static void ReportSuccess(HttpResponseBase response, int? reportBand) { response.BinaryWrite(ProtocolUtils.Band(reportBand, ProtocolUtils.PacketLine("unpack ok\n"), ProtocolUtils.PacketLine("ok " + DestinationRefName + "\n"), ProtocolUtils.PacketLine("ok " + SourceRefName + "\n"), ProtocolUtils.EndMarker)); }
private static void ReportFailure(HttpResponseBase response, int? reportBand, Dictionary<ProtocolUtils.UpdateRequest, string> errors, string message) { if (reportBand == ProtocolUtils.ErrorBand) { response.BinaryWrite(ProtocolUtils.Band(ProtocolUtils.MessageBand, ProtocolUtils.DefaultEncoding.GetBytes(string.Format("{0}\n", message)))); foreach (var e in errors) { response.BinaryWrite(ProtocolUtils.Band(ProtocolUtils.MessageBand, ProtocolUtils.DefaultEncoding.GetBytes(string.Format("{0} ({1})\n", e.Key.CanonicalName, e.Value ?? "not created, see other errors")))); } response.BinaryWrite(ProtocolUtils.Band(ProtocolUtils.ErrorBand, ProtocolUtils.DefaultEncoding.GetBytes("code review creation aborted\n"))); } else { var status = new List<byte[]>(); status.Add(ProtocolUtils.PacketLine(string.Format("unpack {0}\n", message))); foreach (var e in errors) { status.Add(ProtocolUtils.PacketLine(string.Format("ng {0} {1}\n", e.Key.CanonicalName, e.Value ?? "not created, see other errors"))); } status.Add(ProtocolUtils.EndMarker); response.BinaryWrite(ProtocolUtils.Band(reportBand, status)); } }
public async Task WriteResponseAsync(HttpResponseBase response) { response.ThrowIfNull("response"); response.StatusCode = _statusCode.StatusCode; response.SubStatusCode = _statusCode.SubStatusCode; response.ContentType = ContentType; response.Charset = Charset; response.ContentEncoding = ContentEncoding; foreach (Header header in Headers) { response.Headers.Add(header.Field, header.Value); } response.HeaderEncoding = HeaderEncoding; foreach (Cookie cookie in Cookies) { response.Cookies.Add(cookie.GetHttpCookie()); } _cachePolicy.Apply(response.Cache); response.TrySkipIisCustomErrors = _skipIisCustomErrors; response.BinaryWrite(await _content.Value); }
public static void ExportPdf(ExportEventArgs options, HttpResponseBase response) { response.AddHeader("Content-Disposition", String.Format("attachment; filename={0}.pdf", options.Title)); response.ContentType = "application/pdf"; response.BinaryWrite(ExportPdfHelper.ToPdfBytes(options)); }
private void CreateCheckCodeImage(string checkCode, HttpResponseBase response) { if (checkCode == null || checkCode.Trim() == String.Empty) return; System.Drawing.Bitmap image = new System.Drawing.Bitmap((int)Math.Ceiling((checkCode.Length * 16.5)), 35); Graphics g = Graphics.FromImage(image); try { //生成随机生成器 Random random = new Random(); //清空图片背景色 g.Clear(Color.White); // Pen drawPen = new Pen(Color.Blue); // 添加多种颜色 hooyes Color[] colors = { Color.Blue,Color.Silver,Color.SlateGray,Color.Turquoise,Color.Violet,Color.Turquoise,Color.Tomato,Color.Thistle,Color.Teal,Color.SteelBlue }; //画图片的背景噪音线 for (int i = 0; i < 9; i++) { int x1 = random.Next(image.Width); int x2 = random.Next(image.Width); int y1 = random.Next(image.Height); int y2 = random.Next(image.Height); Pen drawPen2 = new Pen(colors[i]); g.DrawLine(drawPen2, x1, y1, x2, y2); } // drawPen.Dispose(); Tahoma Font font = new System.Drawing.Font("Arial", 13, (System.Drawing.FontStyle.Bold)); System.Drawing.Drawing2D.LinearGradientBrush brush = new System.Drawing.Drawing2D.LinearGradientBrush(new Rectangle(0, 0, image.Width, image.Height), Color.Black, Color.Gray, 1.2f, true); g.DrawString(checkCode, font, brush, 2, 1); // g.DrawString("J", font, brush, 1, 115); font.Dispose(); brush.Dispose(); //画图片的前景噪音点 for (int i = 0; i < 20; i++) { int x = random.Next(image.Width); int y = random.Next(image.Height); image.SetPixel(x, y, Color.FromArgb(0x8b, 0x8b, 0x8b)); } //画图片的边框线 Pen borderPen = new Pen(Color.Transparent); g.DrawRectangle(borderPen, 0, 0, image.Width - 1, image.Height - 1); borderPen.Dispose(); System.IO.MemoryStream ms = new System.IO.MemoryStream(); image.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp); byte[] buffer = ms.ToArray(); ms.Dispose(); response.ClearContent(); response.ContentType = "image/bmp"; response.BinaryWrite(buffer); } finally { g.Dispose(); image.Dispose(); } }
/// <summary> /// 创建验证码的图片 /// </summary> /// <param name="containsPage">要输出到的page对象</param> /// <param name="validateNum">验证码</param> public void CreateValidateGraphic(string validateCode,HttpResponseBase Response) { Bitmap image = new Bitmap((int)Math.Ceiling(validateCode.Length * 12.0), 22); Graphics g = Graphics.FromImage(image); try { //生成随机生成器 Random random = new Random(); //清空图片背景色 g.Clear(Color.White); //画图片的干扰线 for (int i = 0; i < 25; i++) { int x1 = random.Next(image.Width); int x2 = random.Next(image.Width); int y1 = random.Next(image.Height); int y2 = random.Next(image.Height); g.DrawLine(new Pen(Color.Silver), x1, y1, x2, y2); } Font font = new Font("Arial", 12, (FontStyle.Bold | FontStyle.Italic)); LinearGradientBrush brush = new LinearGradientBrush(new Rectangle(0, 0, image.Width, image.Height), Color.Blue, Color.DarkRed, 1.2f, true); g.DrawString(validateCode, font, brush, 3, 2); //画图片的前景干扰点 for (int i = 0; i < 100; i++) { int x = random.Next(image.Width); int y = random.Next(image.Height); image.SetPixel(x, y, Color.FromArgb(random.Next())); } //画图片的边框线 g.DrawRectangle(new Pen(Color.Silver), 0, 0, image.Width - 1, image.Height - 1); //保存图片数据 MemoryStream stream = new MemoryStream(); image.Save(stream, ImageFormat.Jpeg); //输出图片流 Response.Clear(); Response.ContentType = "image/jpeg"; Response.BinaryWrite(stream.ToArray()); } finally { g.Dispose(); image.Dispose(); } }
private static void SaveToResponse(string fileName, HttpResponseBase stream) { using (var reader = File.OpenRead(fileName)) { var bt = new byte[1024]; var count = 0; while ((count = reader.Read(bt, 0, 1024)) == 1024) { stream.BinaryWrite(bt); } if (count > 0) { var bt2 = new byte[count]; Array.Copy(bt, bt2, count); stream.BinaryWrite(bt2); } } }
/// <summary> /// 创建Excel /// </summary> public static void CreateExcel(HttpResponseBase response, HttpRequestBase request, int[] idArr) { // 文件名 //string fileName = DateTime.Now.ToString("yyyyMMdd") + "测试.xls";、 string fileName = "面试者信息表.xls"; string UserAgent = request.ServerVariables["http_user_agent"].ToLower(); // Firfox和IE下输出中文名显示正常 if (UserAgent.IndexOf("firefox") == -1) { fileName = HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8); } response.ContentType = "application/vnd.ms-excel;charset=UTF-8"; response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", fileName)); response.Clear(); // 新建Excel文档 HSSFWorkbook excel = new HSSFWorkbook(); // 新建一个Excel页签 ISheet sheet = excel.CreateSheet("面试者信息表"); //设置居中 ICellStyle cellStyle = excel.CreateCellStyle(); cellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; cellStyle.VerticalAlignment = VerticalAlignment.Center; // 创建新增行 IRow row = sheet.CreateRow(0); // 设计表头 ICell cell = row.CreateCell(0); cell.CellStyle = cellStyle; cell.SetCellValue("ID"); cell = row.CreateCell(1); cell.CellStyle = cellStyle; cell.SetCellValue("学号"); cell = row.CreateCell(2); cell.CellStyle = cellStyle; cell.SetCellValue("姓名"); cell = row.CreateCell(3); cell.CellStyle = cellStyle; cell.SetCellValue("性别"); cell = row.CreateCell(4); cell.CellStyle = cellStyle; cell.SetCellValue("学院"); cell = row.CreateCell(5); cell.CellStyle = cellStyle; cell.SetCellValue("专业"); cell = row.CreateCell(6); cell.CellStyle = cellStyle; cell.SetCellValue("班级"); cell = row.CreateCell(7); cell.CellStyle = cellStyle; cell.SetCellValue("QQ"); cell = row.CreateCell(8); cell.CellStyle = cellStyle; cell.SetCellValue("E-mail"); cell = row.CreateCell(9); cell.CellStyle = cellStyle; cell.SetCellValue("联系方式"); cell = row.CreateCell(10); cell.CellStyle = cellStyle; cell.SetCellValue("学习经验"); cell = row.CreateCell(11); cell.CellStyle = cellStyle; cell.SetCellValue("自我介绍"); cell = row.CreateCell(12); cell.CellStyle = cellStyle; cell.SetCellValue("是否应聘技术方向"); cell = row.CreateCell(13); cell.CellStyle = cellStyle; cell.SetCellValue("选择题得分"); cell = row.CreateCell(14); cell.CellStyle = cellStyle; cell.SetCellValue("简答题得分"); cell = row.CreateCell(15); cell.CellStyle = cellStyle; cell.SetCellValue("总分"); cell = row.CreateCell(16); cell.CellStyle = cellStyle; cell.SetCellValue("评语"); //根据答卷 //表格添加内容 List<MODEL.T_InterviewerInfo> list = OperateContext.Current.BLLSession .IInterviewerInfoBLL.GetListBy(i => idArr.Contains(i.ID)).ToList(); for (int i = 0; i < list.Count; i++) { row = sheet.CreateRow(i + 1); cell = row.CreateCell(0); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].ID); cell = row.CreateCell(1); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Num); cell = row.CreateCell(2); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Name); cell = row.CreateCell(3); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Gender); cell = row.CreateCell(4); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Academy); cell = row.CreateCell(5); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Major); cell = row.CreateCell(6); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Class); cell = row.CreateCell(7); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].QQ); cell = row.CreateCell(8); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].Email); cell = row.CreateCell(9); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].TelNum); cell = row.CreateCell(10); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].LearningExperience); cell = row.CreateCell(11); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].SelfEvaluation); cell = row.CreateCell(12); cell.CellStyle = cellStyle; cell.SetCellValue(list[i].IsRequestTech == true ? "是" : "否"); cell = row.CreateCell(13); cell.CellStyle = cellStyle; cell.SetCellValue(GetChoiceScore(list[i].ID)); cell = row.CreateCell(14); cell.CellStyle = cellStyle; cell.SetCellValue(GetBriefScore(list[i].ID)); cell = row.CreateCell(15); cell.CellStyle = cellStyle; cell.SetCellValue(GetTotalScore(list[i].ID)); cell = row.CreateCell(16); cell.CellStyle = cellStyle; cell.SetCellValue(GetComment(list[i].ID)); } // 设置行宽度 sheet.SetColumnWidth(1, 18 * 256); sheet.SetColumnWidth(4, 22 * 256); sheet.SetColumnWidth(5, 22 * 256); sheet.SetColumnWidth(7, 15 * 256); sheet.SetColumnWidth(8, 21 * 256); sheet.SetColumnWidth(9, 16 * 256); sheet.SetColumnWidth(12, 18 * 256); sheet.SetColumnWidth(16, 30 * 256); //将Excel内容写入到流中 MemoryStream file = new MemoryStream(); excel.Write(file); //输出 response.BinaryWrite(file.GetBuffer()); response.End(); }
public bool SendContent(string url, HttpResponseBase response) { if (fileStore.SendContent(url, response)) return true; var key = uriBuilder.ParseKey(url); var id = Guid.Parse(uriBuilder.ParseSignature(url)); var file = repository[id]; if(file != null) { response.BinaryWrite(file.Content); fileStore.Save(file.Content, url, null); RRTracer.Trace("{0} transmitted from db.", url); if (file.IsExpired) reductionRepository.RemoveReduction(key); return true; } RRTracer.Trace("{0} not found on file or db.", url); reductionRepository.RemoveReduction(key); return false; }
public static void DumpXlsx(HttpResponseBase response, DataTable table, string fileName, string title = "") { var sw = System.Diagnostics.Stopwatch.StartNew(); using (ExcelPackage pck = new ExcelPackage()) { //Create the worksheet ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report"); int headerRowNo = 1; //Load the datatable into the sheet, starting from cell A1. Print the column names on row 1 if (title.IsNullOrEmpty()) { headerRowNo = 2; } else { headerRowNo = 3; } //var t = sw.Elapsed; //System.Diagnostics.Debug.WriteLine(string.Format("1. {0}M {1}S, {2}MS", t.Minutes, t.Seconds, t.Milliseconds)); //sw.Restart(); ws.Cells[string.Format("A{0}", headerRowNo)].LoadFromDataTable(table, true); //t = sw.Elapsed; //System.Diagnostics.Debug.WriteLine(string.Format("2. {0}M {1}S, {2}MS", t.Minutes, t.Seconds, t.Milliseconds)); //sw.Restart(); int colCount = table.Columns.Count; string lastColName = GetExcelColumnName(colCount); ExcelRange cols = ws.Cells[string.Format("A:{0}", lastColName)]; cols.Style.Font.Name = "Tahoma"; cols.Style.Font.Size = 10; //Format the header for column 1-3 using (ExcelRange rng = ws.Cells[string.Format("A{0}:{1}{0}", headerRowNo, lastColName)]) // "A1:{0}1" { rng.Style.Font.Bold = true; rng.Style.Fill.PatternType = ExcelFillStyle.Solid; //Set Pattern for the background to Solid rng.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(79, 129, 189)); //Set color to dark blue rng.Style.Font.Color.SetColor(Color.White); } //t = sw.Elapsed; //System.Diagnostics.Debug.WriteLine(string.Format("3. {0}M {1}S, {2}MS", t.Minutes, t.Seconds, t.Milliseconds)); //sw.Restart(); ws.Cells[headerRowNo, 1, headerRowNo + 10, colCount].AutoFitColumns(); //t = sw.Elapsed; //System.Diagnostics.Debug.WriteLine(string.Format("4. {0}M {1}S, {2}MS", t.Minutes, t.Seconds, t.Milliseconds)); //sw.Restart(); string createDate = string.Format("{0}: {1}", "สร้างเมื่อ", DateTime.Now.ToString("d MMMM yyyy เวลา H:mm น.", AppUtils.ThaiCulture)); if (!title.IsNullOrEmpty()) { ws.Cells[1, 1].Value = title; // ws.SetValue(1, 1, title); using (ExcelRange rng = ws.Cells["A1:A1"]) { rng.Style.Font.Bold = true; } ws.Cells[2, 1].Value = createDate; } else { ws.Cells[1, 1].Value = createDate; } //Example how to Format Column 1 as numeric //using (ExcelRange col = ws.Cells[2, 1, 2 + tbl.Rows.Count, 1]) //{ // col.Style.Numberformat.Format = "#,##0.00"; // col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right; //} //t = sw.Elapsed; //System.Diagnostics.Debug.WriteLine(string.Format("5. {0}M {1}S, {2}MS", t.Minutes, t.Seconds, t.Milliseconds)); //sw.Restart(); //Write it back to the client response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; response.AddHeader("content-disposition", string.Format("attachment; filename={0}.xlsx", AppUtils.CleanFileName(fileName))); response.BinaryWrite(pck.GetAsByteArray()); //t = sw.Elapsed; //System.Diagnostics.Debug.WriteLine(string.Format("6. {0}M {1}S, {2}MS", t.Minutes, t.Seconds, t.Milliseconds)); //sw.Restart(); } }