How to download excel from datatable using gembox in asp

Question

Hi, My objective is download Excel with three sheets from three datatable in asp .net but its not downloading with out any error using gembox.spreedshhet; ExcelFile ef = new ExcelFile(); Excelworksheet ws = ef. worksheets.Add('Summary'); //adding three sheets Excelworksheet ws1 = ef. worksheets.Add('Summary1'); Excelworksheet ws2 = ef. worksheets.Add('Summary2'); WS.Insertdatatable(dt,'A1',true); // dt,dt1,dt2 are datatable WS1.Insertdatatable(dt1,'A1',true);//A1 Cell statring WS2.Insertdatatable(dt2,'A1',true); ef.savsxls(test.xls) ; one more thing i able to place excel in my project folder by giving filepath as Filesteam fs and passed to ef.savsxls(fs) ; but I need to download in browser its very urgent, Can any one help me thanks

Praveen Kumar Sreeram · Answer

I assume you the following. 1) You are able to successfully generate the excelsheet in a folder on the server. 2) You would like to allow the end user to download the generated excel file on clicking a button or something on the browser. In the button click you need to write the following code. FileStream sourceFile = new FileStream(Server.MapPath(@"FileName"), FileMode.Open); float FileSize; FileSize = sourceFile.Length; byte[] getContent = new byte[(int)FileSize]; sourceFile.Read(getContent, 0, (int)sourceFile.Length); sourceFile.Close(); Response.ClearContent(); Response.ClearHeaders(); Response.Buffer = true; Response.ContentType = ReturnExtension(file.Extension.ToLower()); Response.AddHeader("Content-Length", getContent.Length.ToString()); Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName); Response.BinaryWrite(getContent); Response.Flush(); Response.End(); Hope it helped Thanks, Prawin

How to download excel from datatable using gembox in asp

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)