Alaska Software Inc. - Name of the sheets with sqlexpress for excel files.
Username: Password:
AuthorTopic: Name of the sheets with sqlexpress for excel files.
César Calvo Name of the sheets with sqlexpress for excel files.
on Tue, 05 Feb 2013 06:01:11 +0100
Hello friends.

Can you tell me how to know the names of the sheets wirh SQLExpress when I 
open one excel file.

I mean :

One excel file whit three sheets (names MAD, ALI and BAR) and give this 
names in one array for to open one to one.

Thanks.
César.
Boris BorzicRe: Name of the sheets with sqlexpress for excel files.
on Tue, 05 Feb 2013 16:05:40 +0100
Csar Calvo <ccalvoc@telefonica.net> wrote in
news:5ee9c262$159bb72b$5280e@news.alaska-software.com: 

> Can you tell me how to know the names of the sheets wirh SQLExpress
> when I open one excel file.

Use the SQLListTables class to fetch the sheet names.

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools
César Calvo Re: Name of the sheets with sqlexpress for excel files.
on Sat, 16 Feb 2013 19:51:46 +0100
Boris, I don´t get it.
I am reaeding sqllisttables class but maybe me do something wrong.
Can you send me a litte source for to know the two names of this excel file?
Example one array with PROYECTOS and Hoja1, names of the shhets for it.
Thanks in advance.
My personal email is ccalvoc@telefonica.net or ccc@tid.es
Regards.

"Boris Borzic" escribió en el mensaje de 
noticias:XnsA15E66A927CDESQLExpress@87.106.143.233...
> César Calvo <ccalvoc@telefonica.net> wrote in
> news:5ee9c262$159bb72b$5280e@news.alaska-software.com:
>
>> Can you tell me how to know the names of the sheets wirh SQLExpress
>> when I open one excel file.
>
> Use the SQLListTables class to fetch the sheet names.
>
> -- 
> Best regards,
> Boris Borzic
>
> http://xb2.net
> http://sqlexpress.net
> industrial strength Xbase++ development tools


PROYECTOS.xlsx
César Calvo Re: Name of the sheets with sqlexpress for excel files.
on Sun, 17 Feb 2013 15:14:42 +0100
Boris, I got it and is fast and simple.
Quickly a private message form my personal email for you.
Thanks.

"César Calvo" <ccalvoc@telefonica.net> escribió en el mensaje de 
noticias:6e39862$5799b1e6$37850@news.alaska-software.com...
> Boris, I don´t get it.
> I am reaeding sqllisttables class but maybe me do something wrong.
> Can you send me a litte source for to know the two names of this excel 
> file?
> Example one array with PROYECTOS and Hoja1, names of the shhets for it.
> Thanks in advance.
> My personal email is ccalvoc@telefonica.net or ccc@tid.es
> Regards.
>
> "Boris Borzic" escribió en el mensaje de
> noticias:XnsA15E66A927CDESQLExpress@87.106.143.233...
>> César Calvo <ccalvoc@telefonica.net> wrote in
>> news:5ee9c262$159bb72b$5280e@news.alaska-software.com:
>>
>>> Can you tell me how to know the names of the sheets wirh SQLExpress
>>> when I open one excel file.
>>
>> Use the SQLListTables class to fetch the sheet names.
>>
>> -- 
>> Best regards,
>> Boris Borzic
>>
>> http://xb2.net
>> http://sqlexpress.net
>> industrial strength Xbase++ development tools
>