public override DevExpress.XtraPrinting.IPrintable CreatePrintableComponent(Item fileItem)
{
IWorkbook workbook = new Workbook();
workbook.AddService(typeof(IChartControllerFactoryService), new ChartControllerFactoryService());
workbook.AddService(typeof(IChartImageService), new ChartImageService());
Stream contentStream = DocumentsApp.Data.ReadFileContent(fileItem);
workbook.LoadDocument(contentStream, GetFormat(fileItem));
return(workbook);
}
static void Main(string[] args)
{
#region #ExportToPDF
Workbook workbook = new Workbook();
//Register required services.
workbook.AddService(typeof(IChartControllerFactoryService), new ChartControllerFactoryService());
workbook.AddService(typeof(IChartImageService), new ChartImageService());
workbook.LoadDocument("testDocument.xlsx");
workbook.ExportToPdf("resultingDocument.pdf");
#endregion #ExportToPDF
System.Diagnostics.Process.Start("resultingDocument.pdf");
}
IBasePrintable CreatePrintableComponent(string extention, Stream contentStream)
{
IBasePrintable component;
if (RICH_EDIT_TYPES.Contains(extention))
{
RichEditDocumentServer docServer = new RichEditDocumentServer();
switch (extention)
{
case ".docx": docServer.LoadDocument(contentStream, DevExpress.XtraRichEdit.DocumentFormat.Doc); break;
case ".doc": docServer.LoadDocument(contentStream, DevExpress.XtraRichEdit.DocumentFormat.Doc); break;
case ".rtf": docServer.LoadDocument(contentStream, DevExpress.XtraRichEdit.DocumentFormat.Rtf); break;
case ".html": docServer.LoadDocument(contentStream, DevExpress.XtraRichEdit.DocumentFormat.Html); break;
}
component = docServer;
}
else if (SPREAD_SHEET_TYPES.Contains(extention))
{
IWorkbook workbook = new Workbook();
workbook.AddService(typeof(IChartControllerFactoryService), new ChartControllerFactoryService());
workbook.AddService(typeof(IChartImageService), new ChartImageService());
switch (extention)
{
case ".xls": workbook.LoadDocument(contentStream, DevExpress.Spreadsheet.DocumentFormat.Xls); break;
case ".xlsx": workbook.LoadDocument(contentStream, DevExpress.Spreadsheet.DocumentFormat.Xlsx); break;
case ".txt": workbook.LoadDocument(contentStream, DevExpress.Spreadsheet.DocumentFormat.Text); break;
case ".csv": workbook.LoadDocument(contentStream, DevExpress.Spreadsheet.DocumentFormat.Csv); break;
}
component = workbook;
}
else
{
return(null);
}
return(component);
}
void ProcessExcel(string fileName, List <KeyValuePair <int, int> > data)
{
//fileName = @"C:\Users\Mushfikur Rahman\Downloads\Technical-Adaptive Assessment.xlsx";
//Microsoft.Office.Interop.Excel.Application excelAppObj = new Microsoft.Office.Interop.Excel.Application();
//excelAppObj.DisplayAlerts = false;
//Open the excel work book
//Microsoft.Office.Interop.Excel.Workbook workBook = excelAppObj.Workbooks.Open(fileName, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, false, false);
//ExcelWorkbook workBook = ExcelWorkbook.ReadXLSX(fileName);
//Get the first sheet of the selected work book
//Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets.get_Item(1);
//var worksheet = workBook.Worksheets[0];
//Book workbook = new BinBook();
//workbook.load(fileName);
Workbook workbook = new Workbook();
workbook.LoadDocument(fileName);
//var worksheet = workbook.getSheet(0);
var worksheet = workbook.Worksheets[0];
//Write 20 in Cell - C3
worksheet.Cells[4, 3].Value = txtName.Text;
worksheet.Cells[186, 1].Value = txtCompany.Text + ", " + txtEmail.Text;
//worksheet.writeStr(5, 4, txtName.Text);
//worksheet.writeStr(187, 2, txtCompany.Text + ", " + txtEmail.Text);
var curRow = 6;
foreach (var item in data)
{
worksheet.Cells[curRow + item.Key - 1, 3].Value = 1;
worksheet.Cells[curRow + item.Value - 1, 4].Value = 1;
//worksheet.writeNum(curRow + item.Key - 1, 4, 1);
//worksheet.writeNum(curRow + item.Value - 1, 5, 1);
curRow += 4;
}
//Save work book (.xlsx format)
//workBook.SaveAs(fileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, null, null, false,
//false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, false, false, null, null, null);
//workBook.WriteXLSX(fileName);
//workbook.save(fileName);
//excelAppObj.Quit();
workbook.AddService(typeof(IChartControllerFactoryService), new ChartControllerFactoryService());
workbook.AddService(typeof(IChartImageService), new ChartImageService());
workbook.SaveDocument(fileName);
var pdfFileName = fileName.Replace(".xlsx", ".pdf");
workbook.ExportToPdf(pdfFileName);
Session["ReportFilePath"] = pdfFileName;
var reportID = ins.SaveDownloads(int.Parse(Session["userId"].ToString()), "Natural Ability", pdfFileName);
Session["ReportID"] = reportID;
string errorFileName = Server.MapPath("~") + @"\Files\Docx\EmailError.txt";
var res = 1;// Basics.email_send(fileName.Replace(".xlsx", ".pdf"), string.Format("Natural Ability Assessment - {0}-{1}", txtName.Text, txtCompany.Text), "Your assessment report is ready to download.", txtEmail.Text, errorFileName);
var CurrentPage = GetCurrentPageName();
ins.DeleteHolt(int.Parse(Session["userId"].ToString()), CurrentPage);
ins.DeleteAnsState(CurrentPage, int.Parse(Session["userId"].ToString()));
if (res == 1)
{
Response.Redirect("Home.aspx");
}
else
{
Response.Redirect("Error.aspx");
}
}