Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #929 > unrolled thread

DB2Excel thx to german UG

Started byMassimo Bighelli <info@arcasistemi.it>
First post2011-04-24 18:55 +0200
Last post2011-04-24 22:48 +0200
Articles 12 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  DB2Excel thx to german UG Massimo Bighelli <info@arcasistemi.it> - 2011-04-24 18:55 +0200
    Re: DB2Excel thx to german UG Johan Nel <johan.nel@xsinet.co.za> - 2011-04-24 21:19 +0200
      Re: DB2Excel thx to german UG Massimo Bighelli <info@arcasistemi.it> - 2011-04-24 22:46 +0200
    Re: DB2Excel thx to german UG Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2011-04-24 22:20 +0200
      Re: DB2Excel thx to german UG Massimo Bighelli <info@arcasistemi.it> - 2011-04-24 22:47 +0200
        Re: DB2Excel thx to german UG "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-04-25 22:36 +0000
          Re: DB2Excel thx to german UG Massimo Bighelli <info@arcasistemi.it> - 2011-04-26 01:55 +0200
            Re: DB2Excel thx to german UG "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-04-26 22:25 +0000
              Re: DB2Excel thx to german UG Massimo Bighelli <info@arcasistemi.it> - 2011-04-27 12:53 +0200
                Re: DB2Excel thx to german UG "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-04-28 22:18 +0000
    Re: DB2Excel thx to german UG Norbert Kolb <n.kolb_entferne_dies@aon.at> - 2011-04-24 22:22 +0200
      Re: DB2Excel thx to german UG Massimo Bighelli <info@arcasistemi.it> - 2011-04-24 22:48 +0200

#929 — DB2Excel thx to german UG

FromMassimo Bighelli <info@arcasistemi.it>
Date2011-04-24 18:55 +0200
SubjectDB2Excel thx to german UG
Message-ID<ip1kkv$dn8$1@speranza.aioe.org>
Works perfectly, but:
because of the excel limit to 256 colums (versions XP and 2003) it's not 
possible to load a greater number of colums.
Seems starting with Excel 2007 this limit is 16000 colums.
So far so good.
Now I need the trick in order to know the Excel version installed, to 
properly manage user messages.
Some registry key?
Then I probably need to change something in DB2Excel code.
Is it possible in a simple way, without regenerate the ole classes?

Every comment is welcome.
Massimo

[toc] | [next] | [standalone]


#930

FromJohan Nel <johan.nel@xsinet.co.za>
Date2011-04-24 21:19 +0200
Message-ID<ip1t3i$bqd$1@dont-email.me>
In reply to#929
Hi Massimo,

Have you considered using the Excel html format?  Not sure if that will do 
the trick or get around the 256 column limit? I used the html formal to 
get around the csv 65k row limit, so might maybe do the trick?

HTH,

Johan Nel
Pretoria, South Africa.

On 2011/04/24 18:55, Massimo Bighelli wrote:
> Works perfectly, but:
> because of the excel limit to 256 colums (versions XP and 2003) it's not
> possible to load a greater number of colums.
> Seems starting with Excel 2007 this limit is 16000 colums.
> So far so good.
> Now I need the trick in order to know the Excel version installed, to
> properly manage user messages.
> Some registry key?
> Then I probably need to change something in DB2Excel code.
> Is it possible in a simple way, without regenerate the ole classes?
>
> Every comment is welcome.
> Massimo
>

[toc] | [prev] | [next] | [standalone]


#933

FromMassimo Bighelli <info@arcasistemi.it>
Date2011-04-24 22:46 +0200
Message-ID<ip2276$g2h$1@speranza.aioe.org>
In reply to#930
Johan,
it's an Excel limit (older versions), I don't think html make any 
difference.
Tried with vbs script, and the result it's the same.
Thx

Massimo

Il 24/04/2011 21:19, Johan Nel ha scritto:
> Hi Massimo,
>
> Have you considered using the Excel html format? Not sure if that will
> do the trick or get around the 256 column limit? I used the html formal
> to get around the csv 65k row limit, so might maybe do the trick?
>
> HTH,
>
> Johan Nel
> Pretoria, South Africa.
>

