Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #929 > unrolled thread
| Started by | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| First post | 2011-04-24 18:55 +0200 |
| Last post | 2011-04-24 22:48 +0200 |
| Articles | 12 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2011-04-24 18:55 +0200 |
| Subject | DB2Excel 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]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2011-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2011-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]
| From | Karl Faller <k.faller_withoutthat_@onlinehome.de> |
|---|---|
| Date | 2011-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2011-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]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-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]
| From | Norbert Kolb <n.kolb_entferne_dies@aon.at> |
|---|---|
| Date | 2011-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2011-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