[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

Reading from excel?

How do I read from Excel? I need to be able to pick only certain column and ignore other comlumns.  
0
sbetts
Asked:
sbetts
1 Solution
 
dhaineaultCommented:
A good place to start would be to visit this "File Formats" site.  I'm sure you'll find the necessary information for reading Excel spreadsheets.

http://www.wotsit.org/
0
 
Brain2000Commented:
Do you want to be able to read an Excel file, or actually read from Excel if it is running?  If it's running, you can use DDE to request information from it.
0
 
mwimerCommented:
Try File->open and select the file you wish to "read from Excel"  Excel with then "read" in this file.

Using the mouse highlight the columns you wish to ignore. Then hit the delete key.

Click ok.

BOOM!  Problem solved, tho' it sure doesn't seem to be a c question.
0

Featured Post

Will You Be GDPR Compliant by 5/28/2018?

GDPR? That's a regulation for the European Union. But, if you collect data from customers or employees within the EU, then you need to know about GDPR and make sure your organization is compliant by May 2018. Check out our preparation checklist to make sure you're on track today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now