Hi,
I am trying to create a PDF file by copying selected Range of Cells to another sheet. The PDF is getting created but I am getting a black background colour in PDF. Please can you let me know how to remove the background colour from the PDF?
private void button1_Click(object sender, EventArgs e)
{
string pdfFileName = "";
string excelFileName = "000000_ExcelReport_20170619_1120.xlsx";
pdfFileName = excelFileName.Replace("xlsx", "pdf").Replace("Excel", "PDF");
Workbook workbook = new Workbook();
workbook.LoadFromFile(excelFileName, ExcelVersion.Version2013);
workbook.Worksheets.Add("newsheet");
workbook.Worksheets[0].Range["A1:N32"].Copy(workbook.Worksheets[3].Range["A1:N32"]);
Worksheet worksheet = workbook.Worksheets[3];
CellRange range = worksheet.Range["A1:N32"];
PageSetup setup = worksheet.PageSetup;
setup.FitToPagesWide = 1;
setup.FitToPagesTall = 1;
worksheet.SaveToPdf(pdfFileName);
System.Diagnostics.Process.Start(pdfFileName);
}
Regards,
Sathya