将cystal报告转换为excel格式的excel [英] Convert cystal report to excel in excel format

问题描述

您好b $ b

我正在使用此代码。

Hi
I am using this code.

ExportOptions exportOpts = new ExportOptions();
  ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions();
  DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
  exportOpts = _myReport.ExportOptions;
  excelFormatOpts.ExcelUseConstantColumnWidth = true; // Setting column width constant
  exportOpts.ExportFormatType = ExportFormatType.Excel;
  exportOpts.FormatOptions = excelFormatOpts;
  // Set the disk file options and export.
  exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
  diskOpts.DiskFileName = "D:\\RnD\\abc.xls";
  exportOpts.DestinationOptions = diskOpts;
  _myReport.Export();

这里我得到的列具有恒定的宽度。但是我也需要保持行。

最后我必须用网格线显示恒定的宽度和行。



任何帮助表示感谢！

Here I am getting columns are having constant width. But I need to maintain rows as well.
Finally I have to display constant width and rows with grid lines.

Any help appreciated!

推荐答案

如何以excel格式或excel表格导出水晶报表数据 [ ^ ]



http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports- export-excel.htm [ ^ ]



检查链接......这些可以帮助你...

How to export crystal report data in excel format or in excel sheet[^]

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-export-excel.htm[^]

check the links..these may help you...

这篇关于将cystal报告转换为excel格式的excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！