Hi All -
I need to grab the headings off an xls sheet then display the headers in a listbox. The file location and sheet name of the xls will be pre-defined. The column headers will always be in Row 1. The number of headers will vary, depending on the xls.
I was able to do this in VB6 but need to re-write as C# - here's VB6 solution:
______
Private Sub XLSHeaderImport()
On Error GoTo import_error
dim sSql as String
dim SheetName as String
SheetName = "Sheet1"
With oConn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Extended Properties").Value = "Excel 8.0"
.Open mstrFile, , , -1
' mstrFile is the xls file location defined by user with Common Dialog
End With
sSql = "SELECT * From [" & SheetName & "$]"
oRS.Open (sSql), oConn, adOpenStatic
Dim fld As ADODB.Field
For Each fld In oRS.Fields
' add item to list box
frmMatching.ListXLS.AddIte
Next
oRS.Close
End Sub
______
Any thoughts?
Rachael
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi rajaloysious -
The build is returnng the error:"Type or namespace 'Server' could not be found (missing a using directive or assembly refernce)"
at:
"Data Source=" + Server.MapPath("../ExcelDa
I tried replacing this with the datasource hard coded:
"Data Source=T:\DB_DEVELOPMENT\c
this returns the error: "Unrecongnized escape sequence"
help :-)
http://authors.aspalliance
You should include this in the declarations section
using System.Web ;
http://authors.aspalliance
The methods and properties of the HttpServerUtility class are exposed via the intrinsic Server object.
unfortunately i dont have access to any webserver to experiment..
cheers
Business Accounts
Answer for Membership
by: rajaloysiousPosted on 2005-08-24 at 02:06:30ID: 14740724
should be quite simple - )
see here for more info -- http://support.microsoft.c
below is the code you need...
cheers
using System.Data.OleDb;
using System.Data;
// parameter as appropriate for your environment.
String sConnectionString = "Provider=Microsoft.Jet.OL
"Data Source=" + Server.MapPath("../ExcelDa
"Extended Properties=Excel 8.0;";
// Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(sConnectio
// Open connection with the database.
objConn.Open();
// The code to follow uses a SQL SELECT command to display the data from the worksheet.
// Create new OleDbCommand to return data from worksheet.
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM myRange1", objConn);
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;
// Create new DataSet to hold information from the worksheet.
DataSet objDataset1 = new DataSet();
// Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(objDatase
// Bind data to DataGrid control.
DataGrid1.DataSource = objDataset1.Tables[0].Defa
DataGrid1.DataBind();
// Clean up objects.
objConn.Close();