Re: comma quoted lists question

On Tue, 15 Jul 2008 06:09:10 -0700, cartercc wrote:

My users like to use Excel and I am not inclined to tell them they
can't, nor am I inclined to 'educate' them on making sure that Excel
doesn't change the file format. They honestly need the filtering and
sorting capabilities that Excel provides, as some of these files are 106
columns wide and thousands of rows deep. I have error checking in place
that rejects improperly formed files, which I define as producing
anything other than an X element array. However, this isn't
satisfactory, because I have the burden of reformatting the file.

Comments? Suggestions? Any module that automagically reformats files?
Will I have to write a reformatting script myself?

Thanks, CC.

There are many solutions to that. Like the others have said, educating
your users is a step in the right direction. Another possible solution is
using Excel files instead of CSV files. CPAN has a number of modules for
that in the Spreadsheet:: namespace.

Leon Timmermans
.

Relevant Pages

  • Re: Filling an Excel sheet
    ... write a script which creates a csv file (comma separated ... Educate the luser who insists on the excel sheet to do step 2. ...
    (comp.unix.shell)
  • Is there a maximum number of FIND functions?
    ... However, if I add another row, Excel tells me I have an error and ... highlights the very next FIND ... someone educate me? ... Also - I cannot seem to get this FIND to work to locate occurences of ...
    (microsoft.public.excel)
  • Re: Pack and Go
    ... do believe that he turned up reformatting the harddrive. ... However, I do have Excel, Word, Publisher, and Powerpoint ... >Office XP on your machine and switched operating systems ...
    (microsoft.public.powerpoint)
  • RE: Linking Excel file and Word File
    ... Excel shuts down to a recovered sheet and I am also getting the following ... installation including Office 2003 with all possible updates from Microsoft ... My first thought was a problem in the Registry, but reformatting the machine ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)
  • RE: When reinstalling Microsoft Word
    ... little more specific of the reformatting of the drive and how to avoid this? ... > and Excel program files are installed, ... >> I reinstall Word, Excel, and the other Microsoft products. ...
    (microsoft.public.word.docmanagement)