BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
using Syncfusion.XlsIO;
public void ProcessRequest(HttpContext context)
{
string filePath = HttpContext.Current.Server.MapPath("\\Uploads") + "\\Temp\\" + context.Request.Form["filename"].ToString();
ImportRequest importRequest = new ImportRequest();
Stream fileStream = File.Open(filePath, FileMode.Open, System.IO.FileAccess.Read);
//Loads or open an existing workbook through Open method of IWorkbooks
ExcelEngine excelEngine = new ExcelEngine();
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(fileStream);
//Save the workbook as stream
MemoryStream outputStream = new MemoryStream();
workbook.SaveAs(outputStream, ",");//save as csv
outputStream.Position = 0;
workbook = excelEngine.Excel.Workbooks.Open(outputStream);
outputStream.Position = 0;
importRequest.FileStream = outputStream;
importRequest.File = null;
string str = Spreadsheet.Open(importRequest);
fileStream.Close();
fileStream.Dispose();
outputStream.Close();
outputStream.Dispose();
context.Response.Write(str);
} |