Thread Excel Datei einlesen und schreiben mit Umlauten (8 answers)
Opened by Jürgen at 2013-10-21 17:52

Gast Jürgen
 2013-10-22 10:16
#171390 #171390
Hallo Raubtier,

anbei der gewünschte Code:
Code (perl): (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
use strict;
use warnings;

use Spreadsheet::XLSX;
use Excel::Writer::XLSX;

my $workbook = Spreadsheet::XLSX->new("mappe1.xlsx");
my $worksheet = $workbook->worksheet("Tabelle1");
my $cell = $worksheet->get_cell( 2, 1 );
print $cell->value()."\n";
print $cell->encoding()."\n";

my $fuer = $cell->value();

my $workbook_write = Excel::Writer::XLSX->new( "mappe2.xlsx" );
my $new_sheet = $workbook_write->add_worksheet( "Tabelle1" );
$new_sheet->write_string( 1, 1, $fuer);


Grüße
Jürgen
Last edited: 2013-10-22 11:02:21 +0200 (CEST)

View full thread Excel Datei einlesen und schreiben mit Umlauten