Solved

How to Use MS Excel and Delphi 4

Posted on 1999-01-19
3
132 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
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
inthe earned 10 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Printing problem 2 102
tidtcpserver connection lost handle 2 102
Not able to call Delphi XE10 dll function from Delphi 6.0 4 37
Wincontrol not (correctly) drawn 15 40
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 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