使用crystal report（ExportFormatType.ExcelRecord）在导出DATA时仅动态设置列宽，以便在c＃中出色

问题描述

我使用下面的代码



//声明变量并获取导出选项。

ExportOptions exportOpts = new ExportOptions（） ;

ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions（）;

DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions（）;

exportOpts = rpt.ExportOptions;



//设置excel格式选项。

excelFormatOpts.ExcelConstantColumnWidth = 100;

excelFormatOpts.ExcelUseConstantColumnWidth = true;

exportOpts.ExportFormatType = ExportFormatType.ExcelRecord;

exportOpts.FormatOptions = excelFormatOpts;



//设置磁盘文件选项和导出。

exportOpt s.ExportDestinationType = ExportDestinationType.DiskFile;

diskOpts.DiskFileName = strFilename;

exportOpts.DestinationOptions = diskOpts;



rpt.Export（）;





问题：



现在我需要格式化。我想在excel中设置列宽。



我可以这样做吗？



来自我的上面代码下面的行似乎不起作用



excelFormatOpts.ExcelConstantColumnWidth = 100;

excelFormatOpts.ExcelUseConstantColumnWidth = true;



我很欣赏这方面的任何帮助，因为这个问题正在耗费我的时间。



感谢您提前提供任何帮助。

I am using the below code

// Declare variables and get the export options.
ExportOptions exportOpts = new ExportOptions();
ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
exportOpts = rpt.ExportOptions;

// Set the excel format options.
excelFormatOpts.ExcelConstantColumnWidth = 100;
excelFormatOpts.ExcelUseConstantColumnWidth = true;
exportOpts.ExportFormatType = ExportFormatType.ExcelRecord;
exportOpts.FormatOptions = excelFormatOpts;

// Set the disk file options and export.
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
diskOpts.DiskFileName = strFilename;
exportOpts.DestinationOptions = diskOpts;

rpt.Export();


Question:

Now I need to format. I want to set column width in the excel.

Can I do it?

From my above code the below lines seems not to function

excelFormatOpts.ExcelConstantColumnWidth = 100;
excelFormatOpts.ExcelUseConstantColumnWidth = true;

I appreciate any help in this regard as this issue is eating my time.

Thank you for any help in advance.

推荐答案

这篇关于使用crystal report（ExportFormatType.ExcelRecord）在导出DATA时仅动态设置列宽，以便在c＃中出色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！