in reply to Re^2: SQL Database table to Perl Spreadsheet script
in thread SQL Database table to Perl Spreadsheet script

Sir.My question is to store the result in a spreadsheet.

so what kind of output do you get?

  • Comment on Re^3: SQL Database table to Perl Spreadsheet script

Replies are listed 'Best First'.
Re^4: SQL Database table to Perl Spreadsheet script
by dinkar (Initiate) on Oct 14, 2012 at 09:01 UTC
    I just get the heading in the output i.e., in the excel sheet also know as spreadsheet

      Ok, so the problem is with the while loop, either

      • the query returns zero rows
      • or you skip all the results
      • or write_row fails silently

      You can find out what the problem is by using print ( Basic debugging checklist )

      A reply falls below the community's threshold of quality. You may see it by logging in.