Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7294 > unrolled thread
| Started by | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| First post | 2014-10-14 02:17 -0700 |
| Last post | 2014-10-17 17:15 -0700 |
| Articles | 8 on this page of 28 — 6 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 02:17 -0700
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-14 11:50 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-14 12:00 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-14 15:14 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-14 23:17 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-15 07:35 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-15 10:57 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:37 -0700
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:15 -0700
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-15 07:39 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Fred Killet" <info@killetsoft.de> - 2014-10-14 16:06 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-14 16:23 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:55 -0700
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-15 10:55 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-15 20:05 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-16 20:15 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-16 22:52 +0200
Re: Looking for sample code for Excel (XLS) to DBF D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-10-17 11:59 +0200
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-17 15:02 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-10-14 17:24 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:49 -0700
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-14 16:20 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-14 20:50 -0700
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-16 19:05 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-17 17:18 -0700
Re: Looking for sample code for Excel (XLS) to DBF Sherlock <sherlock@sherlock.com.au> - 2014-10-16 00:36 -0700
Re: Looking for sample code for Excel (XLS) to DBF JohnMartens <martens@tennishulp.info> - 2014-10-16 14:02 +0200
Re: Looking for sample code for Excel (XLS) to DBF "Rene J. Pajaron" <rjpajaron@gmail.com> - 2014-10-17 17:15 -0700
Page 2 of 2 — ← Prev page 1 [2]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-10-14 20:49 -0700 |
| Message-ID | <90b17270-99ac-4547-9b29-2a4a0e31a5b2@googlegroups.com> |
| In reply to | #7302 |
Hi Fred, I have no idea on XLS format. I send reply to your PM. -- Rene On Tuesday, October 14, 2014 10:06:20 PM UTC+8, Fred Killet wrote: > Hello Rene, > > > > I am also interested to do convertings from Excel format XLS / XLSX to DBF > > or better CSV and backwards, but wihtout using OLE interface to Excel. Only > > the pure data convertion. But until now, I did not found any useful code. Do > > you have a detailled description of the XLS and/or XLSX format? > > > > More information I sent to your private Email address. > > > > Fred > > > > killet-nospam@killetsoft.de > > > > > > --- > > Diese E-Mail ist frei von Viren und Malware, denn der avast! Antivirus Schutz ist aktiv. > > http://www.avast.com
[toc] | [prev] | [next] | [standalone]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-10-14 16:20 +0200 |
| Message-ID | <m1jbek$95k$1@dont-email.me> |
| In reply to | #7294 |
I send you a PM with some code of mine. Hope it can help John Rene J. Pajaron schreef op 14-10-2014 om 11:17: > Hello, > > I am already testing some code that converts XLS to DBF, probably also for XLSX in later. > > The problem is I have Excel 2013, not an older Excel (before ribboned UI). > > -- > > Rene > > PS: I am downloading samples at http://www.voug-bodensee.net/ but it appears it only deals with DBF to Excel. >
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-10-14 20:50 -0700 |
| Message-ID | <7fdf28a3-6b6e-4b2e-b21a-f13800a33210@googlegroups.com> |
| In reply to | #7303 |
Hi John, Thanks. I will play on that one today. I will let you know. -- Rene On Tuesday, October 14, 2014 10:20:08 PM UTC+8, JohnMartens wrote: > I send you a PM with some code of mine. > > Hope it can help > > > > John > > > > > > Rene J. Pajaron schreef op 14-10-2014 om 11:17: > > > Hello, > > > > > > I am already testing some code that converts XLS to DBF, probably also for XLSX in later. > > > > > > The problem is I have Excel 2013, not an older Excel (before ribboned UI). > > > > > > -- > > > > > > Rene > > > > > > PS: I am downloading samples at http://www.voug-bodensee.net/ but it appears it only deals with DBF to Excel. > > >
[toc] | [prev] | [next] | [standalone]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-10-16 19:05 +0200 |
| Message-ID | <m1otsh$nl4$1@dont-email.me> |
| In reply to | #7310 |
There is (at least) one warning about using ODBC and the VO SQL classes. I sometimes have multiple rows/records that are filled with the exact same data. If you look in the XLS this is not true. I have these problems with XLS's where the last column is in some cases empty. These rows are shown INCORRECT by the SqlConnection. In my case I do not need this comlumn. I check for duplicate recods in my app and ask the user to delete this last column (using Excell of Calc) and save. Then there are no problems reading the data. Rene J. Pajaron schreef op 15-10-2014 om 5:50: > Hi John, > > Thanks. I will play on that one today. > > I will let you know. > > -- > > Rene > > On Tuesday, October 14, 2014 10:20:08 PM UTC+8, JohnMartens wrote: >> I send you a PM with some code of mine. >> >> Hope it can help >> >> >> >> John >> >> >> >> >> >> Rene J. Pajaron schreef op 14-10-2014 om 11:17: >> >>> Hello, >> >>> >> >>> I am already testing some code that converts XLS to DBF, probably also for XLSX in later. >> >>> >> >>> The problem is I have Excel 2013, not an older Excel (before ribboned UI). >> >>> >> >>> -- >> >>> >> >>> Rene >> >>> >> >>> PS: I am downloading samples at http://www.voug-bodensee.net/ but it appears it only deals with DBF to Excel. >> >>> >
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-10-17 17:18 -0700 |
| Message-ID | <0f3886ec-0216-4e76-9623-ad866ed8153d@googlegroups.com> |
| In reply to | #7321 |
Hi John, > > I sometimes have multiple rows/records that are filled with the exact > > same data. If you look in the XLS this is not true. > I will check that one. I am still in work in progress. Mostly on checking the column name legal within VO/DBF reserved words. > > > I have these problems with XLS's where the last column is in some cases > > empty. These rows are shown INCORRECT by the SqlConnection. > > > > In my case I do not need this comlumn. I check for duplicate recods in > > my app and ask the user to delete this last column (using Excell of > > Calc) and save. > > Then there are no problems reading the data. > > Reading wise, I see no problem, but yes, I see an empty records at the end. -- Rene
[toc] | [prev] | [next] | [standalone]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2014-10-16 00:36 -0700 |
| Message-ID | <a424e47b-dbfd-4ef9-9038-efe10b7316fb@googlegroups.com> |
| In reply to | #7294 |
Excel 2013 is zipped XML file. Why not open the ZIP and export the XML to DBF ?
[toc] | [prev] | [next] | [standalone]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-10-16 14:02 +0200 |
| Message-ID | <543FB3D6.30403@tennishulp.info> |
| In reply to | #7319 |
Because you will get loads of info (like markup) you do not need. Most of the times you only need de data in the sheet if you want to import and use it Sherlock schreef op 16-10-2014 om 9:36: > Excel 2013 is zipped XML file. Why not open the ZIP and export the XML to DBF ? >
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-10-17 17:15 -0700 |
| Message-ID | <ca72fba7-5d2f-4d43-b96c-94826faedd4b@googlegroups.com> |
| In reply to | #7319 |
On Thursday, October 16, 2014 3:36:18 PM UTC+8, Sherlock wrote: > Excel 2013 is zipped XML file. Why not open the ZIP and export the XML to DBF ? I will try this when native Excel 2013 file converter is required. -- Rene
[toc] | [prev] | [standalone]
Page 2 of 2 — ← Prev page 1 [2]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web