在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屋！