c# - Enable Excel "View Side by Side" and "Synchronous Scrolling" -


i created c# program opens 2 excel worksheets ex:

process.start(@"c:\test\test1.xlsx"); process.start(@"c:\test\test2.xlsx"); 

all want after opening excel these 2 sheets enable "view side side" , "synchronous scrolling". these 2 options under view tab. enable them manually, love have option enabled automatically. have idea how achieve this? thank in advance.

you can use automation c# control excel application.

create reference excel application , open both workbooks. there should simple matter of writing code enable "side side" view:

windows.comparesidebysidewith "test1" windows.syncscrollingsidebyside = true 

Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -