10/20/2023 0 Comments Load kutools excelOnce the files have been extracted, continue with the instructions below. The attachment at the bottom of this article contains the examples referenced including the data:ĭownload the file and extract to the location of your choosing. More detailed information can be found within the help under: Node help > Input Connectors > Excel File This article is intended to help you get started by showing you three examples on how you can use the WorkbookSpec property in the Excel File node to take control of the data that you are reading in from an Excel workbook. However, there are times when we want to read in data from an Excel workbook that differs from this - for example, only include up to a particular row or perhaps it is a formatted report and we want to exclude the header rows. The Excel File node allows you to read in data from an Excel worksheet and defaults to reading the first worksheet from cell A1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |