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
Post a Comment