knopix Posted April 30, 2013 Author Share Posted April 30, 2013 to import an excel file with 3 sheets or more into the mysql database how there is a solution? helpme? Regards Knopix Link to comment Share on other sites More sharing options...
mmurgas Posted May 15, 2013 Share Posted May 15, 2013 I recommend you see this ... works well http://www.delphiaccess.com/forum/trucos-y-consejos-16/exportar-ado-a-csv/ Link to comment Share on other sites More sharing options...
knopix Posted May 15, 2013 Author Share Posted May 15, 2013 Thank you Mr.mmurgas Regards Knopix Link to comment Share on other sites More sharing options...
mmurgas Posted November 26, 2013 Share Posted November 26, 2013 Roony encarnación , me podría indicar como hacer para usar Flexcel c/unigui, lo he usado en ambiente vcl pero no con web unigui, no se como enviar el archivo al servidor , yo use flexcel en delphi 5 sin problema. gracias de antemano mmurgas Link to comment Share on other sites More sharing options...
rencarnacion Posted November 26, 2013 Share Posted November 26, 2013 Hello is so Simple with FlexCel Here the Code var MemStream: TMemoryStream; begin inherited; MemStream := TMemoryStream.Create; try FlexReporteComision.SaveToStream(MemStream); UniSession.SendStream(MemStream, 'ReporteComision.XLS'); finally MemStream.Free; end; Link to comment Share on other sites More sharing options...
mmurgas Posted November 27, 2013 Share Posted November 27, 2013 Muchas Gracias, Excelente flexcel Thanks! Excelent Flexcel Link to comment Share on other sites More sharing options...
mmurgas Posted November 28, 2013 Share Posted November 28, 2013 Hello is so Simple with FlexCel Here the Code var MemStream: TMemoryStream; begin inherited; MemStream := TMemoryStream.Create; try FlexReporteComision.SaveToStream(MemStream); UniSession.SendStream(MemStream, 'ReporteComision.XLS'); finally MemStream.Free; end; I worked only in localhost mode .... uploaded it to the server and it did not work ... I will be doing wrong? Link to comment Share on other sites More sharing options...
rencarnacion Posted November 28, 2013 Share Posted November 28, 2013 It work in any mode !!! Link to comment Share on other sites More sharing options...
mmurgas Posted November 29, 2013 Share Posted November 29, 2013 Ronny, how the server should consider action? , Must be installed excel? I'm trying to rule out activities, and I have the same code that I send me. Thank you very much for your help Link to comment Share on other sites More sharing options...
rencarnacion Posted December 1, 2013 Share Posted December 1, 2013 No you don't need to install excel in the server, you just only have to do is to create the template in excel then generate the report based on the template that you created Link to comment Share on other sites More sharing options...
mmurgas Posted December 5, 2013 Share Posted December 5, 2013 still the same ... What is your version of FLEXCEL? is shareware or is paid, I use one that goes down test (2010) to see if I served in unigui. Thanks for the help Link to comment Share on other sites More sharing options...
johnp Posted December 6, 2013 Share Posted December 6, 2013 I have used SMI import tools by Scalabium software for regular Delphi projects. Not sure if it will work here with UniGUI. SMI tools are very easy to use and have been very good for my needs. I will test in the upcoming weeks as my project also require this , unless someone else can comment. John P. Link to comment Share on other sites More sharing options...
mmurgas Posted December 7, 2013 Share Posted December 7, 2013 finally it works, the problem was that I had a test version and switch to the full version and all ok, I can say it works very well with FLEXCEL + unigui. Ronny Thanks for your help. Link to comment Share on other sites More sharing options...
rencarnacion Posted December 9, 2013 Share Posted December 9, 2013 You welcome !! I'm happy that It work good for you !! Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now