From: Frazier, J. J. <Joe.Frazier@PeopleClick.com> - 2001-10-17 18:11:34
|
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: 'Joseph_Vieira@DMR.COM';=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 |