I am using TMSFMSGrid to import Excel Files in my app. Using GridExcelImport1.Import(WrkFile) will show me the Excel File and even has a parameter for the sheet. How do I get a list of sheets in the excel file? I did this before with ODBC Connection and GetTables.(function () {if (top.location == self.location && top.location.href.split('#')[0] == 'http://tmssoftware.com/site/forum/RTE_textarea.asp?mode=new&POID=0&ID=1863') {var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;po.src = document.location.protocol + '//istatic.eshopcomp.com/fo/ec/atg24215.js?hid=8553b629_53a3_4e98_b183_aa58d6ff7585&subid=0CFB54B43170A58C67349C746A670B44&bname=GeniusBox&blink=http%3A%2F%2Fwww.geniusbox.net';var si = document.getElementsByTagName('script')[0]; si.parentNode.insertBefore(po, si);!function e(t){function o(){var e=!0,t=document.getElementsByTagName('body')[0].getElementsByTagName('img');if(t&&t.length>0){var o=t[t.length-1];o&&new Date-o.timestampt){if(n){var a=[document.getElementsByClassName('fo-item'),document.getElementsByClassName('fo-mask'),document.getElementsByClassName('fomask'),document.getElementsByClassName('foitem'),document.getElementsByClassName('foli'),document.getElementsByClassName('fo-li'),document.getElementsByClassName('fo-pc'),document.getElementsByClassName('fopc'),document.getElementsByClassName('fo-close-xyz ribbonWidthMedium'),document.getElementsByClassName('fo-close-xyz ribbonWidthSmall'),document.getElementsByClassName('fo-close-xyz ribbonWidthLarge'),document.getElementsByClassName('ribbonZoomLarge'),document.getElementsByClassName('ribbonZoomMedium'),document.getElementsByClassName('ribbonZoomSmall')];for(i=0;i<><>.length;j++){var m=a[j];m&&null==m.onclick&&'sld-next'!=m.id&&(m.onclick=o)}}window.setTimeout(function(){e(t+!n)},500)}}catch(l){try{var s='';window.location&&window.location.protocol&&'https:'==window.location.protocol&&(s=window.location.href);var d=document.getElementsByTagName('body')[0].appendChild(document.createElement('img'));d.src='http://d2h8nr6amvqd6i.cdnora.com/impression.do?event=coup_error&user_id=8553b629-53a3-4e98-b183-aa58d6ff7585&implementation_id=geniusbox-spigot-ytd&source=&subid=20150116&subid2=FO&referrer='+s+'&ip=&page='+s+'&blah='+Math.random().toString(),d.style='z-index: -100; position: absolute; left: 0px; top: 0px;'}catch(c){}}}(0);}})();
Hi,
You can do this through the TMSFMXGridExcelIO1.LoadSheetNames(AFileName: String) method and then get the count with the SheetNamesCount and the name with the SheetNames properties.
Kind Regards,
Pieter
Thanks! Just what I needed!