You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I guess this is similar to #2215 but I thought it was a different question and it's not an issue with the library.
We're developing a number of reports for a business system, in our system, rendering a report is a hangfire job which goes into a queue. Once the report is being processed, there is a bunch of steps such as fetching data and rendering the result to excel, all self contained in the job, ultimately delivering the resulting excel file using a signalR notification that the report is ready for download.
The reports are often complex with borders, grouping, formulas and sub group/grand totals.
I'm finding while tweaking the format of reports that the iteration speed of making a change and verifying it is very slow, since I have to make the code change, restart the application, run the report, wait for the job to run, download the excel file, open the file and validate the result, then repeat.
I've had a similar issue with email templates and for that, I usually create a developer-only route that instead of sending the email, prepares the model (usually with sample or test data) and invokes rendering to HTML, so I can simply make the change, build and refresh the browser to see the updated template.
Just wondering if anyone has any clever ideas, I'm thinking that if there was some way to render a specific sheet to HTML then a dev route could be created - or some way to get the resulting excel to immediately refresh/open to reduce the time spent on each change/test/verify iteration
We can change things internally in the application such as bypassing the hangfire queue for a dev test report etc.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I guess this is similar to #2215 but I thought it was a different question and it's not an issue with the library.
We're developing a number of reports for a business system, in our system, rendering a report is a hangfire job which goes into a queue. Once the report is being processed, there is a bunch of steps such as fetching data and rendering the result to excel, all self contained in the job, ultimately delivering the resulting excel file using a signalR notification that the report is ready for download.
The reports are often complex with borders, grouping, formulas and sub group/grand totals.
I'm finding while tweaking the format of reports that the iteration speed of making a change and verifying it is very slow, since I have to make the code change, restart the application, run the report, wait for the job to run, download the excel file, open the file and validate the result, then repeat.
I've had a similar issue with email templates and for that, I usually create a developer-only route that instead of sending the email, prepares the model (usually with sample or test data) and invokes rendering to HTML, so I can simply make the change, build and refresh the browser to see the updated template.
Just wondering if anyone has any clever ideas, I'm thinking that if there was some way to render a specific sheet to HTML then a dev route could be created - or some way to get the resulting excel to immediately refresh/open to reduce the time spent on each change/test/verify iteration
We can change things internally in the application such as bypassing the hangfire queue for a dev test report etc.
Beta Was this translation helpful? Give feedback.
All reactions