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


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

input / output information in Excel for Visual-Objects

Started byYuri Komarov <komari2112@gmail.com>
First post2016-11-11 00:13 -0800
Last post2016-11-11 03:08 -0800
Articles 8 — 4 participants

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


Contents

  input / output information in Excel for Visual-Objects Yuri Komarov <komari2112@gmail.com> - 2016-11-11 00:13 -0800
    Re: input / output information in Excel for Visual-Objects Mathias <mathias.hakansson@consultec.se> - 2016-11-11 02:09 -0800
      Re: input / output information in Excel for Visual-Objects Yuri Komarov <komari2112@gmail.com> - 2016-11-11 02:56 -0800
        Re: input / output information in Excel for Visual-Objects "Karl-Heinz" <invalid@invalid.invalid> - 2016-11-11 14:05 +0100
          Re: input / output information in Excel for Visual-Objects "Wolfgang Riedmann" <wriedmann@gmail.com> - 2016-11-11 15:38 +0100
            Re: input / output information in Excel for Visual-Objects "Karl-Heinz" <invalid@invalid.invalid> - 2016-11-12 10:31 +0100
            Re: input / output information in Excel for Visual-Objects Yuri Komarov <komari2112@gmail.com> - 2016-11-12 04:18 -0800
    Re: input / output information in Excel for Visual-Objects Yuri Komarov <komari2112@gmail.com> - 2016-11-11 03:08 -0800

#9922 — input / output information in Excel for Visual-Objects

FromYuri Komarov <komari2112@gmail.com>
Date2016-11-11 00:13 -0800
Subjectinput / output information in Excel for Visual-Objects
Message-ID<0a128a5f-bf85-4331-b4af-426aae7927bb@googlegroups.com>
https://yadi.sk/d/kz2IQc2vy2LfK

[toc] | [next] | [standalone]


#9924

FromMathias <mathias.hakansson@consultec.se>
Date2016-11-11 02:09 -0800
Message-ID<88b3010c-c0c7-41e6-a0bf-56d169efe5ca@googlegroups.com>
In reply to#9922
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

[toc] | [prev] | [next] | [standalone]


#9926

FromYuri Komarov <komari2112@gmail.com>
Date2016-11-11 02:56 -0800
Message-ID<c270add4-9b65-45cd-a79e-9a9b4fa34d58@googlegroups.com>
In reply to#9924
пятница, 11 ноября 2016 г., 12:09:08 UTC+2 пользователь Mathias написал:
> 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

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

[toc] | [prev] | [next] | [standalone]


#9928

From"Karl-Heinz" <invalid@invalid.invalid>
Date2016-11-11 14:05 +0100
Message-ID<e8lu8bFgc0aU1@mid.individual.net>
In reply to#9926
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

[toc] | [prev] | [next] | [standalone]


#9929

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2016-11-11 15:38 +0100
Message-ID<e8m3ebFhkhiU1@mid.individual.net>
In reply to#9928
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



-- 

[toc] | [prev] | [next] | [standalone]


#9933

From"Karl-Heinz" <invalid@invalid.invalid>
Date2016-11-12 10:31 +0100
Message-ID<e8o62sF1stoU1@mid.individual.net>
In reply to#9929
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 

[toc] | [prev] | [next] | [standalone]


#9935

FromYuri Komarov <komari2112@gmail.com>
Date2016-11-12 04:18 -0800
Message-ID<6dc5e819-a2ab-40c6-9152-2dd160a59283@googlegroups.com>
In reply to#9929
пятница, 11 ноября 2016 г., 16:38:06 UTC+2 пользователь Wolfgang Riedmann написал:
> 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
> 
> 
> 
> --
 Hi Karl-Heinz,
I wrote exclusively on the documentation of LibXL, also used the example for harbour. About OLE XLSFile don't know anything. OLE I have little interest due to low speed.

Best regards,

Yuri

[toc] | [prev] | [next] | [standalone]


#9927

FromYuri Komarov <komari2112@gmail.com>
Date2016-11-11 03:08 -0800
Message-ID<6471405b-3a7b-4d39-ab48-e2c0c109a811@googlegroups.com>
In reply to#9922
пятница, 11 ноября 2016 г., 10:13:07 UTC+2 пользователь Yuri Komarov написал:
> https://yadi.sk/d/kz2IQc2vy2LfK

Did some monitoring of the existing solutions to applied problems with MS Excel. Have selected the most interesting, according to the criteria of functionality, 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 primarily for tabular data, free.
3. LibXL reads/writes directly. Powerful, well-documented functionality, and a paid one ($199). 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web