从水晶报表导出到excel时显示网格线 [英] Show gridlines when export from crystal report to excel
问题描述
我正在研究水晶报告10.5。我将数据从CR导出到excel。问题是,数据导出到excel后,列之间的网格线丢失了。有没有办法用excel中的网格线显示数据?此外,从CR导出数据后,是否有可能在Excel中更改
列宽?
I m working on crystal reports 10.5. I m exporting data from CR to excel. Issue is, grid lines between the columns are missing after data is exported to excel. Is there any way to show the data with gridlines in excel? Also, is there any possiblity of changing column width in excel after data is exported from CR?
谢谢,
Balaji Gurunathan
Balaji Gurunathan
推荐答案
嗨Balaji,
Hi Balaji,
使用此:
CrystalDecisions.Shared.ExcelFormatOptions XLSFormatOptions = new CrystalDecisions.Shared.ExcelFormatOptions();
XLSFormatOptions.ShowGridLines = true;
CrystalDecisions.Shared.ExcelFormatOptions XLSFormatOptions = new CrystalDecisions.Shared.ExcelFormatOptions();
XLSFormatOptions.ShowGridLines = true;
它在CR 2008中但不确定它是否在VS Basic for VS 2008中可用。在包含CrystalDecisions.Shared之后使用对象浏览器你的参考。如果它在那里它应该工作。
It's in CR 2008 but not sure if it's available in CR Basic for VS 2008. Use the object browser after including CrystalDecisions.Shared in your references. If it's there then it should work.
唐
这篇关于从水晶报表导出到excel时显示网格线的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!