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


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

Converting a file to Excel

Started byMartin <spam@spam.spam>
First post2013-12-16 09:08 +0000
Last post2013-12-19 15:01 +0000
Articles 18 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#6390 — Converting a file to Excel

FromMartin <spam@spam.spam>
Date2013-12-16 09:08 +0000
SubjectConverting 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]


#6391

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2013-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]


#6398

FromMartin <spam@spam.spam>
Date2013-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]


#6392

FromMalcolm G <malcolm-news2012delete@delete.jobstream.com>
Date2013-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]


#6396

FromMartin <spam@spam.spam>
Date2013-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]


#6394

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2013-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]


#6397

FromMartin <spam@spam.spam>
Date2013-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]


#6403

FromMartin <spam@spam.spam>
Date2013-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]


#6404

FromMartin <spam@spam.spam>
Date2013-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]


#6399

FromMartin <spam@spam.spam>
Date2013-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]


#6400

From"Craig Dawson" <craig_dawson@hotmail.com>
Date2013-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]


#6407

FromMartin <spam@spam.spam>
Date2013-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]


#6401

FromMartin <spam@spam.spam>
Date2013-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]


#6402

FromMartin <spam@spam.spam>
Date2013-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]


#6405

FromMartin <spam@spam.spam>
Date2013-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]


#6406

FromMartin <spam@spam.spam>
Date2013-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]


#6417

FromMartin <spam@spam.spam>
Date2013-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]


#6431

FromMartin <spam@spam.spam>
Date2013-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