Share via

Winforms ReportViewer Excel Export with formulas

WPF2Web 21 Reputation points
2022-01-06T03:19:30.86+00:00

I have a Winform Report where one columns is calculated as the difference % between two columns. There is a total column which is calculated as the sum of two columns.
These formulas i need to export in the excel reports. Please provide a sample for this. I searched online but didn't find any sample for the reportviewer.

The existing report is rendered like this: reportviewer.LocalReport.Render("Excel", null,.....)
This rendered report has no formulas in the columns. It just has the numeric values.

Developer technologies | Windows Forms
Microsoft 365 and Office | Development | Other
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.