VB.net spreadsheet problem

jj Sterling Heights, MI Icrontian
edited November 2006 in Internet & Media
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

Comments

  • jj Sterling Heights, MI Icrontian
    edited November 2006
    I found it.

    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.
  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited November 2006
    yay for you
  • ThraxThrax 🐌 Austin, TX Icrontian
    edited November 2006
    Is this what he does when he's not getting excited about IR toilet flush sensors?
  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited November 2006
    yeah, that's about right :rolleyes:
  • jj Sterling Heights, MI Icrontian
    edited November 2006
    Hey, toilets are cool. With out them it would a grand old mess. or in other words

    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
  • ThraxThrax 🐌 Austin, TX Icrontian
    edited November 2006
    They said that about the matrix.
  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited November 2006
    butt hair crap smoosh? nice.
Sign In or Register to comment.