OleDbDataReader dr = new OleDbCommand("SELECT * FROM ", objConn). OleDbConnection objConn = new OleDbConnection(sConnectionString) SConnectionString = "Provider=.12.0 " "Data Source=" tempFile " " "Extended Properties=\"" FileType "HDR=No IMEX=0 \"" Only whole rows or columns can be frozen. Get the version for Office 2007 ( ) if you have 32bit System, or use Office 2010 BETA version (compatible with 2007) for 64bit - īelow is an extract from my project to help you: string sConnectionString = "" Frozen cells are rows or columns that remain visible while you scroll through a worksheet.1 X Research source If you want column headers or row labels to remain visible as you work with large amounts of data, youll likely find it helpful to lock those cells into place.
0 Comments
Leave a Reply. |