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 20 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 1 of 2  [1] 2  Next page →


#7294 — Looking for sample code for Excel (XLS) to DBF

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-10-14 02:17 -0700
SubjectLooking for sample code for Excel (XLS) to DBF
Message-ID<7fc961bd-e4be-4d9b-8249-6e9601fd7421@googlegroups.com>
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] | [next] | [standalone]


#7295

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2014-10-14 11:50 +0200
Message-ID<ca49utFd5qsU1@mid.individual.net>
In reply to#7294
Hi Rene,

> 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).

Excel 2013 can save also files in xls format (should be named
1997-2003).

It could be difficult to find Excel 2003 (Office XP seems to not work
on Windows 7, Office 2003 has some problems on Windows 8.1).
But if you need some samples, send me a sample file and I will import
it into Excel 2003 and save it there.

Wolfgang



-- 

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


#7296

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-10-14 12:00 +0200
Message-ID<tisp3ap1b77tolhgn8njk6ckledgue2g0v@4ax.com>
In reply to#7295
On Tue, 14 Oct 2014 11:50:22 +0200, "Wolfgang Riedmann"
<wriedmann@gmail.com> wrote:

Hello Wolfgang,

>It could be difficult to find Excel 2003 (Office XP seems to not work
>on Windows 7, Office 2003 has some problems on Windows 8.1).
>But if you need some samples, send me a sample file and I will import
>it into Excel 2003 and save it there.
>
No. Office 2003 works without any problems on Windows 8.1; it's the
only Office I use here (despite having licenses for later versions). 

Reasons: it's way faster, much more accessible with less clicking
around in ribbons and of course the native Save as of DBF files.


By the way, I use ribbons in Explorer and notice that it hardly ever
shows the tab I need. Suppose you want to copy a few files and paste
them somewhere else. With the ribbon that's:

1 Select the file
2 Click the Home tab
3 Choose Copy - the menu goes back to the File tab for unknown reasons
4 Click the Home tab again
5 Click Paste (or the new Copy/Move to)

I found similair inefficiencies in the Office ribbon and I am happy
that I still can install Office 2003.

Dick

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


#7299

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2014-10-14 15:14 +0200
Message-ID<ca4ltpFg7f0U1@mid.individual.net>
In reply to#7296
Hi Dick,

> > It could be difficult to find Excel 2003 (Office XP seems to not
> > work on Windows 7, Office 2003 has some problems on Windows 8.1).
> > But if you need some samples, send me a sample file and I will
> > import it into Excel 2003 and save it there.
> > 
> No. Office 2003 works without any problems on Windows 8.1; it's the
> only Office I use here (despite having licenses for later versions). 

I can confirm at least that Outlook 2003 does not work on Windows 8.1 -
the address autocompletion is completely failing when using Word as
email editor.

And it seems that Microsoft has also stopped the activation servers -
at least my last try to activate Office 2003 has failed with such a
message.

Wolfgang


-- 

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


#7306

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-10-14 23:17 +0200
Message-ID<p44r3alrk3ivqj1oeuse7h0rd80qmssabf@4ax.com>
In reply to#7299
On Tue, 14 Oct 2014 15:14:34 +0200, "Wolfgang Riedmann"
<wriedmann@gmail.com> wrote:

Hello Wolfgang,

>I can confirm at least that Outlook 2003 does not work on Windows 8.1 -
>the address autocompletion is completely failing when using Word as
>email editor.

I do not use Outlook as we have our own VO written mailclient iConnect
mail. We use Word and Excel and sometimes Powerpoint and these seems
to work fine. This site seems to suggest it all should work with
"minor issues":
http://www.howto-outlook.com/faq/win8upgrade.htm
>
>And it seems that Microsoft has also stopped the activation servers -
>at least my last try to activate Office 2003 has failed with such a
>message.
>

If you look at this link:
http://blogs.technet.com/b/office_sustained_engineering/archive/2014/04/08/farewell-office-2003.aspx

it says (april 2014):

Q: Will activation still work?
A: Yes, 2003 licenses will still activate as before.

Just 2 weeks ago I installed Office 2003 on my new i5 tablet with
W8.1. Although I can't remember having activated it (completely
forgotten that this was required) it says already activated when I
choose it now. 

Here are some solutions for failing activation:

http://pressf1.pcworld.co.nz/showthread.php?117976-Microsoft-no-longer-activating-Office-2003

(I think it was deleting the the Opa11.dat file and entering in the
product key again which helped me years ago with an activation issue)

