For Programmers: Free Programming Magazines  


Home > Archive > ASP > February 2006 > Reading data from excel









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Reading data from excel
thysonj@hotmail.com

2006-02-21, 6:55 pm

I know the basic way of doing this when you have a static set of
spreadsheets but I need to be able to process different spreadsheets
every day. These spreadsheets are sent to us by an outside auditing
firm without named ranges. They have a consistent format. Is there a
way to read a specific set of cells without having a named range? Or
is there a way to name a range with ASP? I am open to any options
here. Going through and creating named ranges is the only thing that
wont work sicnce it would take more work than processing the files by
hand.

McKirahan

2006-02-21, 6:55 pm

<thysonj@hotmail.com> wrote in message
news:1140543041.049941.96960@g14g2000cwa.googlegroups.com...
> I know the basic way of doing this when you have a static set of
> spreadsheets but I need to be able to process different spreadsheets
> every day. These spreadsheets are sent to us by an outside auditing
> firm without named ranges. They have a consistent format. Is there a
> way to read a specific set of cells without having a named range? Or
> is there a way to name a range with ASP? I am open to any options
> here. Going through and creating named ranges is the only thing that
> wont work sicnce it would take more work than processing the files by
> hand.


http://www.aspfaq.com/5003


thysonj@hotmail.com

2006-02-21, 6:55 pm

I accidently posted it in the wrong forum. Chill.

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com