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


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

Looking for sample code for Excel (XLS) to DBF

Started by"Rene J. Pajaron" <rjpajaron@gmail.com>
First post2014-10-14 02:17 -0700
Last post2014-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


Contents

  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]


#7309

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-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]


#7303

FromJohnMartens <martens@tennishulp.info>
Date2014-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]


#7310

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-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]


#7321

FromJohnMartens <martens@tennishulp.info>
Date2014-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]


#7332

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-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]


#7319

FromSherlock <sherlock@sherlock.com.au>
Date2014-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]


#7320

FromJohnMartens <martens@tennishulp.info>
Date2014-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]


#7331

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-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