Dick	

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


#7312

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2014-10-15 07:35 +0200
Message-ID<ca6fd2Fu9unU1@mid.individual.net>
In reply to#7306
Hi Dick,

> Just 2 weeks ago I installed Office 2003 on my new i5 tablet with
> W8.1. Although I can't remember having activated it (completely
> forgotten that this was required) it says already activated when I
> choose it now. 

Enterprise Office without activation need obviously is no problem.

Activating over the internet don't worked, and using the phone
activation I had a message like "this product is not more supported for
activation".

Wolfgang

-- 

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


#7316

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-10-15 10:57 +0200
Message-ID<pjds3a5avrig5ualnoq93j6a2gi0rpnc0i@4ax.com>
In reply to#7312
On Wed, 15 Oct 2014 07:35:31 +0200, "Wolfgang Riedmann"
<wriedmann@gmail.com> wrote:

Hello Wolfgang,


>Enterprise Office without activation need obviously is no problem.
>
>Activating over the internet don't worked, and using the phone
>activation I had a message like "this product is not more supported for
>activation".
>
I installed my working Office 2003 on W 8.1 from a simple regular
Office CD which I once had from the Microsoft ActionPack, I don't
think that this is an Enterprise Office. And the link I sent you
suggest that activation should still work for Office 2003.

So I guess there's something else wrong. You should also be able to
activate by phone.

Dick

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


#7308

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-10-14 20:37 -0700
Message-ID<371af0d7-9717-4a4b-8315-0ffc8d3379a3@googlegroups.com>
In reply to#7296
Hi Dick,

I found Office 2013 bit difficult to use in some areas.  Been using 2010 for awhile until I got an upgrade a month ago.  I also found 2013 slow.  Maybe because it synch with OneDrive.  I have no time at this point to explore.

--

Rene

On Tuesday, October 14, 2014 6:00:39 PM UTC+8, D. J. W. van Kooten wrote:
> On Tue, 14 Oct 2014 11:50:22 +0200, "Wolfgang Riedmann"
> 
> <wriedmann@gmail.com> wrote:
> 
> 
> 
> Hello Wolfgang,
> 
> 
> 
> >It could be difficult to find Excel 2003 (Office XP seems to not work
> 
> >on Windows 7, Office 2003 has some problems on Windows 8.1).
> 
> >But if you need some samples, send me a sample file and I will import
> 
> >it into Excel 2003 and save it there.
> 
> >
> 
> No. Office 2003 works without any problems on Windows 8.1; it's the
> 
> only Office I use here (despite having licenses for later versions). 
> 
> 
> 
> Reasons: it's way faster, much more accessible with less clicking
> 
> around in ribbons and of course the native Save as of DBF files.
> 
> 
> 
> 
> 
> By the way, I use ribbons in Explorer and notice that it hardly ever
> 
> shows the tab I need. Suppose you want to copy a few files and paste
> 
> them somewhere else. With the ribbon that's:
> 
> 
> 
> 1 Select the file
> 
> 2 Click the Home tab
> 
> 3 Choose Copy - the menu goes back to the File tab for unknown reasons
> 
> 4 Click the Home tab again
> 
> 5 Click Paste (or the new Copy/Move to)
> 
> 
> 
> I found similair inefficiencies in the Office ribbon and I am happy
> 
> that I still can install Office 2003.
> 
> 
> 
> Dick

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


#7307

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-10-14 20:15 -0700
Message-ID<18f067c0-43a0-46ce-b56f-079bf1ea09e7@googlegroups.com>
In reply to#7295
Hi Wolfgang,

I will send you a sample file today.

Clients have variety of Excel file versions, and I want them to standardized to XLS format to get a hassle free conversion to DBF.

This Excel file is payroll deduction of employees for payments of their individual loans in company's credit union.

The Excel file company's accounting sending to credit union is in XLS file format.  I cannot identify which Excel version it was created.

Just started the other day experimenting sample VO codes...

--

Rene
 
On Tuesday, October 14, 2014 5:50:23 PM UTC+8, Wolfgang Riedmann wrote:
> Hi Rene,
> 
> 
> 
> > 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).
> 
> 
> 
> Excel 2013 can save also files in xls format (should be named
> 
> 1997-2003).
> 
> 
> 
> It could be difficult to find Excel 2003 (Office XP seems to not work
> 
> on Windows 7, Office 2003 has some problems on Windows 8.1).
> 
> But if you need some samples, send me a sample file and I will import
> 
> it into Excel 2003 and save it there.
> 
> 
> 
> Wolfgang
> 
> 
> 
> 
> 
> 
> 
> --

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


