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