Haenschenklein3456
Materials
- Oct 13, 2006
- 1
Hi everybody,
I am creating a tool that needs to read (see above) from excel-files with up to 16 worksheets. The number varies from file to file.
-I want to type the filename only once
-I want to auto-detect the number of sheets or
-I want to select the number of sheets manually (the area to read from ist the same in every sheet) and not to tye/copypaste 16 times the same area in the import-assistant.
So I do not want so use the excel component or the import-assistant.
The readfile-fuction seems to accept argument for rows and columns but not for sheets?
Did that problem occur somewhere else?
If no-one knows, the posibility remains, to split the excel-file in up to 16 smaller files with only one sheet each. Does anyone know how to do that?
Thx!
I am creating a tool that needs to read (see above) from excel-files with up to 16 worksheets. The number varies from file to file.
-I want to type the filename only once
-I want to auto-detect the number of sheets or
-I want to select the number of sheets manually (the area to read from ist the same in every sheet) and not to tye/copypaste 16 times the same area in the import-assistant.
So I do not want so use the excel component or the import-assistant.
The readfile-fuction seems to accept argument for rows and columns but not for sheets?
Did that problem occur somewhere else?
If no-one knows, the posibility remains, to split the excel-file in up to 16 smaller files with only one sheet each. Does anyone know how to do that?
Thx!
