f



input / output information in Excel for Visual-Objects

https://yadi.sk/d/kz2IQc2vy2LfK
0
Yuri
11/11/2016 8:13:06 AM
comp.clipper.visual-objects 12618 articles. 0 followers. Post Follow

7 Replies
293 Views

Similar Articles

[PageSpeed] 1

Hi Yuri,

Could you tell us a Little bit more about this? What versions of excel? Excel automation or native file access?

/Mathias


Den fredag 11 november 2016 kl. 09:13:07 UTC+1 skrev Yuri Komarov:
> https://yadi.sk/d/kz2IQc2vy2LfK

0
Mathias
11/11/2016 10:09:07 AM
=D0=BF=D1=8F=D1=82=D0=BD=D0=B8=D1=86=D0=B0, 11 =D0=BD=D0=BE=D1=8F=D0=B1=D1=
=80=D1=8F 2016 =D0=B3., 12:09:08 UTC+2 =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=
=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8C Mathias =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=
=D0=B0=D0=BB:
> Hi Yuri,
>=20
> Could you tell us a Little bit more about this? What versions of excel? E=
xcel automation or native file access?
>=20
> /Mathias
>=20
>=20
> Den fredag 11 november 2016 kl. 09:13:07 UTC+1 skrev Yuri Komarov:
> > https://yadi.sk/d/kz2IQc2vy2LfK

On the basis of HBLibxl, I writed a library for Visual-Objects, which conta=
ins classes and methods LibXL.Dll

http://www.libxl.com/home.html
0
Yuri
11/11/2016 10:56:34 AM
=D0=BF=D1=8F=D1=82=D0=BD=D0=B8=D1=86=D0=B0, 11 =D0=BD=D0=BE=D1=8F=D0=B1=D1=
=80=D1=8F 2016 =D0=B3., 10:13:07 UTC+2 =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=
=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8C Yuri Komarov =D0=BD=D0=B0=D0=BF=D0=B8=
=D1=81=D0=B0=D0=BB:
> https://yadi.sk/d/kz2IQc2vy2LfK

Did some monitoring of the existing solutions to applied problems with MS E=
xcel. Have selected the most interesting, according to the criteria of func=
tionality, the ability to work with Visual-Objects, and availability (free =
of charge). Three of them are well earned:
1. Exceldll works through OLE, free.
2. XLSX I/O, read/write XlS/X files directly. Love this app, designed prima=
rily for tabular data, free.
3. LibXL reads/writes directly. Powerful, well-documented functionality, an=
d a paid one ($199).=20
0
Yuri
11/11/2016 11:08:32 AM
Hi Yuri,

> On the basis of HBLibxl, I writed a library for Visual-Objects, which
> contains classes and methods LibXL.Dll
>
> http://www.libxl.com/home.html

i know this DLL because some months ago i wrote a VO-(function only)
interface to access the DLL ( Version was at that time 3.6.5.0 )

How do your class trees look like ? Any (syntax) compatibilty with the well
known - but in the meantime out of business -  Excel-component "OLE XLSFile
" from "sm-software" ?

regards
Karl-Heinz
0
Karl
11/11/2016 1:05:39 PM
Hi Karl-Heinz,

for xls access personally I'm using OleXlsF from SM Software - works
very well.

For access to xlsx I have opted for the open source library (.NET)
EPPlus and added a COM wrapper using X# and a Side-by-Side activation
to use it in VO.

I can share my X# sources, if someone is interested. This wrapper is
one of my X# projects already in production.

Wolfgang

Karl-Heinz wrote:

> Hi Yuri,
> 
> > On the basis of HBLibxl, I writed a library for Visual-Objects,
> > which contains classes and methods LibXL.Dll
> > 
> > http://www.libxl.com/home.html
> 
> i know this DLL because some months ago i wrote a VO-(function only)
> interface to access the DLL ( Version was at that time 3.6.5.0 )
> 
> How do your class trees look like ? Any (syntax) compatibilty with
> the well known - but in the meantime out of business -
> Excel-component "OLE XLSFile " from "sm-software" ?
> 
> regards
> Karl-Heinz



-- 

0
Wolfgang
11/11/2016 2:38:03 PM
Hi Wolfgang,

> for xls access personally I'm using OleXlsF from SM Software - works
> very well.
>
> For access to xlsx I have opted for the open source library (.NET)
> EPPlus and added a COM wrapper using X# and a Side-by-Side activation
> to use it in VO.

yes, as you know, i´m using OleXlsF too and til now it works without any
problems even with win 10.

"xlsx" is not that important to me. i´m only interested  to know what
exactly Yuri does offer.

regards
Karl-Heinz 

0
Karl
11/12/2016 9:31:54 AM
=D0=BF=D1=8F=D1=82=D0=BD=D0=B8=D1=86=D0=B0, 11 =D0=BD=D0=BE=D1=8F=D0=B1=D1=
=80=D1=8F 2016 =D0=B3., 16:38:06 UTC+2 =D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D0=BE=
=D0=B2=D0=B0=D1=82=D0=B5=D0=BB=D1=8C Wolfgang Riedmann =D0=BD=D0=B0=D0=BF=
=D0=B8=D1=81=D0=B0=D0=BB:
> Hi Karl-Heinz,
>=20
> for xls access personally I'm using OleXlsF from SM Software - works
> very well.
>=20
> For access to xlsx I have opted for the open source library (.NET)
> EPPlus and added a COM wrapper using X# and a Side-by-Side activation
> to use it in VO.
>=20
> I can share my X# sources, if someone is interested. This wrapper is
> one of my X# projects already in production.
>=20
> Wolfgang
>=20
> Karl-Heinz wrote:
>=20
> > Hi Yuri,
> >=20
> > > On the basis of HBLibxl, I writed a library for Visual-Objects,
> > > which contains classes and methods LibXL.Dll
> > >=20
> > > http://www.libxl.com/home.html
> >=20
> > i know this DLL because some months ago i wrote a VO-(function only)
> > interface to access the DLL ( Version was at that time 3.6.5.0 )
> >=20
> > How do your class trees look like ? Any (syntax) compatibilty with
> > the well known - but in the meantime out of business -
> > Excel-component "OLE XLSFile " from "sm-software" ?
> >=20
> > regards
> > Karl-Heinz
>=20
>=20
>=20
> --
 Hi Karl-Heinz,
I wrote exclusively on the documentation of LibXL, also used the example fo=
r harbour. About OLE XLSFile don't know anything. OLE I have little interes=
t due to low speed.

Best regards,

Yuri
0
Yuri
11/12/2016 12:18:47 PM
Reply: