How to generate the output as pdf/Excel n MVC with angularJs

Hi,

I need to generate the output value as PDF or excel as per the end user choice.

Which is the best choice to handle. whether in Angular or MVC.

AngularJS:

$scope.ReportGenerate = function () {
TransactionReportData();
}
function TransactionReportData() {
var ReportData = {
Customername: $scope.SelectedCustomer.Identifier,
Transactionid: $scope.Transactionid,
StartDate: $('#StartDate').val() + " 00:00:00",
EndDate: $('#EndDate').val() + " 23:59:59",
OrderID: OdrID
};
var result = TransactionSearchService.GenerateReport(ReportData);
result.then(function (response) {
$scope.RPTData = response.data;
if ($scope.RPTData.ErrorInfo == null) {
$scope.ReportGenerateFormat = $scope.RPTData.ReportTransactions; // I need this value should be generate as PDF and excel and outpurformat display as Array(list)
}
else {
$scope.ErrorMessage += $scope.RPTData.ErrorInfo.Code;
$scope.ErrorMessage += " : ";
$scope.ErrorMessage += $scope.RPTData.ErrorInfo.Description;
}
});
};

Controller :

public ActionResult GenerateReport(string data)
{
DataContractJsonSerializer jsonObjectPersonInfo = new DataContractJsonSerializer(typeof(Transsearchdata));
MemoryStream stream = new MemoryStream(Encoding.UTF8.GetBytes(data));
Transsearchdata Search = (Transsearchdata)jsonObjectPersonInfo.ReadObject(stream);
Transactionsearch TransSearchData = new Transactionsearch();
TransactionReportResponse response = TransSearchData.ReportData(Search, "en");
return Json(response, JsonRequestBehavior.AllowGet);
}

How to do achieve this in MVC with angularjs.

It would be great if someone support.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Mishra7y ago
Accepted answer
Hello jaffer , I would suggest you to generate your pdf or excel file at your server side not in your browser. And then you can simply send the file as API Response . To generate PDF at server side you can use Rotativa Plugin and to generate the Excel file you can EPPlus
Jaffer Sadiq7y ago
Thanks Abhisek.

Its done in server side using Itextsharp PDF.
Abhishek Mishra7y ago
You can send the byte array of file as API Response, and convert that bytearray in to file at your client side.
Jaffer Sadiq7y ago
Thanks for your reply and information Abhiskeh.

Do you have any link which is related to this requirement. Because return response(return Json(response, JsonRequestBehavior.AllowGet)) as JSON here. So how to handle this.

Thanks in advance