Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #6390 > unrolled thread
| Started by | Martin <spam@spam.spam> |
|---|---|
| First post | 2013-12-16 09:08 +0000 |
| Last post | 2013-12-19 15:01 +0000 |
| Articles | 18 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 09:08 +0000
Re: Converting a file to Excel "Wolfgang Riedmann" <wriedmann@gmail.com> - 2013-12-16 11:06 +0100
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:50 +0000
Re: Converting a file to Excel Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2013-12-16 10:30 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:48 +0000
Re: Converting a file to Excel D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2013-12-16 11:36 +0100
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:49 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:56 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 14:02 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:53 +0000
Re: Converting a file to Excel "Craig Dawson" <craig_dawson@hotmail.com> - 2013-12-17 00:57 +1100
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 14:03 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:55 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:56 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 13:58 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-16 14:02 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-18 13:22 +0000
Re: Converting a file to Excel Martin <spam@spam.spam> - 2013-12-19 15:01 +0000
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 09:08 +0000 |
| Subject | Converting a file to Excel |
| Message-ID | <dqzru.26203$hz3.6783@fx16.fr7> |
Hello We need to write a file in Excel format a basic XLS. This is for a embedded system and we do not know much at the moment.
[toc] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2013-12-16 11:06 +0100 |
| Message-ID | <bh81l6FeqlqU1@mid.individual.net> |
| In reply to | #6390 |
Hi Martin, > We need to write a file in Excel format a basic XLS. > > This is for a embedded system and we do not know much at the moment. AFAIK you have two possibilities: - use OLE Automation using an installed Excel - use a 3rd party OLE control (I'm using OLEXLSFile from www.sm-software.com, a small, fast and not to expensive control) Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:50 +0000 |
| Message-ID | <_xDru.38169$JI2.6751@fx02.fr7> |
| In reply to | #6391 |
Thanks will check there On 16/12/2013 10:06, Wolfgang Riedmann wrote: > Hi Martin, > >> We need to write a file in Excel format a basic XLS. >> >> This is for a embedded system and we do not know much at the moment. > > AFAIK you have two possibilities: > > - use OLE Automation using an installed Excel > - use a 3rd party OLE control (I'm using OLEXLSFile from > www.sm-software.com, a small, fast and not to expensive control) > > Wolfgang > > >
[toc] | [prev] | [next] | [standalone]
| From | Malcolm G <malcolm-news2012delete@delete.jobstream.com> |
|---|---|
| Date | 2013-12-16 10:30 +0000 |
| Message-ID | <OCAru.25105$k7.12024@fx16.am4> |
| In reply to | #6390 |
On 16/12/2013 09:08, Martin wrote: > Hello > > We need to write a file in Excel format a basic XLS. > > This is for a embedded system and we do not know much at the moment. I would probably want to be clear up front whether it is XLS (BIFF) or XLSX you want? Also over the years we have dealt with a number of versions of XLS, there used to be some old ones that didn't use the COM wrapper.
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:48 +0000 |
| Message-ID | <pwDru.38167$JI2.7382@fx02.fr7> |
| In reply to | #6392 |
We do not have much info yet. On 16/12/2013 10:30, Malcolm G wrote: > On 16/12/2013 09:08, Martin wrote: >> Hello >> >> We need to write a file in Excel format a basic XLS. >> >> This is for a embedded system and we do not know much at the moment. > > I would probably want to be clear up front whether it is XLS (BIFF) or > XLSX you want? > > Also over the years we have dealt with a number of versions of XLS, > there used to be some old ones that didn't use the COM wrapper. > >
[toc] | [prev] | [next] | [standalone]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2013-12-16 11:36 +0100 |
| Message-ID | <jolta99eks5u2tt4o57ghvieg876ed70dr@4ax.com> |
| In reply to | #6390 |
On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: Hello Martin, > >We need to write a file in Excel format a basic XLS. >This is for a embedded system and we do not know much at the moment. Depending on the Excel reading it, and the data you need to have in it, you may even succeed with the old trick of creating a DBF and renaming it to XLS. Older versions of Excel convert it without asking to real XLS, I am not sure if newer versions do that too; you can try that. Of course it only works if you need data in the XLS, not formulas etc. Dick
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:49 +0000 |
| Message-ID | <KxDru.38168$JI2.1832@fx02.fr7> |
| In reply to | #6394 |
We do not know yet which version, we are just surprised that they require such a strange format. First thing I said was CSV! On 16/12/2013 10:36, D.J.W. van Kooten wrote: > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >> We need to write a file in Excel format a basic XLS. >> This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:56 +0000 |
| Message-ID | <iEDru.106$hR4.45@fx23.fr7> |
| In reply to | #6397 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 13:49, Martin wrote: > We do not know yet which version, we are just surprised that they > require such a strange format. > > First thing I said was CSV! > > > > > > On 16/12/2013 10:36, D.J.W. van Kooten wrote: >> On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: >> >> Hello Martin, >>> >>> We need to write a file in Excel format a basic XLS. >>> This is for a embedded system and we do not know much at the moment. >> >> Depending on the Excel reading it, and the data you need to have in >> it, you may even succeed with the old trick of creating a DBF and >> renaming it to XLS. Older versions of Excel convert it without asking >> to real XLS, I am not sure if newer versions do that too; you can try >> that. >> >> Of course it only works if you need data in the XLS, not formulas etc. >> >> Dick >> > On 16/12/2013 13:49, Martin wrote: > We do not know yet which version, we are just surprised that they > require such a strange format. > > First thing I said was CSV! > > > > > > On 16/12/2013 10:36, D.J.W. van Kooten wrote: >> On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: >> >> Hello Martin, >>> >>> We need to write a file in Excel format a basic XLS. >>> This is for a embedded system and we do not know much at the moment. >> >> Depending on the Excel reading it, and the data you need to have in >> it, you may even succeed with the old trick of creating a DBF and >> renaming it to XLS. Older versions of Excel convert it without asking >> to real XLS, I am not sure if newer versions do that too; you can try >> that. >> >> Of course it only works if you need data in the XLS, not formulas etc. >> >> Dick >> >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 14:02 +0000 |
| Message-ID | <6JDru.26204$hz3.16907@fx16.fr7> |
| In reply to | #6397 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 13:49, Martin wrote: > We do not know yet which version, we are just surprised that they > require such a strange format. > > First thing I said was CSV! > > > > > > On 16/12/2013 10:36, D.J.W. van Kooten wrote: >> On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: >> >> Hello Martin, >>> >>> We need to write a file in Excel format a basic XLS. >>> This is for a embedded system and we do not know much at the moment. >> >> Depending on the Excel reading it, and the data you need to have in >> it, you may even succeed with the old trick of creating a DBF and >> renaming it to XLS. Older versions of Excel convert it without asking >> to real XLS, I am not sure if newer versions do that too; you can try >> that. >> >> Of course it only works if you need data in the XLS, not formulas etc. >> >> Dick >> > On 16/12/2013 13:49, Martin wrote: > We do not know yet which version, we are just surprised that they > require such a strange format. > > First thing I said was CSV! > > > > > > On 16/12/2013 10:36, D.J.W. van Kooten wrote: >> On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: >> >> Hello Martin, >>> >>> We need to write a file in Excel format a basic XLS. >>> This is for a embedded system and we do not know much at the moment. >> >> Depending on the Excel reading it, and the data you need to have in >> it, you may even succeed with the old trick of creating a DBF and >> renaming it to XLS. Older versions of Excel convert it without asking >> to real XLS, I am not sure if newer versions do that too; you can try >> that. >> >> Of course it only works if you need data in the XLS, not formulas etc. >> >> Dick >> >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:53 +0000 |
| Message-ID | <VADru.75$iL2.17@fx29.fr7> |
| In reply to | #6394 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 10:36, D.J.W. van Kooten wrote: > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >> We need to write a file in Excel format a basic XLS. >> This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick >
[toc] | [prev] | [next] | [standalone]
| From | "Craig Dawson" <craig_dawson@hotmail.com> |
|---|---|
| Date | 2013-12-17 00:57 +1100 |
| Message-ID | <l8n0sk$qj7$1@dont-email.me> |
| In reply to | #6394 |
Hi Martin, we do the same thing as Dick mentioned and it works great! - Craig Dawson "D.J.W. van Kooten" <vankooten@removethis.ic2.com> wrote in message news:jolta99eks5u2tt4o57ghvieg876ed70dr@4ax.com... > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >>We need to write a file in Excel format a basic XLS. >>This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 14:03 +0000 |
| Message-ID | <cKDru.26206$hz3.11534@fx16.fr7> |
| In reply to | #6400 |
I am getting a LOT of errors from the NG at the moment, sorry about the millions of posts On 16/12/2013 13:57, Craig Dawson wrote: > Hi Martin, we do the same thing as Dick mentioned and it works great! > - Craig Dawson > > "D.J.W. van Kooten" <vankooten@removethis.ic2.com> wrote in message > news:jolta99eks5u2tt4o57ghvieg876ed70dr@4ax.com... >> On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: >> >> Hello Martin, >>> >>> We need to write a file in Excel format a basic XLS. >>> This is for a embedded system and we do not know much at the moment. >> >> Depending on the Excel reading it, and the data you need to have in >> it, you may even succeed with the old trick of creating a DBF and >> renaming it to XLS. Older versions of Excel convert it without asking >> to real XLS, I am not sure if newer versions do that too; you can try >> that. >> >> Of course it only works if you need data in the XLS, not formulas etc. >> >> Dick > >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:55 +0000 |
| Message-ID | <zCDru.76$iL2.4@fx29.fr7> |
| In reply to | #6394 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 10:36, D.J.W. van Kooten wrote: > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >> We need to write a file in Excel format a basic XLS. >> This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:56 +0000 |
| Message-ID | <_DDru.333$g8.260@fx07.fr7> |
| In reply to | #6394 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 10:36, D.J.W. van Kooten wrote: > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >> We need to write a file in Excel format a basic XLS. >> This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick > Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header.
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 13:58 +0000 |
| Message-ID | <aJDru.26205$hz3.22285@fx16.fr7> |
| In reply to | #6394 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 10:36, D.J.W. van Kooten wrote: > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >> We need to write a file in Excel format a basic XLS. >> This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-16 14:02 +0000 |
| Message-ID | <aJDru.28674$I81.15810@fx30.fr7> |
| In reply to | #6394 |
Haven't heard of this trick but I had assumed that you could possibly write a CSV but use diffrent delimeters ect. As elsewhere we still need more details to version required ect. But the fact they want to use XL5 worries us a little as all other machines of that type use either SDF style text files, human readable codes with data after them or a fixed format file like a DBF but no header. On 16/12/2013 10:36, D.J.W. van Kooten wrote: > On Mon, 16 Dec 2013 09:08:52 +0000, Martin <spam@spam.spam> wrote: > > Hello Martin, >> >> We need to write a file in Excel format a basic XLS. >> This is for a embedded system and we do not know much at the moment. > > Depending on the Excel reading it, and the data you need to have in > it, you may even succeed with the old trick of creating a DBF and > renaming it to XLS. Older versions of Excel convert it without asking > to real XLS, I am not sure if newer versions do that too; you can try > that. > > Of course it only works if you need data in the XLS, not formulas etc. > > Dick >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-18 13:22 +0000 |
| Message-ID | <wjhsu.35519$I81.34103@fx30.fr7> |
| In reply to | #6390 |
More information Not being read by Excel it appears, but some software on a Chinese machine reading the things. Got another one now from today for Friday (taking the pee this!) Anyway I have 3 files 1 is a DBF renamed 2 is a CSV renamed 3 is a tab seperated renamed DBF was OK but row 1 was the field names 2 loaded wrongly 3 moaned but loaded OK Thoguht about getting template and FWRITEing the sizes, can't see how hey are stored
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2013-12-19 15:01 +0000 |
| Message-ID | <1TDsu.45522$UJ1.37010@fx18.fr7> |
| In reply to | #6390 |
OK this is how it went Three files 1 DBF 2 CSV 3 Tab SV No 3 Tab SV was read in so as simple as writing a string with tabs and crlfs in it! Thanks Martin
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web