#7313

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2014-10-15 07:39 +0200
Message-ID<ca6fk3FubgqU1@mid.individual.net>
In reply to#7307
Hi Rene,


> I will send you a sample file today.

I have received it, but since I'm out of office today I cannot start my
XP test machine with Office 2003 (it's a physical machine, my last
resort for compiling my Clipper applications, as the clipper compiler
works very bad on virtualized machines).

I'll let you know this evening when I return to my office.

Wolfgang

-- 

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


#7302

From"Fred Killet" <info@killetsoft.de>
Date2014-10-14 16:06 +0200
Message-ID<m1jakr$iqu$1@news.albasani.net>
In reply to#7294
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]


#7304

FromJohnMartens <martens@tennishulp.info>
Date2014-10-14 16:23 +0200
Message-ID<m1jbki$agd$1@dont-email.me>
In reply to#7302
Im using the SQL driver that seems to be there on any windows system to 
open the XLS, analyse the columns and write to

This is an app I made in VO to export data:
http://www.tennishulp.info/SqlFileInfo/SQLFILEINFO.HTM

If it works in the app, you can get the DBF conversion from Rene soon. I 
send him some code from my SqlFileInfo window

John


Fred Killet schreef op 14-10-2014 om 16:06:
> 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]


#7311

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2014-10-14 20:55 -0700
Message-ID<7e31d8e8-c2e6-4b1f-a04c-e21a535c63c9@googlegroups.com>
In reply to#7304
John,

Thanks for sample code.

--

Rene

On Tuesday, October 14, 2014 10:23:18 PM UTC+8, JohnMartens wrote:
> Im using the SQL driver that seems to be there on any windows system to 
> 
> open the XLS, analyse the columns and write to
> 
> 
> 
> This is an app I made in VO to export data:
> 
> http://www.tennishulp.info/SqlFileInfo/SQLFILEINFO.HTM
> 
> 
> 
> If it works in the app, you can get the DBF conversion from Rene soon. I 
> 
> send him some code from my SqlFileInfo window
> 
> 
> 
> John
> 
> 
> 
> 
> 
> Fred Killet schreef op 14-10-2014 om 16:06:
> 
> > 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]


#7315

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-10-15 10:55 +0200
Message-ID<5cds3ap9ks20go405rloecllbql9b52u94@4ax.com>
In reply to#7304
On Tue, 14 Oct 2014 16:23:24 +0200, JohnMartens
<martens@tennishulp.info> wrote:

Hello John,

>Im using the SQL driver that seems to be there on any windows system to 
>open the XLS, analyse the columns and write to
>
>This is an app I made in VO to export data:
>http://www.tennishulp.info/SqlFileInfo/SQLFILEINFO.HTM


Sounds very interesting but I can't get it to work. I created a simple
.xls called testimport, with 3 rows of tekst (e.g. 3 fieldcontents or
1 header and 2 fieldcontents). I click the Open button and then I am
instructed to change select1 to the name of the sheet, so I changed it
to:

SELECT * FROM [testimport$]

When I check .CSV and click Select it shows:

Error in selection
SQLSTATEMENT: [Microsoft][ODBC Excel Driver] 'testimport$' is not a
valid name.  Make sure that it does not include invalid characters or
punctuation and that it is not too long.

What should I do dofferently? It sounds very interesting to create DBF
files from Excel without the need for Office 2003.

Dick

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


#7318

FromJohnMartens <martens@tennishulp.info>
Date2014-10-15 20:05 +0200
Message-ID<m1md0s$v8j$1@dont-email.me>
In reply to#7315
Hi Dick,

Is the name of the first (and only) tab testimport ?

This works for me:
https://dl.dropboxusercontent.com/u/89759326/BeursKoers.xls
Open the file and use the select statement:
SELECT * FROM [Data$]
On my PC there are 996 rows found that can be exported to CSV without 
problem.

Does that work for you ?

John


