Export file Excel use Active Report

1.00/5 (1 vote)

See more:

Hi everyone !
I have problem with ActiveReport, when i export file excel then rows or columns askew designe, i don't know why, please help me. Thank very much

This is my code:

DataDynamics.ActiveReports.Export.Xls.XlsExport xls = new DataDynamics.ActiveReports.Export.Xls.XlsExport();
                    xls.AutoRowHeight = true;
                    xls.DisplayGridLines = true;
                    xls.FileFormat = DataDynamics.ActiveReports.Export.Xls.FileFormat.Xls97Plus;                 
                    xls.MultiSheet = true;
                    xls.RemoveVerticalSpace = true;  
                    xls.UseCellMerging = true;           
                    
                    xls.Export(this.viewer1.Document, "Myexcel.xls");

Posted 14-Sep-14 17:26pm

Member 10338650

Updated 14-Sep-14 18:33pm

CPallini

Add a Solution

Comments

Sergey Alexandrovich Kryukov 14-Sep-14 23:30pm

Not clear. What happens?
—SA

Member 10338650 15-Sep-14 2:50am

yeah, that mean, i used active report to design a report, then i exported it to excel, the file excel not true form which i designed, the rows askew. Do have properties to set cells same designer?
Please help me, thank very much !

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Richard MacCutchan	65
Graeme_Grant	60
Richard Deeming	55
Dave Kreskowiak	50
Rick York	50

Pete O'Hanlon	1,820
OriginalGriff	1,355
Graeme_Grant	895
Richard Deeming	798
Dave Kreskowiak	684

Export file Excel use Active Report

Add your solution here

Preview 0

Export file Excel use Active Report

Add your solution here

Preview 0

Existing Members

...or Join us