Export to Excel without Excel

[adragan]

To all tortured soles that have to fulfill the Excel dependent customer demands, I found this on the net.

 

To my amazement , it works !

 

http://blog.runbits.com/post/Native-Export-XLS-without-excel-Delphi.aspx

 

 

Have fun !

 

[mehmet07]

yes working. i use 2 project.

[Abaksoft]

Big thanks adragan

[Kanat]

To all tortured soles that have to fulfill the Excel dependent customer demands, I found this on the net.

 

To my amazement , it works !

 

http://blog.runbits.com/post/Native-Export-XLS-without-excel-Delphi.aspx

 

 

Have fun !

 

Please, can make a demo project.

I can not do.

[adragan]

It seems I was to optimistic about "working" export to Excel.

There is a problem with exporting long integers so , if you have id-s in the 100000

range or more that you want exported , first cast them as strings.

 

As for a demo, it couldn't be simpler :

 

uses uNativeXLSExport;

..................

 

procedure TUniMainModule.ExportExcel(ADataSet:TDataSet);
  var
           fname:string;
  begin
  fname := UniServerModule.LocalCachePath + 'E' + FormatDateTime('hhmmss', Now()) + '.xls'; // Create a unique name for report.
  DataSetToXLS(ADataSet, fname);
  UniSession.SendFile(fname);
  end;
 

[mehmet07]

Hi,

how excel row color change at uNativeXLSExport?

[picyka]

Hello, anyone using this class? if so, does it open normally through google docs?

[picyka]

https://github.com/rareMaxim/Excel4Delphi/tree/master/source