change sheet name in excel

• afgone

  SSCommitted

  Points: 1551

  More actions

  July 2, 2008 at 6:37 am

  #123602

  hi,

  I have created a import process, using loop to load multiple files. now the files are supplied using different sheet names e.g. 7, 8, 9 etc.

  now when loading, i have chosen the sheet name to be 8$ in data import. this gives me error if sheetname is 7 or 9.

  would i be able to set the sheet name to my desired one using script. so whenever it loops a file if it is different number it should set it to 8$ then load it. or do i have to change the name of the sheet in excel manually.

  thanks

• afgone

  SSCommitted

  Points: 1551

  More actions

  July 2, 2008 at 8:35 am

  #837281

  let me refrase it.....

  when i am loading multiple files if the sheetname is not constant then the package fails.

  is there a way to set that dynamically.

  thanks