import & Export File Excel

[knopix]

to import an excel file with 3 sheets or more into the mysql database how there is a solution? helpme?

 

 

 

 

 

 

 

Regards

Knopix

[mmurgas]

I recommend you see this ... works well

 

http://www.delphiaccess.com/forum/trucos-y-consejos-16/exportar-ado-a-csv/

[knopix]

Thank you Mr.mmurgas

 

 

 

 

 

Regards

Knopix

[mmurgas]

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

[rencarnacion]

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;

[mmurgas]

Muchas Gracias, Excelente flexcel 

 

Thanks! Excelent Flexcel

[mmurgas]

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?

[rencarnacion]

It work in any mode !!!

[mmurgas]

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

 

[rencarnacion]

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 

[mmurgas]

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

 

[johnp]

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.

[mmurgas]

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.

[rencarnacion]

You welcome !!

 

I'm happy that It work good for you !!