write data to Excel.vi without activeX

[Patekkio]

Does anybody have something like 'write to Excel.vi' that writes data directly into a xls formatted spreadsheet file WITHOUT activeX that requires Excel installed on the PC?
Of course 'write to spreadshet file.vi' is not good as long as it stores characters.
Thanks in advance
Giovanni Moschioni, Italy

[CraigGraham]

I'm not speaking from an informed viewpoint but Microsoft seem quite
jealously protective of their file formats and take a dim view of people
reverse engineering them in order to do this kind of thing. I'm not sure how
the Star Office people got away with it.

Why do you need to generate a .xls spreadsheet on a machine without Excel
installed? You can't see it unless you explicitly move it to a machine that
does have Excel and then manually load it- in which case there seems little
difference from manually loading a text file created by "Write to
Spreadsheet File". I'm not sure what you mean when you say the spreadsheet
file VIs are unsuitable because they "store characters"...

studiogamma wrote in message
news:50650000000800000077170000-984280909000@qu
iq.com...
> Does anybody have something like 'write to Excel.vi' that writes data
> directly into a xls formatted spreadsheet file WITHOUT activeX that
> requires Excel installed on the PC?
> Of course 'write to spreadshet file.vi' is not good as long as it
> stores characters.
> Thanks in advance
> Giovanni Moschioni, Italy

[Sergey Krasnishov]

studiogamma wrote:

> Does anybody have something like 'write to Excel.vi' that writes data
> directly into a xls formatted spreadsheet file WITHOUT activeX that
> requires Excel installed on the PC?
> Of course 'write to spreadshet file.vi' is not good as long as it
> stores characters.
> Thanks in advance
> Giovanni Moschioni, Italy

I have some experience and draft vi's of direct reading from binary .xls
files. Write didn't tried, but it's possible as well. MSDN library
contain format description and you can wire this vi's yourself. Rather
tricky to parse (or prepare) OLE binary .xls file structure though.

--
Sergey Krasnishov
____________________________________
Automated Control Systems
National Instruments Alliance Member
Moscow, Russia
sergey_a
cs@levsha.ru
http://acs.levsha.ru

[max]

Well, there is a way to write data to Excel without ActiveX.
Use the DDE possibilities of Excel.
There are different possibilities.

One example: use LV as a DDE server and write an Excel macro that uses "DDE
request" to get that data, then write that data to your Excel table.

Max

-> max.weiss@gmx.de / max@web.de <-
-> Max Weiß * Eulenweg 2 * 76356 Weingarten * Germany <-
-> Fax: 0180 505254775181 * Tel: 0175 1228001 * DB 8 MWE <-