[toc] | [prev] | [next] | [standalone]


#931

FromKarl Faller <k.faller_withoutthat_@onlinehome.de>
Date2011-04-24 22:20 +0200
Message-ID<ve19r6h9nka5bpnprkd3ul5vij240lisfo@4ax.com>
In reply to#929
On Sun, 24 Apr 2011 18:55:07 +0200, Massimo Bighelli
<info@arcasistemi.it> wrote:

> it's not 
>possible to load a greater number of colums.
i wonder, what you store in a table with more than 256 columns...

Karl

[toc] | [prev] | [next] | [standalone]


#934

FromMassimo Bighelli <info@arcasistemi.it>
Date2011-04-24 22:47 +0200
Message-ID<ip228e$g2h$2@speranza.aioe.org>
In reply to#931
Karl...
DBF with indetermined number of columns, ie, I don't know how many 
columns will have the DBF file, and in certain circumstances this is 
quite large...

Massimo


Il 24/04/2011 22:20, Karl Faller ha scritto:
> On Sun, 24 Apr 2011 18:55:07 +0200, Massimo Bighelli
> <info@arcasistemi.it>  wrote:
>
>> it's not
>> possible to load a greater number of colums.
> i wonder, what you store in a table with more than 256 columns...
>
> Karl

[toc] | [prev] | [next] | [standalone]


#938

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-04-25 22:36 +0000
Message-ID<4db5f768$0$77730$c30e37c6@exi-reader.telstra.net>
In reply to#934
It sounds like poor DBF design then <g>.

"info@arcasistemi.it" <info@arcasistemi.it> wrote in message 
news:ip228e$g2h$2@speranza.aioe.org:

> Karl...
> DBF with indetermined number of columns, ie, I don't know how many
> columns will have the DBF file, and in certain circumstances this is
> quite large...
>
> Massimo
>
>
> Il 24/04/2011 22:20, Karl Faller ha scritto:
>
> > On Sun, 24 Apr 2011 18:55:07 +0200, Massimo Bighelli
> > <info@arcasistemi.it>  wrote:
> >
>
> >> it's not
> >> possible to load a greater number of colums.
>
> > i wonder, what you store in a table with more than 256 columns...
> >
> > Karl

[toc] | [prev] | [next] | [standalone]


#940

FromMassimo Bighelli <info@arcasistemi.it>
Date2011-04-26 01:55 +0200
Message-ID<ip51m0$ko6$1@speranza.aioe.org>
In reply to#938
Il 26/04/2011 00:36, Geoff Schaller ha scritto:
> It sounds like poor DBF design then <g>.
>

Why?
There is no problem managing a DBF, say, 30.000 records and 350 fields.
It's the result from a complex elab, and the field's number depends on 
user's choices...
Export 2 Excel it's a sort of interface to another reporting (existing) 
system <g>, and there is a limit in older Excel versions.
What can I do? Message the user that his version of Excel does not allow 
columns grater tha 256... and I am OK.

Massimo

[toc] | [prev] | [next] | [standalone]


#960

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-04-26 22:25 +0000
Message-ID<4db7464d$0$77725$c30e37c6@exi-reader.telstra.net>
In reply to#940
Massimo,

> There is no problem managing a DBF, say, 30.000 records and 350 fields.

I didn't say it wouldn't work, I said it was poor design. And it is. 350 
columns is basically stupid and I suspect lots of empty fields in 
certain types of rows. Even if all 350 columns are full on every rwo, I 
would find a way to obtain a logical grouping of the data and split the 
table up.

> It's the result from a complex elab, and the field's number depends on
> user's choices...

Precisely!

> Export 2 Excel it's a sort of interface to another reporting (existing)
> system <g>, and there is a limit in older Excel versions.
> What can I do? Message the user that his version of Excel does not allow
> columns grater tha 256... and I am OK.

