Jump to content

Reading Excel

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
3 replies to this topic

#1
Xystus777

Xystus777

    Learning Programmer

  • Members
  • PipPipPip
  • 59 posts
Hello everyone. This may be a simple task, but I haven't the slightest clue how to accomplish it.

If I already have an excel document with data in the cells...

How can I take the data in ONE cell, and put it into a STRING on my form for future use?

Thanks!

#2
Xav

Xav

    Writes binary right handed and hex left handed

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 13,118 posts
There are two ways you can do this.

The first, difficult, slow way is to directly connect to Excel and grab the data.

The easy and quick way is to save the data in a CSV file instead of an XLS file. You can then read in the data and parse it out.
Jordan said:

Good members, like yourself, stick around and post for ages to come!
Mr. Xav | Blog | Forums

#3
Xystus777

Xystus777

    Learning Programmer

  • Members
  • PipPipPip
  • 59 posts
I'll look into those, thanks Xav. I'll do some research. Read my newest thread, it's kinda long, but with pictures!

#4
Xav

Xav

    Writes binary right handed and hex left handed

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 13,118 posts
OK, I will. Good luck, and if you need anything, just ask!

I made a tutorial once about reading files (text files, which CSV files essentially are). See if you can find it in the Tutorials section.
Jordan said:

Good members, like yourself, stick around and post for ages to come!
Mr. Xav | Blog | Forums