{"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":[],"_links":{"self":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/posts\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/comments?post=37"}],"version-history":[{"count":0,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/posts\/37\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/categories?post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuangzr.me\/wordpress\/wp-json\/wp\/v2\/tags?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}