Yes! Just get them to upgrade.
It would seem very reasonable to me.

Geoff

PS - this is a cost somewhere. For the lousy $280 it would cost to 
upgrade MS Office to 2010, can you tell me it would cost you less in 
hours to find a solution? <g>

[toc] | [prev] | [next] | [standalone]


#964

FromMassimo Bighelli <info@arcasistemi.it>
Date2011-04-27 12:53 +0200
Message-ID<ip8siv$qg8$1@speranza.aioe.org>
In reply to#960
Geoff,

>
> I didn't say it wouldn't work, I said it was poor design. And it is. 350
> columns is basically stupid

Nothing stupid in this. It's necessary and works perfectly.

> and I suspect lots of empty fields in certain types of rows.

Full. Only needed columns are created.

> Even if all 350 columns are full on every rwo, I would find a way to obtain a logical grouping of the data and split the
> table up.

Why? While in DBF (and into my app) I have no problem.
They asked me an Excel export for subsequnt elaboration in 3d party 
software, then why split data? They need all data in one datasheet.

> Yes! Just get them to upgrade.
> It would seem very reasonable to me.
> PS - this is a cost somewhere. For the lousy $280 it would cost to
> upgrade MS Office to 2010, can you tell me it would cost you less in
> hours to find a solution? <g>

Agree. Simply I don't like my app "crashes" because of Excel limit.

:-)

Massimo

[toc] | [prev] | [next] | [standalone]


#981

From"Geoff Schaller" <geoffx@softwarexobjectives.com.au>
Date2011-04-28 22:18 +0000
Message-ID<4db9e799$0$77723$c30e37c6@exi-reader.telstra.net>
In reply to#964
Ok, we take your word for it that 350 columns is reasonable. I don't 
believe you but hey <g> who cares. The issue is that they simply need to 
upgrade Excel. If they want open limit column counts then they need to 
use tools that scale accordingly.

Geoff



"info@arcasistemi.it" <info@arcasistemi.it> wrote in message 
news:ip8siv$qg8$1@speranza.aioe.org:

> Geoff,
>
>
> >
> > I didn't say it wouldn't work, I said it was poor design. And it is. 350
> > columns is basically stupid
>
>
> Nothing stupid in this. It's necessary and works perfectly.
>
>
> > and I suspect lots of empty fields in certain types of rows.
>
>
> Full. Only needed columns are created.
>
>
> > Even if all 350 columns are full on every rwo, I would find a way to obtain a logical grouping of the data and split the
> > table up.
>
>
> Why? While in DBF (and into my app) I have no problem.
> They asked me an Excel export for subsequnt elaboration in 3d party
> software, then why split data? They need all data in one datasheet.
>
>
> > Yes! Just get them to upgrade.
> > It would seem very reasonable to me.
> > PS - this is a cost somewhere. For the lousy $280 it would cost to
> > upgrade MS Office to 2010, can you tell me it would cost you less in
> > hours to find a solution? <g>
>
>
> Agree. Simply I don't like my app "crashes" because of Excel limit.
>
> :-)
>
> Massimo

[toc] | [prev] | [next] | [standalone]


#932

FromNorbert Kolb <n.kolb_entferne_dies@aon.at>
Date2011-04-24 22:22 +0200
Message-ID<4db48657$0$1577$91cee783@newsreader04.highway.telekom.at>
In reply to#929
Hi Massimo,

have a look to Class IMS Excel of DB2Excel. There is an ACCESS VersionReg.

Norbert

[toc] | [prev] | [next] | [standalone]


#935

FromMassimo Bighelli <info@arcasistemi.it>
Date2011-04-24 22:48 +0200
Message-ID<ip22a0$gq5$1@speranza.aioe.org>
In reply to#932
Norbert,

yesssssss
Thank you, I will see and let you informed

Massimo


Il 24/04/2011 22:22, Norbert Kolb ha scritto:
> Hi Massimo,
>
> have a look to Class IMS Excel of DB2Excel. There is an ACCESS VersionReg.
>
> Norbert
>

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web