Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#
ExcelConnString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filePath + ";Mode=ReadWrite;Extended Properties=\"Excel 12.0 Xml;HDR=YES\""; 

DataTable DtSheetName = new DataTable();
                
   DtSheetName = oledbconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);


In DtSheetName i get the names of sheets in workbook.But also the names which i have renamed for example-'alert' sheet i have renamed to 'messeges'.So i should get only messeges in DtSheetName .But i am getting both alert and messeges.Is there any way to get rid of the renames sheet names?
Help Me..
Posted
Updated 29-May-15 4:25am
v3
Comments
Richard MacCutchan 29-May-15 12:25pm    
I have just tried this and I am not able to reproduce the problem you describe. Is there any more information you can provide?
ZurdoDev 29-May-15 13:24pm    
I remember Excel 97 or 2000 had this issue. What version are you using? I think they fixed it years ago though.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900