D.J.W. van Kooten schreef op 15-10-2014 om 10:55:
> On Tue, 14 Oct 2014 16:23:24 +0200, JohnMartens
> <martens@tennishulp.info> wrote:
>
> Hello John,
>
>> Im using the SQL driver that seems to be there on any windows system to
>> open the XLS, analyse the columns and write to
>>
>> This is an app I made in VO to export data:
>> http://www.tennishulp.info/SqlFileInfo/SQLFILEINFO.HTM
>
>
> Sounds very interesting but I can't get it to work. I created a simple
> .xls called testimport, with 3 rows of tekst (e.g. 3 fieldcontents or
> 1 header and 2 fieldcontents). I click the Open button and then I am
> instructed to change select1 to the name of the sheet, so I changed it
> to:
>
> SELECT * FROM [testimport$]
>
> When I check .CSV and click Select it shows:
>
> Error in selection
> SQLSTATEMENT: [Microsoft][ODBC Excel Driver] 'testimport$' is not a
> valid name.  Make sure that it does not include invalid characters or
> punctuation and that it is not too long.
>
> What should I do dofferently? It sounds very interesting to create DBF
> files from Excel without the need for Office 2003.
>
> Dick
>

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


#7322

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-10-16 20:15 +0200
Message-ID<vm204ad0s0vk7tjtsj5sbkh5fgp6vvhvi8@4ax.com>
In reply to#7318
On Wed, 15 Oct 2014 20:05:29 +0200, JohnMartens
<martens@tennishulp.info> wrote:

Hello John,

>Is the name of the first (and only) tab testimport ?

Ah, I understand it now. I filled in the filename instead of the
tabname (which is Blad1 in Dutch). With SELECT * FROM [Blad1$] this it
works.

Thanks a lot!

Dick

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


#7323

FromJohnMartens <martens@tennishulp.info>
Date2014-10-16 22:52 +0200
Message-ID<m1pb56$aja$1@dont-email.me>
In reply to#7322
Zo zit dat !! Fijn dat het werkt

Do you need any more VO code to get it into your app ?



D.J.W. van Kooten schreef op 16-10-2014 om 20:15:
> On Wed, 15 Oct 2014 20:05:29 +0200, JohnMartens
> <martens@tennishulp.info> wrote:
>
> Hello John,
>
>> Is the name of the first (and only) tab testimport ?
>
> Ah, I understand it now. I filled in the filename instead of the
> tabname (which is Blad1 in Dutch). With SELECT * FROM [Blad1$] this it
> works.
>
> Thanks a lot!
>
> Dick
>

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


#7328

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-10-17 11:59 +0200
Message-ID<eap14ahud0p0253d0q4308f3gh54o47uee@4ax.com>
In reply to#7323
On Thu, 16 Oct 2014 22:52:05 +0200, JohnMartens
<martens@tennishulp.info> wrote:

Hello John,


>
>Do you need any more VO code to get it into your app ?
>

That might be a good idea. I assume that I need to use your use
MTCS_ALG.DLL?

For now, I have installed the exe  as an alternative for Excel 2003,
in case I ever go to a newer version of Office. But if I can use some
of the functionality straight from VO, then this could come very handy
one day too if it's not too much trouble to explain how.

Dick

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


#7330

FromJohnMartens <martens@tennishulp.info>
Date2014-10-17 15:02 +0200
Message-ID<m1r407$3pj$1@dont-email.me>
In reply to#7328
I think Rene made a separate class for the conversion with some of my 
code in it.
Then you do not need my app at all

John


D.J.W. van Kooten schreef op 17-10-2014 om 11:59:
> On Thu, 16 Oct 2014 22:52:05 +0200, JohnMartens
> <martens@tennishulp.info> wrote:
>
> Hello John,
>
>
>>
>> Do you need any more VO code to get it into your app ?
>>
>
> That might be a good idea. I assume that I need to use your use
> MTCS_ALG.DLL?
>
> For now, I have installed the exe  as an alternative for Excel 2003,
> in case I ever go to a newer version of Office. But if I can use some
> of the functionality straight from VO, then this could come very handy
> one day too if it's not too much trouble to explain how.
>
> Dick
>

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


#7305

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2014-10-14 17:24 +0200
Message-ID<ca4ti6Fi7piU1@mid.individual.net>
In reply to#7302
Hi Fred,

> 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?

the XLS format is a very complex format.

I'm using the OleXlsFile from http://sm-software.com/ very
successfully. It is a very small OLE DLL, usable with SideBySide,
without all the regsvr32 hassles.

If you buy this cheap DLL, I can give you the manifest and a demo
application I made for an italian usergroup to demonstrate SxS.

Wolfgang


-- 

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


Page 1 of 2  [1] 2  Next page →

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


csiph-web