Posted 1 April 2020, 12:31 am EST
When we call API for fifth or sixth in a row
We are calling SaveExcelSheet API
In this we call preparesheet() method
In prepare sheet We are using below both the methods in different conditions
and both methods get stuck at form.InpRptSpread.OpenExcel(stream, ExcelOpenFlags.DoNotRecalculateAfterLoad); method for 6 to 8 min
-
OpenExcel With Stream
public override void InitializeSheetWithStream(MemoryStream stream)
{
SpreadVisible(false);
form.InpRptSpread.Reset();
form.InpRptSpread.OpenExcel(stream, ExcelOpenFlags.DoNotRecalculateAfterLoad);
SetDefaultValuesForSpread(form.InpRptSpread);
}
-
OpenExcel With FileName
public override void InitializeSheet(string fileName)
{
SpreadVisible(false);
form.InpRptSpread.Reset();
form.InpRptSpread.OpenExcel(fileName, ExcelOpenFlags.DoNotRecalculateAfterLoad);
SetDefaultValuesForSpread(form.InpRptSpread);
}
Every time we get true from OpenExcel Method.
After this we call our save method to save data in db.
Below is our response from API
HTTP/1.1 200 OK
Cache-Control: no-store, no-cache, max-age=0
Transfer-Encoding: chunked
Content-Type: application/json; charset=utf-8
Set-Cookie: fpmsessionid=6610d387-31fb-41b1-a30d-417c56d554af; expires=Thu, 02 Apr 2020 08:45:12 GMT; path=/;SameSite=Strict; secure; httponly
Set-Cookie: FPM-XSRF-TOKEN=mAtN0jx039hDqenqmEsS2Sd6HW5XKb_TgLvMVLKYdiCd5Q1fYELK8gxeY0feWVMRZHV9pFW7QnOtrl_o69tQqUAdwyZCW8MtPXszf6LxLHc1%3asbKYUG_SohNnobANfkEq1K3nEMHb8O-qjoDTTGxlhxyrQJd2-PMVxv7nPWSKzLsg_3FwSQS3y7YmL5OebsFgiQCo179FY5ma9_ndQTIncO3_WKi9QVvqYHvcNuCV-f390; expires=Thu, 02 Apr 2020 08:45:12 GMT; path=/;SameSite=Strict; secure
Access-Control-Allow-Origin: *
Persistent-Auth: true
X-XSS-Protection: 1; mode=block
X-Frame-Options: DENY
X-Content-Type-Options: nosniff
Date: Wed, 01 Apr 2020 08:54:24 GMT
92
{“InputReportSaveResult”:{“$type”:“InputReportSaveResult”,“Messages”:},“VoucherSeries”:{“$type”:“VoucherSeriesManager”,“VoucherComponent”:null}}
0
