Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to Use MS Excel and Delphi 4

Posted on 1999-01-19
3
Medium Priority
?
139 Views
Last Modified: 2010-04-06
If i make an BDE alias, which is pointing to an MyBook.xls
How can i use it(MyBook.xls) in Delphi for database.
I get stuck when i'm supposed to give a table name (property of TTable object)
0
Comment
Question by:K_David
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
inthe earned 30 total points
ID: 1362453
Excel files will not appear in the TTable.TableName property
drop-down so to work around this you have to enter the worksheet file name with no extension followed by a $ in the TableName property.
You can also add a cell range. example MyBook$A2:F1000
To read all of the rows in the worksheet when specifying a cell range make the ending row number larger than the last possible row.
Regards Barry
0
 

Author Comment

by:K_David
ID: 1362454
If i use that, then GetFieldName will work propperly (can i read/write to this cell range?)
Thanx

0
 
LVL 17

Expert Comment

by:inthe
ID: 1362455
hi,
to be honest i am not sure but i dont see why not .i had to do a bit of digging to get the answer for you as i dont know much on using excel like this.i only got the above from a teamb member and that was all i could find
Regards Barry
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question