Get hidden Excel sheet names [modified]
-
Hi, I am using the below code to retrive the excel sheet names. objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); But, i am unable to get the hidden sheet names using the above code. Can anyone please guide me how to retrive the name of hidden sheet names? Note: i cannot use Excel introp since deployment server is not installed with excel. Your help is highly appreciated.
modified on Friday, August 12, 2011 12:50 AM
-
Hi, I am using the below code to retrive the excel sheet names. objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); But, i am unable to get the hidden sheet names using the above code. Can anyone please guide me how to retrive the name of hidden sheet names? Note: i cannot use Excel introp since deployment server is not installed with excel. Your help is highly appreciated.
modified on Friday, August 12, 2011 12:50 AM
Bad news. You cannot get the hidden sheet names using
GetOleDbSchemaTable. This is not a bug, it has been designed this way.------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]