All Forums  Origin Forum for Programming  LabTalk Forum  excel sheetname detection

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by onceagain[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): 2017 Operating System: win7-msoffice2016 When opening an excel file(document -append; but also as "open excel...") with multiple worksheets, only the active sheet is detected (as per list in right-click workbook->properties). However, I need to adress the other different sheets by name as well ([workbook]sheetname!cell(x,y)) but cannot, since they do not exist for origin until I manually activate and right-click "update origin" to get them listed with their name and index @number. Is there a basic import option I am missing or what would be the correct workaround for labtalk to activate and update to get all sheets listed? [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.