{"id":37,"date":"2012-04-11T22:10:27","date_gmt":"2012-04-11T14:10:27","guid":{"rendered":"http:\/\/fishinbox.tk\/?p=37"},"modified":"2012-04-11T22:10:27","modified_gmt":"2012-04-11T14:10:27","slug":"excel-add-in-for-excel-2007-and-2010","status":"publish","type":"post","link":"https:\/\/zhuangzr.me\/wordpress\/2012\/04\/excel-add-in-for-excel-2007-and-2010\/","title":{"rendered":"Excel Add-in for Excel 2007 and 2010"},"content":{"rendered":"

Tonight I made great effort to this project which is an excel add-in for easy adding titles to the mass content. The add-in is developed under Visual Studio 2010 with Visual Studio Tools for Office in C# (CSharp), and it may need .Net Framework 4 Client Profile and\u00a0Visual Studio Tools for Office Runtime.<\/p>\n

Download the Excel Add-in<\/a><\/p>\n

Here’s the situation. You have the table like this:<\/p>\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
<\/td>\nTitle B1<\/td>\nTitle C1<\/td>\nTitle D1<\/td>\n<\/tr>\n
<\/td>\nTitle B2<\/td>\nTitle C2<\/td>\nTitle D2<\/td>\n<\/tr>\n
Content Index 1<\/td>\nvarious content<\/td>\nvarious content<\/td>\nvarious content<\/td>\n<\/tr>\n
Content Index 2<\/td>\nvarious content<\/td>\nvarious content<\/td>\nvarious content<\/td>\n<\/tr>\n
\u2026<\/td>\n\u2026<\/td>\n\u2026<\/td>\n\u2026<\/td>\n<\/tr>\n
Content Index n<\/td>\nvarious content<\/td>\nvarious content<\/td>\nvarious content<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

and you would like it to be something like this:<\/p>\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nTitle B1<\/td>\nTitle C1<\/td>\nTitle D1<\/td>\n<\/tr>\n
<\/td>\nTitle B2<\/td>\nTitle C2<\/td>\nTitle D2<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Content Index 1<\/td>\nvarious content<\/td>\nvarious content<\/td>\nvarious content<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nTitle B1<\/td>\nTitle C1<\/td>\nTitle D1<\/td>\n<\/tr>\n
<\/td>\nTitle B2<\/td>\nTitle C2<\/td>\nTitle D2<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Content Index 2<\/td>\nvarious content<\/td>\nvarious content<\/td>\nvarious content<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u2026<\/td>\n\u2026<\/td>\n\u2026<\/td>\n\u2026<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nTitle B1<\/td>\nTitle C1<\/td>\nTitle D1<\/td>\n<\/tr>\n
<\/td>\nTitle B2<\/td>\nTitle C2<\/td>\nTitle D2<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Content Index n<\/td>\nvarious content<\/td>\nvarious content<\/td>\nvarious content<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Then this Excel Add-in would help you a lot from copying n pasting n coping n pasting…<\/p>\n

Hope you enjoy it!\u00a0Good night world!<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Tonight I made great effort to this project which is an excel add-in for easy adding titles to the mass content. The add-in is developed under Visual Studio 2010 with Visual Studio Tools for Office in C# (CSharp), and it may need .Net Framework 4 Client Profile and\u00a0Visual Studio Tools for Office Runtime. Download the … <\/p>\n

Continue reading “Excel Add-in for Excel 2007 and 2010”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[29,31,50],"class_list":["post-37","post","type-post","status-publish","format-standard","hentry","category-csharp-programming","tag-csharp","tag-excel","tag-vsto"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t