code_junkie

What charset does Microsoft Excel use when saving files

Nov 14th, 2011
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. #!perl
  2.  
  3. use strict;
  4.  
  5. use Spreadsheet::ParseExcel::Simple;
  6. use Encode qw( decode );
  7.  
  8. my $file = "my_spreadsheet.xls";
  9.  
  10. my $xls = Spreadsheet::ParseExcel::Simple->read( $file );
  11. my $sheet = [ $xls->sheets ]->[0];
  12.  
  13. while ($sheet->has_data) {
  14.  
  15. my @data = $sheet->next_row;
  16.  
  17. for my $datum ( @data ) {
  18. print decode( 'cp1250', $datum );
  19. }
  20.  
  21. }
Add Comment
Please, Sign In to add comment