在excelsheet中为列标题添加粗体选项卡 [英] Make column headings Bold for tab in the excelsheet
问题描述
我已经将数据从sql加载到excel表,基于经理ID我已经在不同的标签上加载了数据。
为此我创建了列名的temaplate,首先我删除了目标文件并从模板文件中复制了列名。
现在我的要求是:我想要为excelsheet中的每个标签创建列标题?
请尽快告诉我任何身体。
Arun
这将需要脚本任务中的.net脚本,并引用Microsoft.Office.Interop .Excel ...这意味着你需要在运行软件包的机器上安装办公室....微软不推荐/不支持。
http://support.microsoft.com/kb/257757?wa=wsignin1.0
如果您仍然需要大胆的标题,那么您可能会在Excel论坛中获得更好/更快的答案:
http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads
Hi,
I have loading the data from sql to excel sheet,based on manager id I have loading the data on different tabs.
For this I have created the temaplate for column names,first i have delete the destination file and copy the column names from template file.
Now my requirement is :I want to Make column headings Bold for each tab in the excelsheet ??
Could you kindly let me know any body ASAP.
Arun
This will require .net scripting in a Script Task with a reference to Microsoft.Office.Interop.Excel... which means you need office installed on the machine that runs the package.... which is not recommended / supported by Microsoft. http://support.microsoft.com/kb/257757?wa=wsignin1.0
If you still want the bold headings, then you would probably get better/faster answers in the Excel forum:
http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads
这篇关于在excelsheet中为列标题添加粗体选项卡的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!