Avoid adding sheetname to filename
Forums
I have the current import script:
Sub Main
Call ExcelImport()
End Sub
Function ExcelImport
Set task=Client.GetImportTask("ImportExcel")
dbName="C:\Desktop\myfile.xlsx"
task.FileToImport=dbname
task.SheetToImport="Sheet1"
task.OutputFilePRefix="Test"
task.FirstRowlsFieldName="True"
task.EmptyNumericFieldAsZero="True"
task.PerformTask
Set task=Nothing
End Function
This creates a Test-Sheet1 file, so Test-Sheet1.IMD. However, I do not want that "Sheet1" is added. I played around with it, but could not figure out how to avoid that Sheet1 is added (or some other string in case I would like to set it to something like "Sh1"). So I could not find the option to set this. How can I do this? Of course I could use a workaround later on to manipulate the file name, but this is extra work and I thought this should be possible.
Thanks for the help.
I just noticed the answer to
I just noticed the answer to my question in this thread:
http://ideascripting.com/forum/importing-excel-spreadsheet
So I guess it is still not possible without workaround.
The only way to do this is to