Solved

Delphi/Excel connection problems

Posted on 2007-11-17
2
430 Views
Last Modified: 2010-04-05
I am connecting through ADO Connection and Query to Excel workbook. I have two problems.


1/ The Excel workbook comes to me with spaces in the column titles. Within Delphi is it possible to delete the spaces or change the column names?

2/Having changed the Excel column names manually, I am able to connect and sort the workbook sheets. The workbook appears in a connected DBGrid. However, when I run the following code adoquery1.first; X:=adoquery1['fieldname'].Asstring; label1.caption:=x; I get the following error "Variant does not reference an automation Object' So I need solutions to these two problems, please.
0
Comment
Question by:nicholasjfox
2 Comments
 
LVL 25

Accepted Solution

by:
imitchie earned 50 total points
ID: 20306391
var columnname: string;
columnname := Trim(columnname);  // will remove spaces before and after

X:=adoquery1['fieldname'].Asstring  << error, use either
X:=adoquery1['fieldname']  or   X:=adoquery1.FieldByName('fieldname').AsString
the square brackets return a Variant right away, so no need for AsString.
0
 

Author Comment

by:nicholasjfox
ID: 20306962
Sorry I should have said the spaces in the column names are in the middle, ie "Test Results". I can't seem to do anything with the table unless I manually delete the spaces to make
"testresults".
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi TcxGrid group footer summary 3 267
error 1.1 400 Bad request idhttp delphi 18 87
Delphi problems to abort a printjob 9 19
Delphi: sending SMS on android platform 1 21
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…
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

770 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