{"title":"Read Excel Sheet Names","nodeType":"Source","id":"*pSZxsfdYwqHb7ecJ","factoryName":"org.knime.ext.poi3.node.io.filehandling.excel.sheets.ExcelSheetReaderNodeFactory","factoryId":"org.knime.ext.poi3.node.io.filehandling.excel.sheets.ExcelSheetReaderNodeFactory","path":["IO","Read"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node reads an Excel file and provides the contained sheet names at its output port.\n <br />\n The performance of the reader node is limited (due to the underlying library of the Apache POI project). Reading large files can take a long time.</p>\n            \n            <p><i>This node can access a variety of different</i> <a href=\"https://docs.knime.com/2021-06/analytics_platform_file_handling_guide/index.html#analytics-platform-file-systems\" rel=\"ugc nofollow noopener noreferrer\"> <i>file systems.</i> </a> <i>More information about file handling in KNIME can be found in the official</i> <a href=\"https://docs.knime.com/latest/analytics_platform_file_handling_guide/index.html\" rel=\"ugc nofollow noopener noreferrer\"> <i>File Handling Guide.</i> </a></p>\n            \n        \n        ","shortDescription":"Reads the sheet names contained in an Excel file.","keywords":["excel","sheet","read"],"deprecated":false,"streamable":true,"tags":["IO","Read","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAEeSURBVHgBpZBPTsJQEMa/V2nCqvQCFrUxsiFuVaJHMNxAI/sqO3fEtSHqDTxAD0EgwJpwACAcgLYHYJjX8Ejb9PH3l0zefPPa782MAHPhOC0+PjhspAlA9D+dz5vQcMY///D5yVHMuS9CiDu7VBJBGHbyDAyOV5lMZrM4FBn9Dg0F1fZttYrReIzvdhvcNlRtjb3NICaKIjzWauj1+7GWuaztwtBdWJaFfRC8RFJCzuz7PqIwxFujEY+guniu1/Md2GAhTRQyz+pr191oz/NSudzBH0frslxOGSf1ueNAO8K6i18+XpDZtmmauHJd3FQqOJhsq7rcwIkI3cXTwz1hDwo4gu5guHl42wiBpj5NCq0BLakJSn8sTQn0lSysAPummJvExkP3AAAAAElFTkSuQmCC","sinceVersion":"4.5.0","views":[],"inPorts":[],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"The sheet names contained in the workbook and the path to the workbook."}],"dynInPorts":[{"groupName":"File System Connection","groupDescription":"The file system connection providing access to the selected file(s).","types":[{"objectClass":"org.knime.filehandling.core.port.FileSystemPortObject","color":"178ba5","dataType":"File System"}]}],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Type","description":"The selection mode.\n<ul><li><b>File</b> : Select a single file.</li><li><b>Files in folders</b> : Select a folder and apply filters to select files within it.</li></ul>","optional":false},{"name":"Source","description":"The path to the file or folder to select.","optional":false},{"name":"Include subfolders","description":"Whether to include subfolders when selecting multiple files within a folder.","optional":false},{"name":"Filter by file extension","description":"Enable filtering files by their extension (e.g. &#39;xlsx;xlsm&#39;).","optional":false},{"name":"File extensions","description":"Semicolon-separated list of file extensions to include (e.g. &#39;xlsx;xlsm;xls&#39;). Case-insensitive unless &#39;Case sensitive (extensions)&#39; is enabled.","optional":false},{"name":"Case sensitive (extensions)","description":"Treat the entered extensions as case sensitive when matching.","optional":false},{"name":"Filter by file name","description":"Enable filtering by file name pattern with wildcards or regular expression.","optional":false},{"name":"File name filter pattern","description":"Pattern for file name filtering. With type &#39;Wildcard&#39;, use &#39;*&#39; and &#39;?&#39;. With type &#39;Regex&#39;, enter a Java regular expression.","optional":false},{"name":"File name filter type","description":"Choose how to interpret the file name pattern: wildcard or regular expression.","optional":false},{"name":"Case sensitive (names)","description":"Make file name filtering case sensitive.","optional":false},{"name":"Include hidden files","description":"Include hidden files in the selection.","optional":false},{"name":"Include special files","description":"Include special file types (workflows etc).","optional":false},{"name":"Filter by folder name","description":"Enable filtering of folders by name pattern before descending into them.","optional":false},{"name":"Folder name pattern","description":"Pattern for folder name filtering. Use &#39;*&#39; and &#39;?&#39; with filter type &#39;Wildcard&#39;. With type &#39;Regex&#39;, enter a Java regular expression.","optional":false},{"name":"Folder name filter type","description":"Choose how to interpret the folder name pattern: wildcard or regular expression.","optional":false},{"name":"Case sensitive (folders)","description":"Make folder name filtering case sensitive.","optional":false},{"name":"Include hidden folders","description":"Descend into folders that are hidden (if they otherwise pass filters).","optional":false},{"name":"Follow symlinks","description":"Follow symbolic links while traversing folders (only relevant when selecting a folder).","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:53246a80-8710-4732-be1f-f22ddbf546f0","user":"heather_fyson","date":"2021-02-12T11:13:03+00:00"}],"kudosCount":1,"bundleInformation":{"bundleVersion":"5.12.0.v202604281119","bundleName":"KNIME POI (Excel) Plug-in","bundleSymbolicName":"org.knime.ext.poi3","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.ext.poi","featureName":"KNIME Excel Support","featureVersion":"5.12.0.v202605041104","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*ei_rc2H2e57n_qvV"},"frequentSuccessors":[]}