VB.net spreadsheet problem
j
Sterling Heights, MI Icrontian
Happy Thanksgiving everyone---
I'm creating a program that uses the axspreadsheet 11.0 COM. I can export data out to excel but I want to import data from excel. So in other words
The user opens an excel file(via opendialog) and in a text box it shows the location of the excel file (this I have working). I want to take what's in that excel file and display it in my spreadsheet. How do I do this?
j
I'm creating a program that uses the axspreadsheet 11.0 COM. I can export data out to excel but I want to import data from excel. So in other words
The user opens an excel file(via opendialog) and in a text box it shows the location of the excel file (this I have working). I want to take what's in that excel file and display it in my spreadsheet. How do I do this?
j
0
Comments
axSpreadSheet.XMLURL = "file:" + txtFileLoc.Text
were txtfileloc.text is the excel file. It has to be a xml format, but that's ok for now.
It loads in all info from the xml file.
If (Toilets == 0) then
Smelly_Mess.yuck=me.crap.brown.corn.liquid=true
else
Butt.batwings=true
Smelly_Mess.yuck=false
end if
But.Hair.crap.smoosh=But.batwing.skidmark
So by simple logic I rule and you all suck. The code never lies