Export RDLC Report to Excel without Report Viewer

private void Initialize()

{

populateinfo();//data for print in rdlc

ReportOptionUiModel reportOptionUiModel = _mainWindow.Test;

rptOpt.Add(reportOptionUiModel);

_reportViewer.LocalReport.DataSources.Clear();

var departmentsModels = new ReportDataSource() { Name = "DATASET1", Value = rptOpt };

var departmentsModel = new ReportDataSource() { Name = "DATASET2", Value = glycaninfolist };

_reportViewer.LocalReport.DataSources.Add(departmentsModels);

_reportViewer.LocalReport.DataSources.Add(departmentsModel);

//var path=Path.GetDirectoryName(Path.GetDirectoryName(Path.GetDirectoryName(Directory.GetCurrentDirectory())));

var MainPage = @"D:\LatestJust\Report3.rdlc";

_reportViewer.LocalReport.ReportPath = MainPage;

_reportViewer.LocalReport.EnableExternalImages = true;

_reportViewer.SetDisplayMode(DisplayMode.PrintLayout);

_reportViewer.Refresh();

_reportViewer.RefreshReport();

//Create an instance of ReportViewer

byte[] pdfContent = null;

string fname = "GlycanReport";

//Exporting Rdlc report to Microsoft Word.

if (FileTypeExportEnum.MicrosoftWord == reportOptionUiModel.IsMicrosoftExcel)

{

pdfContent = _reportViewer.LocalReport.Render("WORD", null);

string pdfPath = @"D:\LatestJust\bin\Debug\Output\" + fname + ".doc";

System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);

pdfFile.Write(pdfContent, 0, pdfContent.Length);

pdfFile.Close();

System.Diagnostics.Process.Start(pdfPath);

}

//Exporting Rdlc report to Microsoft Excel.

else if (FileTypeExportEnum.MicrosoftExcel == reportOptionUiModel.IsMicrosoftExcel)

{

pdfContent = _reportViewer.LocalReport.Render(fname.EndsWith("*.xlsx") ? "EXCELOPENXML" : "Excel", null);

string pdfPath = @"D:\LatestJust\bin\Debug\Output\" + fname + ".xlsx";

System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);

pdfFile.Write(pdfContent, 0, pdfContent.Length);

pdfFile.Close();

System.Diagnostics.Process.Start(pdfPath);

}

//Exporting Rdlc report to Adobe PDF.

else

{

pdfContent = _reportViewer.LocalReport.Render("PDF", null);

string pdfPath = @"D:\LatestJust\bin\Debug\Output\" + fname + ".pdf";

System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);

pdfFile.Write(pdfContent, 0, pdfContent.Length);

pdfFile.Close();

System.Diagnostics.Process.Start(pdfPath);

}

1 Reply

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

Er Harry Singh6y ago
private void Initialize()
{
populateinfo();//data for print in rdlc
ReportOptionUiModel reportOptionUiModel = _mainWindow.Test;
rptOpt.Add(reportOptionUiModel);
_reportViewer.LocalReport.DataSources.Clear();
var departmentsModels = new ReportDataSource() { Name = "DATASET1", Value = rptOpt };
var departmentsModel = new ReportDataSource() { Name = "DATASET2", Value = glycaninfolist };
_reportViewer.LocalReport.DataSources.Add(departmentsModels);
_reportViewer.LocalReport.DataSources.Add(departmentsModel);
//var path=Path.GetDirectoryName(Path.GetDirectoryName(Path.GetDirectoryName(Directory.GetCurrentDirectory())));
var MainPage = @"D:\LatestJust\Report3.rdlc";
_reportViewer.LocalReport.ReportPath = MainPage;
_reportViewer.LocalReport.EnableExternalImages = true;
_reportViewer.SetDisplayMode(DisplayMode.PrintLayout);
_reportViewer.Refresh();
_reportViewer.RefreshReport();
//Create an instance of ReportViewer
byte[] pdfContent = null;
string fname = "GlycanReport";
//Exporting Rdlc report to Microsoft Word.
if (FileTypeExportEnum.MicrosoftWord == reportOptionUiModel.IsMicrosoftExcel)
{
pdfContent = _reportViewer.LocalReport.Render("WORD", null);
string pdfPath = @"D:\LatestJust\bin\Debug\Output\" + fname + ".doc";
System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);
pdfFile.Write(pdfContent, 0, pdfContent.Length);
pdfFile.Close();
System.Diagnostics.Process.Start(pdfPath);
}
//Exporting Rdlc report to Microsoft Excel.
else if (FileTypeExportEnum.MicrosoftExcel == reportOptionUiModel.IsMicrosoftExcel)
{
pdfContent = _reportViewer.LocalReport.Render(fname.EndsWith("*.xlsx") ? "EXCELOPENXML" : "Excel", null);
string pdfPath = @"D:\LatestJust\bin\Debug\Output\" + fname + ".xlsx";
System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);
pdfFile.Write(pdfContent, 0, pdfContent.Length);
pdfFile.Close();
System.Diagnostics.Process.Start(pdfPath);
}
//Exporting Rdlc report to Adobe PDF.
else
{
pdfContent = _reportViewer.LocalReport.Render("PDF", null);
string pdfPath = @"D:\LatestJust\bin\Debug\Output\" + fname + ".pdf";
System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);
pdfFile.Write(pdfContent, 0, pdfContent.Length);
pdfFile.Close();
System.Diagnostics.Process.Start(pdfPath);
}
}
0