public void LoadReport(string fileName, bool autoFit)
{
Workbook book = new Workbook();
book.LoadFromFile(fileName);
ReportBookTemplate tplbook = new ReportBookTemplate();
tplbook.LoadTemplate(db, book, paramMap);
tplbook.FillTemplate();
List <ReportSheetTemplate> tplList = tplbook.sheetList;
// tpl.Clear();
// Open with Excel
/* xlapp.Visible = false;*/
try
{
ClearReport(autoFit, book, tplList);
// xlapp.Workbooks.Close ();
// Copy Image
}
finally
{
book.Save();
book.Dispose();
/* xlapp.DisplayAlerts = true ;
*
* xlapp.Visible = true;
*/
RemoveWarning(fileName);
Process.Start(fileName);
}
// remove warnning sheet.
}
private void button7_Click(object sender, EventArgs e)
{
_PrintExcel.Workbook workbook = new _PrintExcel.Workbook();
workbook.LoadFromFile(filename);
_PrintExcel.Worksheet sheet = workbook.Worksheets["printout"];
sheet.SaveToPdf(path + "Sizing Printout.pdf");
System.Diagnostics.Process.Start("explorer.exe", path + "Sizing Printout.pdf");
workbook.Dispose();
//PrintDialog dialog = new PrintDialog();
//dialog.AllowPrintToFile = true;
//dialog.AllowCurrentPage = true;
//dialog.AllowSomePages = true;
//dialog.AllowSelection = true;
//dialog.UseEXDialog = true;
//dialog.PrinterSettings.Duplex = Duplex.Simplex;
//dialog.PrinterSettings.PrintRange = PrintRange.SomePages;
//workbook.PrintDialog = dialog;
//PrintDocument pd = workbook.PrintDocument;
//if (dialog.ShowDialog() == DialogResult.OK)
//{ pd.Print(); }
//Application excel = new Application();
//_Excel.Workbook workbook = excel.Workbooks.Open(filename, ReadOnly: false, Editable: true);
//_Excel.Worksheet worksheet = workbook.Worksheets["printout"] as _Excel.Worksheet;
//worksheet.PrintPreview();
//worksheet.PrintOut(From:1,To:2,Copies:1, Preview:true, Type.Missing, PrintToFile:true, Type.Missing, Type.Missing);
//worksheet.PrintPreview();
//PrintDialog printDlg = new PrintDialog();
/*PrintDocument printDoc = new PrintDocument();
* printDoc.DocumentName = "Print Document";
* printDlg.Document = printDoc;
* printDlg.AllowSelection = true;
* printDlg.AllowSomePages = true;
* if (printDlg.ShowDialog() == DialogResult.OK) printDoc.Print();*/
// worksheet.PrintOut(
//1, 1, 1, Type.Missing,
//Type.Missing, Type.Missing, Type.Missing, Type.Missing);
// // Cleanup:
// GC.Collect();
// GC.WaitForPendingFinalizers();
// Marshal.FinalReleaseComObject(worksheet);
// workbook.Close(false, Type.Missing, Type.Missing);
// Marshal.FinalReleaseComObject(workbook);
// excel.Quit();
// Marshal.FinalReleaseComObject(excel);
/*workbook.DisplayAlerts = false;
* excel.ActiveWorkbook.Save();
* excel.Application.Quit();
* excel.Quit();*/
}