Re: Writing to multiple excel worksheets
On 17 sep 2007, at 23.00, SPJ wrote: Hi, I have a list which I need to write to excel worksheet. The list is like: data = ['IP1','21','ftp','\n','IP1','22','ssh','\n','IP2','22','ssh','\n','IP 2','23','telnet','\n'] Now the task is to create a workbook with tabbed sheet for each of the service's in the list i.e. tabs for ftp, ssh, telnet etc. The data needs to be written in the corresponding sheets. What is the best way to achieve this? I couldn't find much help on the internet nor in the earlier threads. Please help. Thanks, SPJ Excel files are in a binary and proprietary format. You can however generate tab-separated text files, which Excel can import. -- What is a woman that you forsake her, and the hearth fire and the home acre, to go with the old grey Widow Maker. --Kipling, harp song of the Dane women Tommy Nordgren [EMAIL PROTECTED] -- http://mail.python.org/mailman/listinfo/python-list
Re: Writing to multiple excel worksheets
On Tue, 2007-09-18 at 18:49 +0200, Tommy Nordgren wrote: Excel files are in a binary and proprietary format. True, but that doesn't mean you can't create them with free software. PyExcelerator (http://sourceforge.net/projects/pyexcelerator) can create Excel files. HTH, -- Carsten Haese http://informixdb.sourceforge.net -- http://mail.python.org/mailman/listinfo/python-list
Writing to multiple excel worksheets
Hi, I have a list which I need to write to excel worksheet. The list is like: data = ['IP1','21','ftp','\n','IP1','22','ssh','\n','IP2','22','ssh','\n','IP2','23','telnet','\n'] Now the task is to create a workbook with tabbed sheet for each of the service's in the list i.e. tabs for ftp, ssh, telnet etc. The data needs to be written in the corresponding sheets. What is the best way to achieve this? I couldn't find much help on the internet nor in the earlier threads. Please help. Thanks, SPJ - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. -- http://mail.python.org/mailman/listinfo/python-list