Page 1 of 1
Excel Sheet-name check
Posted: Wed Aug 03, 2016 9:08 am
by Marc Vanzegbroeck
Hi,
How can I check if a sheet with a specific name exist in an excel workbook, and select it, if exist?
If not exist, I need to do something else..
Re: Excel Sheet-name check
Posted: Wed Aug 03, 2016 9:46 am
by hmpaquito
Marc,
Try so, (no tested)
Code: Select all
FUNCTION ExcelSheetNames(oExcel)
Local aNames:= {}
Local nLen:= oExcel:WorkSheets:Count
Local cName
FOR nI:= 1 TO nLen
cName:= oExcel:WorkSheets(nI):Name
Aadd(aNames, cName)
NEXT
RETURN aNames
Regards
Re: Excel Sheet-name check
Posted: Wed Aug 03, 2016 9:55 am
by Marc Vanzegbroeck
Thank you. With the loop into the worksheets, I can test if a sheet exist.
Now It's working fine
hmpaquito wrote:Marc,
Try so, (no tested)
Code: Select all
FUNCTION ExcelSheetNames(oExcel)
Local aNames:= {}
Local nLen:= oExcel:WorkSheets:Count
Local cName
FOR nI:= 1 TO nLen
cName:= oExcel:WorkSheets(nI):Name
Aadd(aNames, cName)
NEXT
RETURN aNames
Regards