RE: [perl-win32-gui-users] getting data from listview and putting it in a MS Excel sheet

[Frazier, J. J. <Joe...@Pe...>]

Or you could use Win32::OLE and open an instance of Excel directly and
add the values.  Also, you could use the CPAN module:
Spreadsheet::WriteExcel to write the data to an excel spreadsheet. =20

As for reading the listview, you use the ItemInfo method on each "cell"
to get the data and then write that to the target xls file.

> -----Original Message-----
> From: Piske, Harald [mailto:Har...@bo...]
> Sent: Wednesday, October 17, 2001 1:25 PM
> To: 'Jos...@DM...';=20
> per...@li...
> Subject: RE: [perl-win32-gui-users] getting data from listview and
> putting it in a MS Excel sheet
>=20
>=20
> > I don't know if this is a win32:gui or a general perl=20
> > question but here it
> If you don't know how to read the stuff out of the listview,=20
> it's a GUI
> question, but I don't think you will be shot for asking about=20
> the other part
> ;-)
>=20
> What you want is Win32::ODBC, which can be used to access=20
> Excel files. Since
> it is not very funny to make a data source for each xls file,=20
> have a look at
> www.fairymails.com/perl/, there is "dbspy" which shows how to=20
> make temporary
> DSNs from within perl. There's no inline documentation -=20
> sorry. But it's
> just a couple of lines after /\.xls$/
>=20
> _______________________________________________
> Perl-Win32-GUI-Users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perl-win32-gui-users
>=20