I want to read data from excel file(2007).
files are in folder, I want to target some cells to pick data from them.
Kindly ! help me out !!
I use this code to read excel file, but I don't if it works in Excel 2007.
Dim myPath as String myPath = Request.MapPath(Request.ApplicationPath) & "\Upload\GCMS\" & FUAttach1.FileName Try Dim objDS As DataSet = New DataSet Dim objCmd As OleDbCommand Dim objAdapter As OleDbDataAdapter = New OleDbDataAdapter MyConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & myPath & ";Extended Properties=""Excel 8.0;IMEX=1;HDR=YES;""") MyConnection.Open() 'Select the data from Sheet1 of the workbook. objCmd = New OleDbCommand("select * from [Sheet1$]", MyConnection) objAdapter.SelectCommand = objCmd objAdapter.Fill(objDS, "XLData") If objDS.Tables("XLData").Rows.Count >= 1 Then Dim Tb As DataTable Tb = objDS.Tables("XLData") Dim Row As DataRow For Each Row In Tb.Rows If SetStringValue(Row.ItemArray(0).ToString) = "" Then Exit For End If Next Row End If MyConnection.Close() Catch ex As Exception End Try
Thanks Kusno for your reply...
I have tried some thing similar to it. I'm a C# fan but that doesn't matter here ... I think I'm having problem because of the excell 2007 release.
Lets hope any one else can help in this...
I have a code on excel, that will count the critera if there is more than one box filled out.
But now i am converting this code to jquery and i cannot figure it out.
on my page, there is a toggle button, yes/no selector for autopay, ...
I would like to know if this is an appropriate forum to ask these questions.
Website Example: http://www.shoparc.com
I would like create a similar site in WordPress. I have some experience with WordPress but would like to know:
What theme is this site using?
How would I create ...
OK, so HostGator for some reason no longer allows gcc/g++ access unless you have a Designated Server account, which is a lot of money to spend just to compile my "Hello World" program. Thus I figured I'd compile at home, then upload. Program is your regular old bare-bones Hello World ...