how to resize of Report PDF Export from Data Table ?

public async Task ExportPDF()
{
//student list
//var dataList = GetStudentList();
var users = _context.TEntity.Select(u => new Employee
{
Id = u.Id,
Name = u.Name,
Address = u.Address,
Birthdate = u.Birthdate,
Gender = u.Gender,
Email = u.Email,
Designation = u.Designation,
Salary = u.Salary
}).ToList();
if (users == null) return null;
//column Header name
var columnsHeader = new List<string>{
"S/N",
"Name",
"Address",
"Birthdate",
"Gender",
"Email",
"Designation",
"Salary"
};
var filecontent = ExportPDF(users, columnsHeader, "TEntity");
return File(filecontent, "application/pdf", "Employee.pdf"); ;
}
#endregion
#region Helpers of Export PDF
private byte[] ExportPDF(List dataList, List<string> columnsHeader, string heading)
{
var document = new Document();
var outputMS = new MemoryStream();
var writer = PdfWriter.GetInstance(document, outputMS);
document.Open();
var font5 = FontFactory.GetFont(FontFactory.HELVETICA, 11);
document.Add(new Phrase(Environment.NewLine));
var count = columnsHeader.Count;
var table = new PdfPTable(count);
float[] widths = new float[] { 2f, 5f, 5f, 5f, 3f, 6f, 4f, 3f };
table.SetWidths(widths);
table.WidthPercentage = 100;
var cell = new PdfPCell(new Phrase(heading));
cell.Colspan = count;
for (int i = 0; i < count; i++)
{
var headerCell = new PdfPCell(new Phrase(columnsHeader[i], font5));
headerCell.BackgroundColor = BaseColor.Gray;
table.AddCell(headerCell);
}
var sn = 1;
foreach (var item in dataList)

2 Replies

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

Rajesh Gami8y ago
1. public async Task ExportPDF()
2. {
3. //student list
4. //var dataList = GetStudentList();
5. var users = _context.TEntity.Select(u => new Employee
6. {
7. Id = u.Id,
8. Name = u.Name,
9. Address = u.Address,
10. Birthdate = u.Birthdate,
11. Gender = u.Gender,
12. Email = u.Email,
13. Designation = u.Designation,
14. Salary = u.Salary
15. }).ToList();
16. if (users == null) return null;
17. //column Header name
18. var columnsHeader = new List<string>{
19. "S/N",
20. "Name",
21. "Address",
22. "Birthdate",
23. "Gender",
24. "Email",
25. "Designation",
26. "Salary"
27. };
28. var filecontent = ExportPDF(users, columnsHeader, "TEntity");
29. return File(filecontent, "application/pdf", "Employee.pdf"); ;
30. }
31. #endregion
32. #region Helpers of Export PDF
33. private byte[] ExportPDF(List dataList, List<string> columnsHeader, string heading)
34. {
35. var document = new Document();
36. var outputMS = new MemoryStream();
37. var writer = PdfWriter.GetInstance(document, outputMS);
38. document.Open();
39. var font5 = FontFactory.GetFont(FontFactory.HELVETICA, 11);
40. document.Add(new Phrase(Environment.NewLine));
41. var count = columnsHeader.Count;
42. var table = new PdfPTable(count);
43. float[] widths = new float[] { 2f, 5f, 5f, 5f, 3f, 6f, 4f, 3f };
44. table.SetWidths(widths);
45. table.WidthPercentage = 100;
46. var cell = new PdfPCell(new Phrase(heading));
47. cell.Colspan = count;
48. for (int i = 0; i < count; i++)
49. {
50. var headerCell = new PdfPCell(new Phrase(columnsHeader[i], font5));
51. headerCell.BackgroundColor = BaseColor.Gray;
52. table.AddCell(headerCell);
53. }
54. var sn = 1;
55. foreach (var item in dataList)