How to download excel from datatable using gembox in asp

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

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