Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: sfx dunoo
  
 
 
 sfx dunoo
 To: sfx dunoo
  
 
 
 sfx dunoo
 Tags
Subject: RE: excel automation
Thread ID: 77975 Message ID: 78680 # Views: 2 # Ratings: 0
Version: Not Applicable Category: Microsoft Office Automation
Date: Thursday, October 6, 2005 8:29:02 PM         
   


Dan, Ken, Yuri,

I think, that I'll be using the best of (both) three worlds :

- excel automation
- ken's suggestion with the data (remote input form)
- yuri's advice about usedrange object... (I didn't know this)


thank you very much for your answers and assistance.


Sven






> Hello All,
>
> I need to write an import routine for excel files.
> Actually, all data is delivered by means of excel.
>
> Sometimes the header rows are available and sometimes they're incomplete.
>
> What I want to know is :
>
> how can I extract the header row information (column A = licence, column B = fleetnumber, column C = color)
>
> The software I write, knows there is information in column A (for the user, this looks like 'Licence')
> and I can assign this to a database field in my database.
>
> So :
>
> column A = Licence -> let the user assign this column to DATABASE.Licence
> column B = Color -> let the user assign this column to DATABASE.Color
>
> I need to find out how I can get the contents of specific fields, and if there is a way to find out (using automation) what the max number of cols is and read out their values.
>
> Can anybody help me out here ?
>
> Thanks in advance,


ENTIRE THREAD

excel automation Posted by sfx dunoo @ 9/24/2005 11:41:20 PM
RE: excel automation Posted by sfx dunoo @ 9/27/2005 10:04:03 PM
RE: excel automation Posted by Yuri Rubinov @ 9/27/2005 10:23:50 PM
RE: excel automation Posted by sfx dunoo @ 10/2/2005 9:14:37 PM
RE: excel automation Posted by Ken Murphy @ 10/3/2005 2:09:30 PM
RE: excel automation Posted by Yuri Rubinov @ 10/3/2005 3:49:22 PM
RE: excel automation Posted by Ken Murphy @ 9/28/2005 3:55:32 PM
RE: excel automation Posted by dan delpuerto @ 10/6/2005 5:32:41 PM
RE: excel automation Posted by sfx dunoo @ 10/6/2005 8:29:02 PM