I'm importing an excel sheet through an FTP connector. I only need it to process the data on the first sheet of the excel file. Is there a way to make sure that it only pulls data from a specific sheet of an excel document?
@jackharris so you're trying to create an Excel file on an FTP or you're trying to pull data from an Excel file sitting on an FTP? If you're pulling a file, it looks like we pull the first sheet that's there and there isn't an option to pull from a specific sheet or from anything other than the first sheet listed.
When I originally wrote this, I didn't think it was pulling from just the first page because the resulting data had information on it that was only on the second sheet and not the first so I was trying to make sure that it only grabbed the data on the first page.
@jackharris gotcha. When I just tested, it was only pulling the first sheet. I then moved my sheet positions and tried again and it pulled the first sheet again, but with the different data. If you're seeing it pull data from anything other than the first sheet, let me know.