Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^3: Write array contents to csv file

by poj (Priest)
on Jul 11, 2013 at 14:27 UTC ( #1043736=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Write array contents to csv file
in thread Write array contents to csv file

Are you viewing the csv file in Excel ? If so, rename it to report.xls and then see what you get.

poj


Comment on Re^3: Write array contents to csv file
Download Code
Re^4: Write array contents to csv file
by learner@perl (Novice) on Jul 11, 2013 at 14:53 UTC
    Hi,

    I can see the expected data, but after renaming the file from .csv to .xsl, i hope the data is saved in Text(Tab delimited, when i click on the .xsl file, its throwing an warning message like format is not supporting, the message is the file is in a different format than specified

    Thanks

      Excel xls format isn't the same as csv, so when you change a csv file extension to xls attempting to open it in Excel will fail. Excel should open csv files, if you actually want an Excel file see Spreadsheet::WriteExcel.

      If it is tab delimited why are you giving it the file extension .csv. ? I said xls not xsl. Anyway, what does the file look like in a text editor like notepad++.

      Update: If the message is 'The file you are trying to open is in a different format than specified by the file extension....Do you want to open the file now ? then select 'Yes'.
      poj

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1043736]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (13)
As of 2015-07-07 12:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls