Event 'Imprimir factura' // Creo factura a partir de template &spreadsheet.UseAutomation = 0 &spreadsheet.Template = "C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\ExcelToPdfJavaEnvironment\factura.xlt" &spreadsheet.Open("C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\ExcelToPdfJavaEnvironment\static\fact1.xls") &spreadsheet.Cells(9,4).text = "Jose Perez" &spreadsheet.Cells(13,3).text = "1 iPod" &spreadsheet.Cells(14,3).text = "80 USD" &spreadsheet.Close() // Convierto la factura de XLS a PDF &GxDocConverter.convert("C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\ExcelToPdfJavaEnvironment\static\fact1.xls","C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\ExcelToPdfJavaEnvironment\static\fact1.pdf","1",true) // Imprimo la factura PDF &GxDocConverter.addAutoPrint("C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\ExcelToPdfJavaEnvironment\static\fact1.pdf", true) SalidaOculta.Source=link("/ExcelToPdfJavaEnvironment/static/fact1.pdf")EndEvent Gx 9 Event 'Imprimir' &pathSpreadsheet = "C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ExcelToPdf9\images\fact1.xls" &pathPdf = "C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ExcelToPdf9\images\fact1.pdf" &pathXlt = "C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ExcelToPdf9\factura.xlt" &urlPdf = "/ExcelToPdf9/images/fact1.pdf" // Creo factura a partir de template &spreadsheet.UseAutomation = 0 &spreadsheet.Template = &pathXlt &spreadsheet.Open(&pathSpreadsheet) &spreadsheet.Cells(9,4).text = "Jose Perez" &spreadsheet.Cells(13,3).text = "1 iPod" &spreadsheet.Cells(14,3).text = "80 USD" &spreadsheet.Close() // Instancio el GxDocConverter java com.tacuati.gxdocconverter.GxDocConverter c = new com.tacuati.gxdocconverter.GxDocConverter(); // Convierto la factura de XLS a PDF java c.convert([!&pathSpreadsheet!],[!&pathPdf!],"1",true); // Imprimo la factura PDF java c.addAutoPrint([!&pathPdf!], true); EmbPage1.Source = link(&urlPdf); EndEvent // 'Imprimir' |