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 | 20 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 1 of 2 [1] 2 Next page →
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-10-14 02:17 -0700 |
| Subject | Looking 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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-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]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2014-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]
| From | "Fred Killet" <info@killetsoft.de> |
|---|---|
| Date | 2014-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]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-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]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | JohnMartens <martens@tennishulp.info> |
|---|---|
| Date | 2014-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2014-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